Hi guys, I'm working on a new order, and am doubling the quantities from a previous one. Does anyone know a way to select a range of cells and automatically double the number in each field? That would save me oodles of time.
OT- Excell help
- Thread starter leaford
- Start date
- th_trl_thread_readers 0
- Status
well I know a way but it isn't really what you want. It would be taking the cell next to it (or somewhere) and multiplying the orig x 2. Drag that down the range to get all the new values, then cut and paste special to paste just the values, not the formula
I hate Excel, but I think if you take the first number you need to double and in the formula bar put times 2, (say the number was 2, it would be 2*2) you could then drag the formula down the line. If that makes any sense?!?!
Lemme try that a little clearer...
Orig value is in cell A1. Go over to like K1. Enter =A1*2
Then drag that down the line, K1 thru K25 or whatever
now those are the new values
Select and copy
Go back to A1 and do Paste Special, and pick Values not Formulas
Will that work for you?
Dork ! 
It's Excel, not Excell.
- In an empty cell, enter the number that you want to multiply by.
- Select that cell, right click and Copy .
- Select the range of cells you want to multiply.
- Right-click them and select Paste Special.
- Click Multiply.
Congratulations.
It's Excel, not Excell.
- In an empty cell, enter the number that you want to multiply by.
- Select that cell, right click and Copy .
- Select the range of cells you want to multiply.
- Right-click them and select Paste Special.
- Click Multiply.
Congratulations.
Last edited:
Dork !
It's Excel, not Excell.
Exactly. Mycrosoft Excell. It came free with my copy of Wyndows XP.Not in china
Dork !
It's Excel, not Excell.
- In an empty cell, enter the number that you want to multiply by.
- Select that cell, right click and Copy .
- Select the range of cells you want to multiply.
- Right-click them and select Paste Special.
- Click Multiply.
Congratulations.
Seriously, thanks! That'll help save me a lot of time in the future. Y'know, cause you answered too late to help me NOW.
Dork !
It's Excel, not Excell.
- In an empty cell, enter the number that you want to multiply by.
- Select that cell, right click and Copy .
- Select the range of cells you want to multiply.
- Right-click them and select Paste Special.
- Click Multiply.
Congratulations.
You should have had him create a macro containing loops in VBA. That's how real men do it.
I worked with a guy who thought if it wasn't in a macro'd pivot table it wasn't right.
He was a German guy would sent me spreadsheets he worked on while so drunk he was
practically embalmed and drive me crazy trying to figure out why they broke when I updated them.
I do not miss him. : )
He was a German guy would sent me spreadsheets he worked on while so drunk he was
practically embalmed and drive me crazy trying to figure out why they broke when I updated them.
I do not miss him. : )
Nah. Could have sent him a python script that opened the excelL file and did all the multiplying from the command line.
Just didn't know if the excelL file had the same format as an excel file
- Status
Similar threads
