Multiplying an entire column by a single cell

Jason167 · #1 11-04-2015, 05:08 AM

Hi All

Firstly I'm sorry if this question is a little basic but I'm new to Excel and am struggling to with this problem.

I'm using excel 2007 and trying to multiply an entire column by the value of a single cell to produce another column of answers

Therefore

If cell A1 has a value of 10

And column D has 50 cells each with different values

I want to multiply each value in column D by the value in Cell A1 and produce 50 answers in column E

macropod · #2 11-04-2015, 05:25 AM

In E1, insert:
=D1*A$1
Then copy down as far as needed

Jason167 · #3 11-04-2015, 05:56 AM

Thanks Paul,

I didn't know about the $

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Create formula for entire column	tdodson	Excel	2	10-27-2015 09:38 PM
documents saved with double column revert to single column when re-opened	danw	Word	6	04-08-2015 06:24 AM
How can I temporarily break a 3 column format in order to type a single column paragraph	William P	Word	1	01-04-2015 06:40 PM
How to add a fixed value to an entire column?	mikehende	Excel	11	12-12-2012 02:47 PM
NETWORKDAYS calculation for entire column	Salient	Excel	0	07-11-2011 03:58 PM