Exclude more than one row from data->Sort

E

eZee

Hi all!

Is there a way to exclude more than one column header row from the
Data->Sort function?

I have a sheet which uses the first three rows for header information,
but Data->Sort only allows me to exclude the first one.

Your help would be much appreciated

eZee
 
M

mphell0

You can either

1) Only select the bottom most header row when selecting you range for
sorting

2) Merge the three header cells into one cell and use the merged cell
as your
header row
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top