Paul,

The entire table to be filtered must be selected. Autofilter then uses the
first row of that selection as the headers. Since you have non-table stuff
in the first four rows, you can't select a single cell and let it expand the
selection, since the first four rows will get selected. You can if you have
an empty row after the first four (which can be hidden). Now you can select
a single cell in your table, and the selection will expand. Your data must
be contiguous, and have no non-table cells adjacent to it.

To use the sheet as is, you'll have to manually select your table. A quick
way is to select row 5 (all of it, or just the cells you're using in your
table in that row). For the latter, select A5, then Ctrl-Shift-Right . Now
Ctrl-Shift-Down, then Data - Filter - Autofilter
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Paul Moore" wrote in message
...
Hello Excel experts,

I've designed an Excel spreadsheet for work, which consists of summarising
figures for the 12 months of the year, with a separate worksheet for each
month.

On each monthly worksheet, I've used the first four lines to summarise the
data contained in the rest of the sheet. The fifth row is used to define
the colume data labels, and the actual data is contained in rows six
onwards.

Since the first row is not being used to define the column labels, it
seems I can't use Autofilter, which I've just discovered is perfect for
what I need to do: to hide some rows depending on whether a cell contains
data or not.

Is there a way to get Autofilter when the data doesn't start in the first
row?

Many thanks,
Paul

--
paul<dotmoore@pandora<dotbe
Adjust "dots" for real address