Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I need to be able to repeat a column of names from the first column in a
worksheet in all subsequent worksheets. I want to set it up so that if I add a name to the first worksheet, it will automatically be repeated in the following sheets. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Click on the first worksheet and then click on the last worksheet while
holding down a shift key. This selects all the sheets in the workbook. Start entering your headings and whatever else is constant across all sheets, functions formatting, etc... When done, right click on any selected worksheet tab and select Ungroup Sheets -- Kevin Backmann "Scott" wrote: I need to be able to repeat a column of names from the first column in a worksheet in all subsequent worksheets. I want to set it up so that if I add a name to the first worksheet, it will automatically be repeated in the following sheets. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to repeat text on sheets in excel | Excel Worksheet Functions | |||
How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook? | Excel Worksheet Functions | |||
Repeat tasks automatically to others sheets | Excel Discussion (Misc queries) | |||
Header repeat across Sheets? | Excel Discussion (Misc queries) | |||
How do I repeat column headings on all of my sheets w/o cut/paste | Excel Discussion (Misc queries) |