Friday, September 26, 2008
walking down the bank route...
Wednesday, September 24, 2008
Dealing with AutoFilter
EXCEL TIPS: AutoFilter in a Messy Data Table
Work situation:
You have just exported a large amount of data into Excel or converted a .txt file into an .xls file. The data automatically sits in a table-like manner on your spreadsheet but it looks disorganised. You want to manipulate the data table using AutoFilter to speed up removing the blank rows that clutter around and through the entire range of the table.
Problem:
However, when you activate the AutoFilter & click the drop-down arrows of the column headings, they only display the basic criteria (Sort Ascending/Descending, All, Top 10, Custom) but where is the data? This is due to the blank rows between the headers and the first row of data.
Solution:
Turn off AutoFilter first. In order for Excel to treat your whole range of data as being one single table, highlight the entire table range. And turn the AutoFilter back on. Done! Now each column heading should show all the data underneath it. (EJ)