Excluding more than one top rows from filtering and sorting

  • Thread starter Thread starter and
  • Start date Start date
A

and

I have seen spreadsheets in which the topmost three, four or more cells
contain text or other constant data that are excluded from filtering and
sorting operations.

Also, the AutoFilters in these spreadsheets were located in the cell
right above the data, for instance A4, B4, etcetera, and not in the
first row. These cells, A4, B4 etc, were not sorted but behaved like
column headers. The data started in row 5.

So I'm looking for a way to achieve exactly this, but don't know what to
look for (which keywords in Excel Help, for instance, I should use) or
which web resources I could consult.

Any suggestions?
 
Hi

One way is to insert a blank row above row 4 (in your example). This will
detach the headings from the first three rows. You can hide this blank row,
if necessary, so that it looks like the top four rows are all together.
If you click a cell in your data and switch AutoFilter on, you should get
the result you're after.
 
Hi Andy,

That works beautifully!

Is there also a way to prevent the list buttons (arrows) from popping up
in the cells above row 4 (which in this case is the header)? I've set up
list based data validation (a named list) for the entire column, hence
the list buttons appear in all cells. I'd like to change this into data
validation for all cells below row# 4.

Andy (M.)


-------- Original Message --------
 
Hi

You could select the rows that you don't want the validation on and go to
Data Validation and hit the Clear All button.
 
Back
Top