How do I constantly display worksheet headers in normal view?

[srsmith41]

In Excel (MS Office 2003 for Small Business), is there a way to keep the view
the headers present while editing a worksheet? I often have several files
open at a time or move between worksheets within a file and would like to see
the headers at a glance, perhaps just above the columns.

Is there already a way to see this without always clicking <View> <Headers>
etc.?

Thanks!

 

[JLatham]

Assuming you have column headers in row 1 on a worksheet, have you tried
clicking in cell A2 and then using Window | Freeze? That will keep row 1 in
view as you scroll down that sheet.

 

[srsmith41]

Thank you for your response. I'm not asking about viewing column headers,
I'm concerned about viewing the worksheet headers -- the title of the
worksheet that appears on the printed page above the columns. Any additional
thoughts?

I appreciate your help!

 

[David Biddulph]

Do you mean headers (which are a printing feature), or do you mean "freeze
panes"?

 

[srsmith41]

Headers. But I don't see why this should be restricted to Print Preview.
There's plenty of information available on the editing page. Why not the
name (not just the filename or the columns/rows names) of the worksheet?

I hope this clarifies my question.

 

[David Biddulph]

The name of the worksheet appears on a tab at the foot of the worksheet.

If you can't see it, try Tools/ Options/ View/ Window Options/ Sheet tabs.

 

[Gord Dibben]

You cannot see headers or footers except in Print Preview mode.

Unless you add the header or footer values to cells in top row then use a
macro to slap those values into a header or footer when printing.


Gord Dibben MS Excel MVP