ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Title row (https://www.excelbanter.com/excel-discussion-misc-queries/446161-title-row.html)

Estam

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

Spencer101

Quote:

Originally Posted by Estam (Post 1602095)
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! :)

Gord Dibben[_2_]

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


Estam

Thank you, perfect....


All times are GMT +1. The time now is 07:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com