Wednesday, 17 October 2018

Microsoft Excel - Converting a Table to a Range



Converting a Table to a Range.

If you do not require your data in a Table format, it is possible to convert it back to a normal range.

1.  Click into a cell within the Table.

2.  Click the Design tab under Table Tools


3. Click the Convert to Range

4.  Click Yes to convert back to a normal range.

 




The data is now back in a Normal Range format, notice that the filter arrows have been removed from the column name headings.