Thanks so much. Worked like a charm.
Randy

"Trevor Shuttleworth" wrote:

Randy

put 1.03 in a "spare" cell somewhere on the sheet. Copy that cell.

Now select all the cells you want to update.

Select Edit | Paste Special... | Operation = Multiply

Regards

Trevor


"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