#1   Report Post  
Junior Member
 
Location: Detroit, MI
Posts: 8
Default Title row

I seemed to have touched something here. My first row lists my descriptions and now when I sort, it also sorts. Can anyone please tell me what the key is to keep this row on top. Many thanks ......Dave
  #2   Report Post  
Senior Member
 
Posts: 663
Default

Quote:
Originally Posted by Estam View Post
I seemed to have touched something here. My first row lists my descriptions and now when I sort, it also sorts. Can anyone please tell me what the key is to keep this row on top. Many thanks ......Dave
Ensure you have headers in all used columns in row 1 and make them bold. Works for me! :)
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 621
Default Title row

In the Sort Options place a checkmark in "my data range has" header
row.

If you make the text in the Title row bold or different font than the
others, Excel will most times see that as a header row automatically.


Gord

On Thu, 24 May 2012 16:46:26 +0000, Estam
wrote:


I seemed to have touched something here. My first row lists my
descriptions and now when I sort, it also sorts. Can anyone please tell
me what the key is to keep this row on top. Many thanks ......Dave

  #4   Report Post  
Junior Member
 
Location: Detroit, MI
Posts: 8
Default

Thank you, perfect....
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
How to hide a chart title, but keep the title in the chart KBratt Charts and Charting in Excel 1 July 16th 09 12:13 AM
Named range=Column title,comumn title in cellB6 use B6in equation Graham Excel Discussion (Misc queries) 2 July 21st 06 10:03 AM
Title in row 1 QuestionMan Excel Discussion (Misc queries) 1 January 26th 06 03:07 AM
Show full path title in title bar? Nor New Users to Excel 4 November 4th 05 06:00 PM
Pasting Objects into Chart title and Axis title Sam Charts and Charting in Excel 1 June 6th 05 08:50 PM


All times are GMT +1. The time now is 11:52 AM.

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"