View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default Can I 'auto update' my spreadsheet ?

Try first with a copy of your data...........

In a helper cell put 1.1
Then right-click on it an do COPY
Then highlight all the numbers you wish to increase, then right-click
PasteSpecial Multiply...........

Vaya con Dios,
Chuck, CABGx3



"Rich" wrote:

Hello there

Basic user to excel here so apologies if this is a silly question....but, I
have built a very large spreadsheet with hundereds of individual costings for
my business. I now want to INCREASE each of the numbers by 10% and was
wondering if I can do this automatically or do I have to go through each
individual cell and update myself ??

Any help appreciated

Many thanks

Rich