How can I keep more than one row from sorting

  • Thread starter Thread starter Ryle
  • Start date Start date
R

Ryle

I have two Header rows that I would like to avoid combinning and need to stay
frozen when I sort. As it is now both rows with stay on top as I scroll
through the document but when I sort the second one is sorted into the rest
of the document.
 
Select the range of cells you want to sort before you issue the sort
command. Don't let Excel guess which cells you want to include.
 
Thank you very much. That works for all the coloums except the first. Any
idea on how to make that one work. Also since this is a sheet to be used in
an office with others who have trouble remembering even the simple ways of
doing things with a computer is there any way to have a perminent setting?
 
With rows 1 and 2 formatted differently than rows below(bold font or similar)

Select A3 and Data>Sort

Make sure Excel has selected all the columns across.

My Data Range has "Header Row".

Sort by whichever column you wish.

Rows 1 and 2 should stay put.


Gord Dibben MS Excel MVP
 

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

Similar Threads

Sorting issue with frozen panes 11
writing a sort macro 2
Sorting in multiple worksheets 1
Header rows 2
Top row of excel stays even in sorting 1
How to sort when I have multiple header rows (not included in sor. 1
Freeze/split more than one row 2
Sort Not Including Top Row 2

Back
Top