Home |
Search |
Today's Posts |
#1
|
|||
|
|||
multiplying an enitre column.
In excel I have four columns all containing 500 cells. These cells represent
wholsale pricing. I want to muliply each column by 2 so they represent retail pricing. Robert |
#2
|
|||
|
|||
Back u or save your data FIRST!
then in an empty cell outside your 4X500 matrix enter the number 2. Copy this same cell (containging the Value 2). Highlight the full range A1:D500, then click on the Menu - Edit, Paste-Special, Click the Multiply button, then OK erase the cell containing the 2. HTH "Robert" wrote: In excel I have four columns all containing 500 cells. These cells represent wholsale pricing. I want to muliply each column by 2 so they represent retail pricing. Robert |
#3
|
|||
|
|||
Put 2 in an empty cell
copy that cell select your range edit|paste special|multiply clean up that 2 in that cell. Robert wrote: In excel I have four columns all containing 500 cells. These cells represent wholsale pricing. I want to muliply each column by 2 so they represent retail pricing. Robert -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with macro looping and color query function | Excel Discussion (Misc queries) | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
How to group similar column titles together???? | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Auto Skipping and protected cells | Excel Discussion (Misc queries) |