A
al_rwli
Once you've created your "standard" colum headings, how do you repeat
them on every page
them on every page
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Paul
al_rwli > said:Once you've created your "standard" colum headings, how do you repeat
them on every page
File > Page Setup > Sheet tab
Print titles: Rows to repeat at top
P
Peo Sjoblom
File>page setup>sheet and put the reference in rows to repeat at top
G
Gord Dibben
Paul and Peo have taken care of rows to repeat at top when printing.
If by "page" you mean "worksheet" you can "group" all sheets by right-clicking
on the first sheet tab and "select all sheets".
Type in your column headings(titles) in the active sheet. All grouped sheets
will get the same headings.
DO NOT FORGET to "ungroup" the sheets when done.
If you want to add sheets via the Insert>Worksheet route you could make a
template.
Set up a new workbook with one sheet formatted the way you want then File>Save
As>File Type>Template(*.xlt).
Name it SHEET(Excel will add the .XLT.
Save it to your Office\XLSTART folder.
Any new inserted worksheet will be based on this template.
Gord Dibben Excel MVP
If by "page" you mean "worksheet" you can "group" all sheets by right-clicking
on the first sheet tab and "select all sheets".
Type in your column headings(titles) in the active sheet. All grouped sheets
will get the same headings.
DO NOT FORGET to "ungroup" the sheets when done.
If you want to add sheets via the Insert>Worksheet route you could make a
template.
Set up a new workbook with one sheet formatted the way you want then File>Save
As>File Type>Template(*.xlt).
Name it SHEET(Excel will add the .XLT.
Save it to your Office\XLSTART folder.
Any new inserted worksheet will be based on this template.
Gord Dibben Excel MVP