In Excel I have two header rows. I have done a freeze for both. If I click in the
little square to the left of column A and then do a sort and select Header row the second header row want to move. How can I keep as many header rows as
I need?
Max
In Excel I have two header rows. I have done a freeze for both. If I click in the
little square to the left of column A and then do a sort and select Header row the second header row want to move. How can I keep as many header rows as
I need?
Max
Don't select all cells. Instead, select from row 2 and below. You can do this.
Select A2.
Press and hold the Control and Shift keys
Press the right arrow
Press the down arrow
Now do your sort.
Regards,
Juan Pablo Gonz?lez
Thanks that work just fine
Max