How do I create column headings at top of every sheet?

[Don J]

I once knew how to generate column headings at the top of every deisplayed
sheet as I moved down through seccessive sheets of a worksheet. But am now
unable to find it again. Please help.

Don J

-------------------------------------------------------------------

 

[Guest]

Do you mean....

From the Excel main menu:
<window><freeze panes>

Does that help?
***********
Regards,
Ron

XL2002, WinXP

 

[Guest]

If you are trying to create multiple worksheets with the same headings, you
can do the following:

1) Select the first worksheet tab
2) Hold down shift and select the last worksheet tab (this selects all of
the worksheets)
3) Type the column headings, formulas, enter formatting, etc. in the first
tab.

End Result: Whatever you enter while you've got the worksheet tabs selected
will show up on all of the selected worksheets.