| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Sorting/Locking Header
I am trying to be able to sort and not have my header sort with it. I want
the header row to be locked. I've used the excel help where it says to click Data, Sort, then My Data has Header Row. I then click ok. But, then it defaults back to No Header Row. How do I make it stick? Or is there something I need to do in order to do so. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Sorting/Locking Header
Excel recognizes a header row if it has different formatting like Bold text.
Gord Dibben MS Excel MVP On Sat, 27 Oct 2007 20:30:00 -0700, Sapphire927 wrote: I am trying to be able to sort and not have my header sort with it. I want the header row to be locked. I've used the excel help where it says to click Data, Sort, then My Data has Header Row. I then click ok. But, then it defaults back to No Header Row. How do I make it stick? Or is there something I need to do in order to do so. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Sorting/Locking Header
It is in bold and still won't hold.
"Gord Dibben" wrote: Excel recognizes a header row if it has different formatting like Bold text. Gord Dibben MS Excel MVP On Sat, 27 Oct 2007 20:30:00 -0700, Sapphire927 wrote: I am trying to be able to sort and not have my header sort with it. I want the header row to be locked. I've used the excel help where it says to click Data, Sort, then My Data has Header Row. I then click ok. But, then it defaults back to No Header Row. How do I make it stick? Or is there something I need to do in order to do so. |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Sorting/Locking Header
Then try center and underline also.
Gord On Sun, 28 Oct 2007 11:33:01 -0700, Sapphire927 wrote: It is in bold and still won't hold. "Gord Dibben" wrote: Excel recognizes a header row if it has different formatting like Bold text. Gord Dibben MS Excel MVP On Sat, 27 Oct 2007 20:30:00 -0700, Sapphire927 wrote: I am trying to be able to sort and not have my header sort with it. I want the header row to be locked. I've used the excel help where it says to click Data, Sort, then My Data has Header Row. I then click ok. But, then it defaults back to No Header Row. How do I make it stick? Or is there something I need to do in order to do so. |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Sorting/Locking Header
I've done all that. I have everchanging data. When I select sort, the
header sorts with it. I don't want the header row to move. "Gord Dibben" wrote: Then try center and underline also. Gord On Sun, 28 Oct 2007 11:33:01 -0700, Sapphire927 wrote: It is in bold and still won't hold. "Gord Dibben" wrote: Excel recognizes a header row if it has different formatting like Bold text. Gord Dibben MS Excel MVP On Sat, 27 Oct 2007 20:30:00 -0700, Sapphire927 wrote: I am trying to be able to sort and not have my header sort with it. I want the header row to be locked. I've used the excel help where it says to click Data, Sort, then My Data has Header Row. I then click ok. But, then it defaults back to No Header Row. How do I make it stick? Or is there something I need to do in order to do so. |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Sorting/Locking Header
I have no more suggestions.
Sorry, Gord On Sun, 28 Oct 2007 12:41:00 -0700, Sapphire927 wrote: I've done all that. I have everchanging data. When I select sort, the header sorts with it. I don't want the header row to move. "Gord Dibben" wrote: Then try center and underline also. Gord On Sun, 28 Oct 2007 11:33:01 -0700, Sapphire927 wrote: It is in bold and still won't hold. "Gord Dibben" wrote: Excel recognizes a header row if it has different formatting like Bold text. Gord Dibben MS Excel MVP On Sat, 27 Oct 2007 20:30:00 -0700, Sapphire927 wrote: I am trying to be able to sort and not have my header sort with it. I want the header row to be locked. I've used the excel help where it says to click Data, Sort, then My Data has Header Row. I then click ok. But, then it defaults back to No Header Row. How do I make it stick? Or is there something I need to do in order to do so. |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Sorting/Locking Header
Are you *manually* selecting the *entire* datalist that you want to sort,
OR Are you just clicking a cell in the list and allowing XL to make the selection for you by clicking one of the "Sort" icons on the toolbar? I suggest that you *always* manually select your datalist prior to starting a sort. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Sapphire927" wrote in message ... I've done all that. I have everchanging data. When I select sort, the header sorts with it. I don't want the header row to move. "Gord Dibben" wrote: Then try center and underline also. Gord On Sun, 28 Oct 2007 11:33:01 -0700, Sapphire927 wrote: It is in bold and still won't hold. "Gord Dibben" wrote: Excel recognizes a header row if it has different formatting like Bold text. Gord Dibben MS Excel MVP On Sat, 27 Oct 2007 20:30:00 -0700, Sapphire927 wrote: I am trying to be able to sort and not have my header sort with it. I want the header row to be locked. I've used the excel help where it says to click Data, Sort, then My Data has Header Row. I then click ok. But, then it defaults back to No Header Row. How do I make it stick? Or is there something I need to do in order to do so. |
|
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Sorting/Locking Header
And *NEVER* use the sort icons on the toolbar!
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Ragdyer" wrote in message ... Are you *manually* selecting the *entire* datalist that you want to sort, OR Are you just clicking a cell in the list and allowing XL to make the selection for you by clicking one of the "Sort" icons on the toolbar? I suggest that you *always* manually select your datalist prior to starting a sort. -- Regards, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "Sapphire927" wrote in message ... I've done all that. I have everchanging data. When I select sort, the header sorts with it. I don't want the header row to move. "Gord Dibben" wrote: Then try center and underline also. Gord On Sun, 28 Oct 2007 11:33:01 -0700, Sapphire927 wrote: It is in bold and still won't hold. "Gord Dibben" wrote: Excel recognizes a header row if it has different formatting like Bold text. Gord Dibben MS Excel MVP On Sat, 27 Oct 2007 20:30:00 -0700, Sapphire927 wrote: I am trying to be able to sort and not have my header sort with it. I want the header row to be locked. I've used the excel help where it says to click Data, Sort, then My Data has Header Row. I then click ok. But, then it defaults back to No Header Row. How do I make it stick? Or is there something I need to do in order to do so. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Locking worksheet, preventing sorting | Excel Discussion (Misc queries) | |||
| Locking all cells accross when sorting columns | New Users to Excel | |||
| sorting - No header row | Excel Discussion (Misc queries) | |||
| Sorting with Header Row | Excel Discussion (Misc queries) | |||
| locking data/cells so re-sorting a column doesn't re-position my d | Excel Discussion (Misc queries) | |||
Linear Mode
