How to sort without including column headings in sort

O

OPDvolunteer

I can't find the answer either online or in Excel help probably because I'm
not using correct terms. The first row contains column titles, and when I
sort the columns these titles get sorted to. Can I somehow anchor or
designate the text in these cells to remain fixed?
 
R

RonaldoOneNil

Don't know what version of Excel you are using but in Excel 2000 when you
select your columns and then click Data - Sort, the Sort dialog box has a
radio button at the bottom to say whether your columns have a header row or
not.
 
N

Niek Otten

Try formatting the headers differently, like Bold. Excel will probably
recognize them then as headers
 

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

Cannot sort a table containing text 5
List all tables, including document structure 0
How to sort entire spreadsheet by one column sort 5
sort a table without including titles which r on each page 3
COLUMN HEADINGS WON'T KEEP SAME HEADING NAME 0
How do I sort a database without also sorting the column heading? 1
Lookup all occurences and return their column headings 5
Format column widths from one table to a separate table on same page 1

Top