Copying same value to all sheets in a workbook

  • Thread starter Thread starter KWoodard
  • Start date Start date
K

KWoodard

I have a workbook with 35 worksheets in it. I want to
copy the same number value, "8" to the same cell in all
worksheets on a particular day of the month. It need not
be automatic. I'm just trying to do one global command to
execute the placement of the value without visiting each
individual worksheet. Used to know how to do it in Lotus,
can't seem to find the way in Excel. Thanks in advance.
 
Select all the sheets affected, ie either CTRL key and then select individually,
or click on first tab, hold down SHIFT and click on last tab, then type value in
cell. Make sure you ungroup tabs when finished.
 
With XL2002, you can select all the worksheets (click the
first tab, hold down the Shift key, and click the last
tab), then key in your value into the cell.

HTH
Jason
Atlanta, GA
 
The easiest way to do this manually is to select all
sheets and enter the value once, like this:

Select the first sheet.
Hold down the Shift key.
Select the last sheet.

Now whatever you add to one sheet (entering value 8 for
example) will be added to the same cell in the other
sheets. Then just right click one of the sheet tabs and
choose Ungroup Sheets.

tod
 
Back
Top