| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to exclude header row from sort button sorts?
I have a large spread sheet that I like to sort alot of different ways using
the sort buttons on the tool bar. I know how to use the Data - Sort function and selecting header row or not. I want Excel to remember I have a Header Row when I use the toolbar buttons. It used to remember, but somehow it doesn't anymore? How can I make this always work? |
|
#2
|
|||
|
|||
|
I find Excel will rcognize a header row if the cells in that row are formatted
to Bold or Underline or some other format that will distinguish it from the cells below. Gord Dibben Excel MVP On Fri, 25 Mar 2005 05:15:03 -0800, "JCabo" wrote: I have a large spread sheet that I like to sort alot of different ways using the sort buttons on the tool bar. I know how to use the Data - Sort function and selecting header row or not. I want Excel to remember I have a Header Row when I use the toolbar buttons. It used to remember, but somehow it doesn't anymore? How can I make this always work? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to simply bring up the Find dialogue box?? | Excel Discussion (Misc queries) | |||
| HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
| Date Button in Header (Excel 2000) | Excel Discussion (Misc queries) | |||
| ALLOW ROW 1 AS HEADER ROW... NOT PART OF DATA SORT OF ANY COLUMNS. | New Users to Excel | |||
| Header included in sort | Excel Worksheet Functions | |||
Linear Mode
