LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.newusers
 
Posts: n/a
Default Multiply two colums; BASIC help needed


And just to illustrate that there are always multilple ways to achieve
a result using Excel:

Click cell C1 and, without letting go of the mouse button, drag down to
C5 so that they are all selected (cell C1 is unshaded - it's the
"active" cell)

Input =A1*B1

Press and hold Ctrl, press Enter - Excel will fill the selected cells
with the formula, adusted for the respective cells

Regards

Steve



 
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Very Basic Excel Tutorial DanielleF Excel Discussion (Misc queries) 0 June 12th 06 11:34 PM
How do I multiply numbers? reckyroo Excel Discussion (Misc queries) 5 May 9th 06 09:03 AM
"If this, multiply by this" type of equation carsch Excel Worksheet Functions 3 April 28th 06 09:29 AM
Multiply two columns in Excel or one column by one number Axia's Mom New Users to Excel 1 January 12th 06 03:22 AM
Linking to Visual Basic for Applications Help Files Glynn Excel Discussion (Misc queries) 0 October 8th 05 01:29 AM


All times are GMT +1. The time now is 04:43 PM.

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

About Us

"It's about Microsoft Excel"