Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort confusion
Dear Experts,
I've looked through almost all the posts and could not find an answer to this. I have a spreadsheet (Excel 2003) with 10 columns that have been sorted everyday for the last few months. The users delete info from a particular row between 5 & 21 (information only, NOT the row), then highlight rows 5-21, click DataSort, have been choosing the header column name from the first 'Sort by' option (header is in row 4), click OK and it sorts without having to click any other buttons. Today, the 'Sort by' options in the drop down list are showing the info in row 5 not the header names. Can anyone tell me what's happened? Why would they now, after all this time, have to choose the 'No header row' button? I'm just a little stumped. What am I missing and is there a way to default the 'No header row' button? Thanks for any and all your assistance!!! ramona |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MDI Confusion | Excel Discussion (Misc queries) | |||
COUNTA Confusion.... | Excel Discussion (Misc queries) | |||
Formula confusion | Excel Worksheet Functions | |||
Confusion..... | Excel Discussion (Misc queries) | |||
still have drop-down confusion | Excel Discussion (Misc queries) |