add values across 26 worksheets globally

  • Thread starter Thread starter Karina M ;)
  • Start date Start date
K

Karina M ;)

Hi:
I have 26 worksheets and need to populate a blank field with the same value
across all sheets in cell C5. Find and replace doesn't seem to work for cell
references. Any other easy way to do it? I don't do programming or macros...
Thanks!
 
--Right click the sheet tab.Select all Sheets..
--Enter value in C5
--Right click the sheet tab and ungroup sheets


If this post helps click Yes
 
Group the sheets of interest then enter what you want in cell C5 and it will
be entered on all the grouped sheets.

Just make sure you ungroup the sheets when you're done.
 
Hi Karina,

Try the following:

1. Select all of the worksheets
Right click on a sheet tab
From the pull down menu Select "Select All Sheets"
2. On the sheet that is visible select c5 and enter your data. This should
populate cell C5 in all of the worksheets.

If this helps, please press YES

Regrads John
 
Back
Top