Multiply columns

K

K Sonnier

I need to figure out how to make the whole column multiply by 1.6. Can anyone please help me? I have sent my price list to excel and Im trying to do a mark upof 1.6 and it is just not letting me format the whole column

K. Sonnier
 
F

Frank Kabel

Hi
try the following:
- enter 1.6 in an empty cell, select this cell and copy it (e.g. with
CTRL+C)
- now select your prices
- goto 'Edit - Paste Special' and choose the action 'Multiply'

Note: your original data is lost after this!

--
Regards
Frank Kabel
Frankfurt, Germany

K Sonnier said:
I need to figure out how to make the whole column multiply by 1.6.
Click to expand...
Can anyone please help me? I have sent my price list to excel and Im
trying to do a mark upof 1.6 and it is just not letting me format the
whole column.
 
N

Norman Harker

Hi K!

Put 1.6 in a cell
Select that cell
Copy
Select the column of data
Edit > Paste Special > Multiply > OK

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
K

K Sonnier

I have all my numbers in the cells in one column and i need excel to mark up all the prices that i have imputed already. Can i format the whole column all at once or do I have to do it line by line?
 
A

Andy B

Hi

The solutions given by Frank and Norman will work fine. Take a copy of the
sheet first if you are worried!!

Andy.

K Sonnier said:
I have all my numbers in the cells in one column and i need excel to mark
Click to expand...
up all the prices that i have imputed already. Can i format the whole column
all at once or do I have to do it line by line?
 
R

Rita Palazzi

Right-click on the COLUMN Letter, then follow their "Paste Special", "Multiply"
instructions to do the entire column at once.
Rita
 
Top