Top row of excel stays even in sorting

W

willyd

I need a header in the top row of my excel worksheet so that even when I sort
the data the top row remains the same.
 
M

Ms-Exl-Learner

2003:-
Data>>Sort>>My Data Range As>> Check the “Header Row†Option Button.

2007:-
Press Alt+D+S the Sort Dialog Box will appear Press Alt+H which will select
the “My Data has headers†check box.
 

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

Showing Letters For Column Headers Rather Thann Numbers ? 1
Sorting issue with frozen panes 11
Sort Not Including Top Row 2
sorting grouped rows 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Is not sorting 4
Background stays when sorting 2
Sorting 1

Top