Thread: New to formulas
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
gls858 gls858 is offline
external usenet poster
 
Posts: 209
Default 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