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
|