Preferences for sorting to always have header row

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

Guest

Can I change the default preferences in Excel to 'My Data has Header Row'? I
often use the icons for sort ascending in the toolbar and the data always
sorts the header row with it.
 
Format the header row as Bold

--
Kind regards,

Niek Otten

| Can I change the default preferences in Excel to 'My Data has Header Row'? I
| often use the icons for sort ascending in the toolbar and the data always
| sorts the header row with it.
 
Thanks, but I tried that and it doesn't work. Also tried freezing the row and
tried formatting the row to repeat on pages. Thanks anyway.
 
Please post your table (or the first 10 rows)

--
Kind regards,

Niek Otten

| Thanks, but I tried that and it doesn't work. Also tried freezing the row and
| tried formatting the row to repeat on pages. Thanks anyway.
|
| "Niek Otten" wrote:
|
| > Format the header row as Bold
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| >
| > | Can I change the default preferences in Excel to 'My Data has Header Row'? I
| > | often use the icons for sort ascending in the toolbar and the data always
| > | sorts the header row with it.
| >
| >
| >
 

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

writing a sort macro 2
Excel "remembering" sort criteria 3
How do I make the sort default to 'No header rows' 1
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
sorting columns sorts header values too 6
Sort confusion 2
stop sorting titles please 3

Back
Top