Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default how do i set the default sort option to recognize a header

In Excel 2002 you could press the sort button and the data would be sorted
and the header would be excluded. Now using excel2003 I can't do it this way
because excel is not recognizing the header, Is this a setting I can change,
if so, how can I change this.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default how do i set the default sort option to recognize a header

Sometimes if you format the header row differently (bold/larger font), then
excel will be able to guess if you have headers.

Personally, I think it's a bad idea to let excel guess at the headers or the
range to be sorted--I don't trust it!

marquize wrote:

In Excel 2002 you could press the sort button and the data would be sorted
and the header would be excluded. Now using excel2003 I can't do it this way
because excel is not recognizing the header, Is this a setting I can change,
if so, how can I change this.


--

Dave Peterson
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
Header Rows and Sort Issue MikeL. Excel Discussion (Misc queries) 1 March 28th 06 12:23 AM
How can I sort multiple times Sorting data Excel Worksheet Functions 2 February 9th 06 05:22 PM
HELP! How do you--> Lock a set of rows but also link worksheets to FRUSTRATED Excel Discussion (Misc queries) 6 December 29th 04 10:05 PM
ALLOW ROW 1 AS HEADER ROW... NOT PART OF DATA SORT OF ANY COLUMNS. bro. Billy New Users to Excel 4 December 11th 04 12:01 AM
sort option is greyed out in excel mom Excel Worksheet Functions 1 November 3rd 04 03:22 PM


All times are GMT +1. The time now is 03:15 PM.

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

About Us

"It's about Microsoft Excel"