Can I 'auto update' my spreadsheet ?
 

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

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

Can I 'auto update' my spreadsheet ?
 

Hello CLR

Many thanks for the reply...but it doesnt seem to work - or more likely I am
doing something wrong..

My set-up is as follows :

Line 1 £10.00
Line 2 £20.00
Line 3 £30.00

It is line 3 that I want to uplift by 10% but struggling to do so..

Rich

"CLR" wrote:

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

Can I 'auto update' my spreadsheet ?
 

When highlighting the cells to increase, only do the 10 and 20 cells, not the
30 cell which is a sum of the above two..........the sum will take care of
itself

Vaya con Dios,
Chuck, CABGx3



"Rich" wrote:

Hello CLR

Many thanks for the reply...but it doesnt seem to work - or more likely I am
doing something wrong..

My set-up is as follows :

Line 1 £10.00
Line 2 £20.00
Line 3 £30.00

It is line 3 that I want to uplift by 10% but struggling to do so..

Rich

"CLR" wrote:

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

Can I 'auto update' my spreadsheet ?
 

Many Thanks

: )

"CLR" wrote:

When highlighting the cells to increase, only do the 10 and 20 cells, not the
30 cell which is a sum of the above two..........the sum will take care of
itself

Vaya con Dios,
Chuck, CABGx3



"Rich" wrote:

Hello CLR

Many thanks for the reply...but it doesnt seem to work - or more likely I am
doing something wrong..

My set-up is as follows :

Line 1 £10.00
Line 2 £20.00
Line 3 £30.00

It is line 3 that I want to uplift by 10% but struggling to do so..

Rich

"CLR" wrote:

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

Can I 'auto update' my spreadsheet ?
 

Happy to help...........thanks for the feedback.....

Vaya con Dios,
Chuck, CABGx3



"Rich" wrote:

Many Thanks

: )

"CLR" wrote:

When highlighting the cells to increase, only do the 10 and 20 cells, not the
30 cell which is a sum of the above two..........the sum will take care of
itself

Vaya con Dios,
Chuck, CABGx3



"Rich" wrote:

Hello CLR

Many thanks for the reply...but it doesnt seem to work - or more likely I am
doing something wrong..

My set-up is as follows :

Line 1 £10.00
Line 2 £20.00
Line 3 £30.00

It is line 3 that I want to uplift by 10% but struggling to do so..

Rich

"CLR" wrote:

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