Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CAPITALISE GLOBALLY | Excel Discussion (Misc queries) | |||
Globally replacing * | Excel Discussion (Misc queries) | |||
how to globally replace two values at the same time in Excel | Excel Discussion (Misc queries) | |||
Globally change print settings for several worksheets at the same | Excel Discussion (Misc queries) | |||
change values globally | Excel Worksheet Functions |