multiplying a whole row

  • Thread starter Thread starter sik
  • Start date Start date
S

sik

How do i multiply by a factor a whole column of numbers without having to
create a new column and creating a formula to do this
 
Copy the value you wish to multiply to the clipboard.Select the range of
cells you wish to multiply.ClickEdit> PasteSpecial>under Operation check
multiply and then OK.
 
1. Enter your factor into an empty cell and copy.
2. select your column of numbers.
3. Edit/Paste Special/ select Values and Multiply .... OK.

Regards
BrianB
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Column multiplied by a matrix 2
row multiplier? 2
Is it possible to split 1 cell into 3 cells w/o affecting other ce 1
constant multiplier 4
How to multiply column and rows 13
Conditional SUBTOTAL in XL210 Table 7
Formula For Multiple Rows 2
Paste Special Formula Multiply feature doesn't work anymore 2

Back
Top