Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Ann Scharpf
 
Posts: n/a
Default Sort Ascending button - Excel 2003

My office has just deployed Office 2003 (migrated from 97) and I am still
getting used to some differences. The Sort Ascending button is behaving
differently and I'm not sure if there's a setting somewhere to govern this...

Used to be if you had a contiguous block of cells, you could click a SINGLE
cell in the column you wanted to sort on. The data in the whole (contiguous)
table would sort but the HEADER ROW would stay in place.

Now, when I click Sort Ascending, the sort is including the header row and
moving it out of row 1. Is there a way to control this? I've searched the
help, dialog boxes and the newsgroups but I'm not seeing anything so far.

I realize I can do CTRL-A, DATA SORT ... but that's a lot more keystroking
than just clicking the A-Z button!

Thanks for any help you can give me.

Ann Scharpf
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Offer a feature to disable the sort warning in Excel 2003 mzehr Excel Discussion (Misc queries) 5 May 25th 13 05:52 AM
sort column data with hidden columns - excel 2003 nanimadrina Excel Discussion (Misc queries) 2 April 26th 05 08:27 PM
EDIT FORMULA BAR in excel 2003? why not? where is it? alnav89 Excel Worksheet Functions 2 April 26th 05 07:02 PM
Automatic links in Excel 2003 Jim Bud Excel Discussion (Misc queries) 4 January 13th 05 03:57 PM
Saving a Excel 97 file into Excel 2003 file Wil Excel Discussion (Misc queries) 1 December 13th 04 11:51 PM


All times are GMT +1. The time now is 10:55 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"