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

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?

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.
--
Earl Kiosterud
www.smokeylake.com

"Momof3boys" wrote in message
...
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?