View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default 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!