Repeat column in all sheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Last text entry in a column 4
hide, unhide column or row after protect worksheet 4
hyperlink 6
highlight all repeat datas in a worksheet 4
Comparing common values in either different worksheets or columns 1
repeat a formula same column same number of rows apart 2

Back
Top