Updating whole worksheet

[WCDoan]

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

[Trevor Shuttleworth]

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" <WCDoan@discussions.microsoft.com> wrote in message
news:214A1CD7-CE16-4672-A1B6-658AFBBF1AB9@microsoft.com...
>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

[WCDoan]

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" <WCDoan@discussions.microsoft.com> wrote in message
> news:214A1CD7-CE16-4672-A1B6-658AFBBF1AB9@microsoft.com...
> >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
>
>
>

[Trevor Shuttleworth]

Thanks for the feedback. Forgot to say - then you can delete the 1.03 as
you don't need it any more.

Regards

Trevor


"WCDoan" <WCDoan@discussions.microsoft.com> wrote in message
news:46FDD53B-EDE1-4915-A057-E21B0E54ED9F@microsoft.com...
> 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" <WCDoan@discussions.microsoft.com> wrote in message
>> news:214A1CD7-CE16-4672-A1B6-658AFBBF1AB9@microsoft.com...
>> >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
>>
>>
>>

[Alan]

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" <WCDoan@discussions.microsoft.com> wrote in message
news:214A1CD7-CE16-4672-A1B6-658AFBBF1AB9@microsoft.com...
>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