Multiplying...

  • Thread starter Thread starter BScott1238
  • Start date Start date
B

BScott1238

Help! I have some data that I am importing into Excel. I have a range
of cells that is 11 rows x 2 columns. What I need to do is simple. I
need to multiply each cell in this range by 60 without going in to each
one and typing =PRODUCT(60*........). Anybody got any suggestions?
 
Put 60 in an empty cell, copy it, select the 11 x 2 range and
do edit>paste special and select multiply
 
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

Mutiply in a range of cells ? 1
Excel Need Countifs Formula Help 0
Need a formula to act as a value 1
Restoring columns 2
Moving a bunch of data 1
Need Adaptable Macro 9
Show Hrs:Min 5
Excel VBA 1

Back
Top