A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Title row



 
 
Thread Tools Display Modes
  #1  
Old May 24th 12, 05:46 PM
Estam Estam is offline
Junior Member
 
First recorded activity by ExcelBanter: Apr 2012
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
Ads
  #2  
Old May 24th 12, 07:10 PM
Spencer101 Spencer101 is offline
Senior Member
 
First recorded activity by ExcelBanter: Mar 2012
Posts: 653
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  
Old May 24th 12, 09:19 PM posted to microsoft.public.excel.misc
Gord Dibben[_2_]
external usenet poster
 
Posts: 570
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  
Old May 25th 12, 03:07 PM
Estam Estam is offline
Junior Member
 
First recorded activity by ExcelBanter: Apr 2012
Location: Detroit, MI
Posts: 8
Default

Thank you, perfect....
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

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 07:27 AM.


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