Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Want to change current prices in a column by a percentage
Hi
I currently have a spreadsheet that contains cost prices in columns. I want to increase these prices by say 35% but don't want to have to insert columns and formulae to recalcuate each column. I know that there is a quick way of doinf this by highlighting the column but can't remember how. Thanks Sharon |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Want to change current prices in a column by a percentage
Enter 1.35 in a blank cell and COPY. Highlight columns to be updated,
Edit==paste special==Operation==Multiply. Delete "helper" cell. Test before committing! "Sharon43" wrote: Hi I currently have a spreadsheet that contains cost prices in columns. I want to increase these prices by say 35% but don't want to have to insert columns and formulae to recalcuate each column. I know that there is a quick way of doinf this by highlighting the column but can't remember how. Thanks Sharon |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Want to change current prices in a column by a percentage
Thanks for the advices - excellent worked first time.
"Sharon43" wrote: Hi I currently have a spreadsheet that contains cost prices in columns. I want to increase these prices by say 35% but don't want to have to insert columns and formulae to recalcuate each column. I know that there is a quick way of doinf this by highlighting the column but can't remember how. Thanks Sharon |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
How to change column letters to correct ones in many formulas automatically? | Links and Linking in Excel | |||
How to change column letters to correct ones in many formulas automatically? | Excel Worksheet Functions | |||
Macro to change Chart Range when inserting a column | Charts and Charting in Excel | |||
Change the width of a single column in a column chart | Charts and Charting in Excel |