ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Repeat column in all sheets (https://www.excelbanter.com/excel-discussion-misc-queries/163542-repeat-column-all-sheets.html)

scott

Repeat column in all sheets
 
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.

Kevin B

Repeat column in all sheets
 
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.



All times are GMT +1. The time now is 09:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com