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?
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" <Momof3boys@discussions.microsoft.com> wrote in message
news:2F804725-84BA-41C7-B55E-60CB556ED68C@microsoft.com...
> 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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks