Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Multiplying an entire column by a single cell
Register FAQ Mark Forums Read

Reply
 
Thread Tools Display Modes
  #1  
Old 11-04-2015, 05:25 AM
macropod's Avatar
macropod macropod is offline Multiplying an entire column by a single cell Windows 7 64bit Multiplying an entire column by a single cell Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
In E1, insert:
=D1*A$1


Then copy down as far as needed
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 11-04-2015, 05:56 AM
Jason167 Jason167 is offline Multiplying an entire column by a single cell Windows 10 Multiplying an entire column by a single cell Office 2007
Novice
Multiplying an entire column by a single cell 		 
Join Date: Nov 2015
Posts: 2
Jason167 is on a distinguished road
Default
Thanks Paul,

I didn't know about the $
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Hybrid Mode Hybrid Mode


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiplying an entire column by a single cell Create formula for entire column tdodson Excel 2 10-27-2015 09:38 PM
Multiplying an entire column by a single cell 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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:57 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft