Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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? |
#2
![]() |
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sheet Column Headings and Row Labels | Excel Worksheet Functions | |||
IF, Match, Index ? which One do I use | Excel Worksheet Functions | |||
Help with macro looping and color query function | Excel Discussion (Misc queries) | |||
column headings | Excel Worksheet Functions | |||
Can I invert a table so row headings are now column headings etc | Excel Worksheet Functions |