LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Every time I do a sort, I have to tell Excel that I have a hea

Thanks for the feedback.

Interesting resolution.


Gord

On Tue, 31 Oct 2006 10:39:01 -0800, Sally M
wrote:

Hi Gord,
Thanks for your willingness to help me once again (you helped me out a while
back, as well). Anyway, see my response to Dave O above to see what ended up
being the problem.
Sally

"Gord Dibben" wrote:

Sally

Excel will usually behave if the header is formatted differently than the rest.

Bold it or center it or underline or somesuch.


Gord Dibben MS Excel MVP

On Mon, 30 Oct 2006 13:21:02 -0800, Sally M
wrote:

I have a spreadsheet that I access daily. Every time I do a sort, I have to
go in and manually check off the "header" button so that it won't include the
header in the sort. Is there some way I can make it default to that; at
least in this particular document? Thanks for your help.




 
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
Excel file with hyperlinks takes a long time to open over the network Didier P Links and Linking in Excel 3 July 4th 06 04:39 PM
How does one sort a block of inter-related information in Excel? jets Excel Worksheet Functions 1 June 4th 06 05:17 AM
Sort order : Excel vs imported data John Excel Discussion (Misc queries) 0 December 9th 05 01:40 PM
How to Join/concatenate a date field with a time field in Excel? Alan Excel Discussion (Misc queries) 4 August 9th 05 10:07 PM
Imported Date & Time format with calcs. managed in excel from imrp Todd F. Excel Worksheet Functions 0 July 8th 05 09:03 PM


All times are GMT +1. The time now is 03:24 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"