| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| auto update of a chart | Excel Discussion (Misc queries) | |||
| How to auto update a cell with a current date | Excel Discussion (Misc queries) | |||
| Auto update of filters | Excel Discussion (Misc queries) | |||
| formuls results won't update automatically (auto is turned on) | Excel Worksheet Functions | |||
| How can I auto update a graph? | Charts and Charting in Excel | |||
Linear Mode
