ExcelBanter - Updating whole worksheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Updating whole worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/74456-re-updating-whole-worksheet.html)

Alan

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

All times are GMT +1. The time now is 08:33 PM.