Multiplying...

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?
 
P

Peo Sjoblom

Put 60 in an empty cell, copy it, select the 11 x 2 range and
do edit>paste special and select multiply
 

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

Remove Identical words 0
Need Help with a VBA subroutine 0
Cell data entering slow! 0
Copy addition formula of non-consecutive horizontal cells 2
delete duplicates 0
Challenging Excel Problem 0
Merging from an Excel file with graphics 1
Restoring columns 2

Top