A al_rwli Jan 9, 2004 #1 Once you've created your "standard" colum headings, how do you repeat them on every page
P Paul Jan 9, 2004 #2 al_rwli > said: Once you've created your "standard" colum headings, how do you repeat them on every page Click to expand... File > Page Setup > Sheet tab Print titles: Rows to repeat at top
al_rwli > said: Once you've created your "standard" colum headings, how do you repeat them on every page Click to expand... File > Page Setup > Sheet tab Print titles: Rows to repeat at top
G Gord Dibben Jan 9, 2004 #4 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
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
