How do I repeat column headings on all of my sheets w/o cut/paste

M

Momof3boys

My husband is trying to create a workbook with multiple sheets, and he wants
the same column headings on each sheet. Can this be done without having to
cut and paste on each sheet?
 
E

Earl Kiosterud

Mom,

No. But he can work on the multiple sheets at once (insert rows, clear
cells, paste headings in , etc) by selecting multiple sheets. So he could
clear a row, paste in an existing set of headings all at once. Use the
Shift and/or the Ctrl key as you click the sheet tabs. Don't forget to
unselect them when done -- anything you do happens to all the sheets that
are selected.
 
Top