Keeping Row 1 at the top during a Data Sort...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I keep row 1 at the top (header row) during a data sort using the
Icon buttons "A-Z SORT (Ascending)" or "A-Z SORT (Decending)" ??

When I use the menu... "data" "sort" "with header row" it all works right...
but when I click either "A-Z SORT" icon it takes in the header row instead of
leaving it at the top as row 1. Even when I have row 1 "frozen".

Appreciate any help here...
bro. Billy
<+><
 
Hi bro.Billy,

Format the headers in some way so that Excel can guess that they are headers
and should not be included in the sort. Setting the header font as bold or
underline worked for me as should applying a color fill or font color.
 

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 day names chronologically 5
Automatic Sorting? 6
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
Data Sort header row 1
sorting problem 3
Sort on 3 columns when number of rows vary daily 1
sorting half of data 1
Sorting Issue - Any help? 1

Back
Top