View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Alan
 
Posts: n/a
Default Updating whole worksheet

oops, try 1.03
Sorry,
Alan.
"Alan" wrote in message news:...
In an empty cell enter 0.3, copy that, select the range you need to
uplift, right click the range, click 'Paste Special', check 'Multiply',
OK,
Regards,
Alan.
"WCDoan" wrote in message
...
I have a worksheet consisting of pay scales for a city. All rates are to
be
increased 3%. Is there a way to select all the cells and update each cell
by
3% all at once?

Thanks,
Randy