add values across 26 worksheets globally
 

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!

add values across 26 worksheets globally
 

--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
---------------
Jacob Skaria


"Karina M ;)" wrote:

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!

add values across 26 worksheets globally
 

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.

--
Biff
Microsoft Excel MVP


"Karina M ;)" wrote in message
...
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!

add values across 26 worksheets globally
 

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



"Karina M ;)" wrote:

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!