P
Paul Moore
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
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