| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Preferences for sorting to always have header row
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Preferences for sorting to always have header row
Format the header row as Bold
-- Kind regards, Niek Otten "Helenka" wrote in message ... | 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Preferences for sorting to always have header row
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 "Helenka" wrote in message ... | 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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Preferences for sorting to always have header row
Please post your table (or the first 10 rows)
-- Kind regards, Niek Otten "Helenka" wrote in message ... | 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 | | "Helenka" wrote in message ... | | 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. | | | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Header Rows and Sort Issue | Excel Discussion (Misc queries) | |||
| Header & Footer Excel 2003 | Excel Discussion (Misc queries) | |||
| How do I setup a header in Excel that prints only on first page? | Excel Discussion (Misc queries) | |||
| how do I permanetly add custom header to excel header list? | Excel Discussion (Misc queries) | |||
| Default header in Excel under page set-up | Excel Discussion (Misc queries) | |||
Hybrid Mode
