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

DOWNLOAD WORKBOOK

Table Headers Show in Columns

HELPFUL RESOURCE:

Excel Tables

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

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Filter Unique Records The Advanced Filter allows you to filter unique records and copy them to another location outside the data set.  This is useful when you want to use a filtered list for further analysis.This can also be achieved by using a Pivot Table.  Placing a Field in the Row Labels will ...
Excel Paste Special: A Values Multiplier Paste Special has a few different Paste features and operations that many users do not know about.One of them is the Paste Special > Values > Multiply combination.What that does is multiply a range of selected cells by a value, called the multiplier.  So if you want...
Conditionally Formatting A Drop Down List In a previous post I showed you how to Create a Drop Down List in a Table.    We are now going to take this concept one level further and apply some conditional formatting to the drop down data validation list.This is useful if you want to highlight when a job is completed, c...
Distinct or Unique Count with Excel Pivot Tables Excel 2013 added some new features to its arsenal and one that has been well overdue was the distinct or unique count.Previously when we created a Pivot Table and dropped a Customers field in the Row Labels and then again in the Values area we got the "total number of transac...