#1   Report Post  
Old January 7th 10, 10:27 AM posted to microsoft.public.excel.newusers
A A is offline
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 37
Default excel

How multiply more cells in same time

  #2   Report Post  
Old January 7th 10, 10:38 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2009
Posts: 834
Default excel

Put the value to multiply by in a spare cell, and copy that cell.

Select the range to be multiplied.

Goto editPasteSPecial and select Multiply.

Exit and clear that first cell.

---
HTH

Bob Phillips

"a" wrote in message
...
How multiply more cells in same time



  #3   Report Post  
Old July 7th 21, 08:32 AM
Member
 
First recorded activity by ExcelBanter: Jun 2021
Posts: 47
Default Multiply many cells

Hello!

If you want to multiply a row or a column with the same number, you can:

1) put the number you want to multiply in a different row/column

2) select the row/column beside the original row/column you want to multiply

3) then Assuming the column A is the original row, you can put this formula:

=A1*$C$1

Where A1 is the cell on the original column, then C1 is the number you want to multiply it with. You use the dollar sign so that when you copy and paste, the reference cell will not change.

4) Just either copy paste the formula until the end of the column, or just click, hold, and drag the lower right side part of the cell (which is in a shape of a box)


For more tips on excel and financial models, you can check this out. Hope this helps!


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 02:40 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017