Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
When I freeze one or more rows, and then I click a single column header and
sort by that column, sometimes the frozen rows are included in the sort, and sometimes they are not. I don't ever want them to be included, so I'm trying to figure out what is causing this to happen and how to prevent it. For example, say I have a "Name" column containing three rows: Tom, Dick, and Harry. The top row (containing the header) is frozen. If I sort by that column, I'd expect "Name" to stay in the top row, and the other rows to be sorted Dick, Harry, and Tom. Sometimes this works exactly as I'd expect, but other times the column header is included in the sort, so I'll end up with rows sorted as Dick, Harry, Name, and Tom. This can really mess things up when I have, say, 6 rows containing a sheet title, user instructions, and header data frozen at the top and I don't want any of these rows to be included when sorting. Can anyone tell me how to control this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Print Frozen Panes? | Excel Discussion (Misc queries) | |||
frozen panes | Excel Discussion (Misc queries) | |||
frozen panes print top of each page | New Users to Excel | |||
How do I Hide frozen panes when printing? | Excel Worksheet Functions | |||
How do i use multiple splits or frozen panes? | Excel Discussion (Misc queries) |