Title line

[darkhelmet]

I am trying to figure out how to have a title line that is not affected when I alphabetize the rest of the document. Any ideas?
This message was edited by darkhelmet on 2002-10-09 23:02

 

[Yogi Anand]

On 2002-10-09 23:01, darkhelmet wrote:
I am trying to figure out how to have a title line that is not affected when I alphabetize the rest of the document. Any ideas?
This message was edited by darkhelmet on 2002-10-09 23:02

Hi darkhelmet:

Welcome to the Board!

If I have understood you right, you can do this by not including the TITLE LINE in the sort range.

Does it help? If not please explain a little further and let us take it from there.

Regards!

Yogi

Edit: added Welcome!
This message was edited by Yogi Anand on 2002-10-09 23:07

 

[darkhelmet]

Is there a way to lock the row so that I can't accidentally sort it?

 

[Yogi Anand]

On 2002-10-09 23:07, darkhelmet wrote:
Is there a way to lock the row so that I can't accidentally sort it?

Hi darkhelmet:

When you are working with the Sort feature, Excel will have a dialog box popup and it has an option to Select 'My List Has a Header Row'

If you select that option, then the Header Row (Your Title LIne) will not be included in the sort operation.

Regards!

Yogi

 

[darkhelmet]

That works well. Thanks for your help.
Jason