Posts Tagged ‘Excel 2007 Table’

How To Convert An Excel 2007 Table Back To A Normal Range

Sunday, May 10th, 2009


Time-saving tips for Microsoft Excel 2007, 2003, 2002, 2000 from

After you create a table in Microsoft Excel 2007, you may want to convert it back to a normal range.

Note that when you convert a table to a normal range, the row headers will no longer include the sort and filter arrows and the structured references  (i.e. table name and column header references that are used in the table formulas) will be converted back to regular references.

Convert Excel 2007 Table To A Normal Range:

1) Right-click any cell within the table;
2) On the pop-up menu point to Table, then Convert to Range. You will be asked to confirm your action with a message “Do you want to convert the table to a normal range?

Note that after you convert the table back to a normal range, the table formatting remains. So, as you can see, this can be used as a neat way to format a range of cells with a table format that you like. On the other hand, if you do not want to retain the formatting left behind by the table, you will need to remove it manually.

To convert all of your cells back to default formats, you can easily do this by selecting the entire table (CTRL+A) and then on the Home tab, click the Clear button in the Editing group and choose Clear Formats. However, this removes all formatting including number formats and cell alignment.

To keep the existing number formatting and alignment options, first select the entire table (CTRL+A) and then remove the unwanted formats using the commands (e.g. Fill, Font, Borders, etc…) on the Home tab in the Font group or on the Mini toolbar when you right-click a cell in the table.

If you want to experiment with some of the table formats, immediately after you create the table, you can click Undo on the Quick Access Toolbar (or press CTRL+Z) to convert the table back to a range and the table formatting will be removed.

Find more time-saving tips for Microsoft Excel 2007, 2003, 2002, 2000 at