Before Excel Tables were introduced in Excel 2007, there were Excel Lists which had limited functionality.

For example, when you had a list of data with hundreds of rows and you had to scroll all the way down to the bottom of your list, the Headers row was not visible and you had to guess what some columns related to.

When you have your data in an Excel Table (Ctrl+T) and you have many rows of data and need to scroll down to the bottom of your Excel Table, the Header names stay visible in the Excel Columns.



Table Headers Show in Columns


Excel Tables

If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest


Share on Facebook


Tweet about this on Twitter


Share on LinkedIn


Share on Google+


Related Posts

Clear a #REF! Error in Excel When your Excel workbook has formulas that are linked to other workbooks/cells that have been deleted, you will get a #REF! error. This means that the formula refers to a cell that isn’t valid. To get rid of this error message we have to select the cell(s) with this error, ...
Excel Table Slicers Slicers were introduced with Pivot Tables in Excel 2010 and they allowed us to select items to filter with beautiful interactive buttons. You can see the power of Slicers and the different ways you can format them in these posts:
Text to Columns – Emails If you have a data set with text consisting of names and email addresses that are wrapped inside a parenthesis, like: John ([email protected])   ...then you can use the Text to Columns feature in Excel to take out the email addresses and put them in a separate ...
Excel Filter by Selection When you have an array of data in Excel you can quickly select an item and press the AutoFilter button which will filter that selection in your data. You can then go over to another column within your data and select another item, apply the same steps above and further filter ...