Sean Killeen bio photo

Sean Killeen

Just a guy trying to get better at writing bios.

Email Twitter Facebook Google+ LinkedIn Instagram Github Stackoverflow Foursquare
Edit this page | Issue? Question?

Problem

I added a table in Excel 2010 and now I need to get rid of the table aspect and make them normal cells again.

Just changing the formatting to “Normal” doesn’t remove the programmatic features of table formatting (I can still sort my data as a table, etc. which I don’t want to be able to do.

Solution

This is called “converting to a range.” To convert a table back to a range:

  • Highlight the table in your spreadsheet
  • The Design tab will appear on the ribbon menu. Click it to enter the design section.
  • In the design section, click the Convert to Range button.
  • Excel will ask you if you’re sure. Click Yes.
  • The range will be converted to normal cells.

Hope this helps!