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

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Free Excel Templates If you want ready made custom Excel templates then you do not have to pay for them as they are FREE inside your Excel workbook! To activate this you need to go to File > New and choose from a variety of categories, such as: Budgets, Planners, Lists, Invoices, Calendars, ...
Show Averages With an Excel Pivot Table A Pivot Table is the most powerful feature within Excel as it allows you to analyze your data in many different ways, all with a press of a button. The Summarize Values By option allows you to choose a type of calculation (Sum, Count, Average, Max, Min, Count Numbers Produ...
Find Errors with Go to Special Constants Say you have a data set and want to make sure that each column contains what it is supposed to. For example, say you have a column which contains Dates and you want to check that there are no cells which contain Text. You can easily check this by highlighting that column an...
Rank Largest to Smallest With Excel Pivot Tables Excel Pivot Tables have a lot of useful calculations under the SHOW VALUES AS option and one that can help you a lot is the RANK LARGEST TO SMALLEST calculation. This option will immediately calculate the rankings (1 being the LARGEST value) for your values, allowing you to pi...