New to formulas
Peo Sjoblom wrote:
Copy the formula by grabbing the lower right corner of the cell and copy it
down
Peo answered first part on how. Here's how to do it across
multiple sheets:
To do it across multiple sheets group the sheets first then
when you make a change on one sheets it's made on the whole
group. Highlight a sheet tab then hold down the shift key
and select the last sheet all sheets in between will be
highlighted.
If you need to pick and chose sheets use the control key
instead of the shift key. Don't forget to ungroup the sheets
before you start entering values.
gls858
|