Windows 10: MS EXCEL (Math: Product / Addition) Solved

Page 2 of 2 FirstFirst 12

  1. Posts : 13,553
    Windows 10 (Pro and Insider Pro)
       28 Sep 2017 #11

    Fafhrd said: View Post
    If you select cells E4 and F4, and then continue the selection down , for say 100 rows, with <Shift>+<down arrow> keys, then enter <Ctrl>+D to copy down, then the formulae in both E4 and F4 should be copied down in those 100 rows. You only seem to have copied down in the column E. You can check whether there are formulae in a cell by clicking it and checking what is in the cell edit box.
    Or just mark the last cell with good formula click and hold on cross mark (lower right corner of cell) and drag down... Formula will be copied in all cells

    Click image for larger version. 

Name:	image.png 
Views:	11 
Size:	7.3 KB 
ID:	155418

    result:

    Click image for larger version. 

Name:	image.png 
Views:	11 
Size:	6.7 KB 
ID:	155419

    Edit: and you don't need to have zero (0) in that empty row. There is the same formula in F column... (empty cell is zero)
    Last edited by AndreTen; 30 Sep 2017 at 04:59.
      My ComputerSystem Spec


  2. Posts : 24
    Microsoft Windows 10 Pro 64-bit 15063
    Thread Starter
       30 Sep 2017 #12

    Thank you all!
      My ComputerSystem Spec


 
Page 2 of 2 FirstFirst 12

Related Threads
Solved Excel ? in Microsoft Office and 365
I'm trying to learn how to setup a spreadsheet in Excel and need a little help. This is my first attempt at making a spreadsheet. In this example how do I setup this spreadsheet so that I can keep a running total of columns C,D and E in column F if...
Hello, New desktop pc that came with 1 TB HD. Debating installing another internal 1 TB HD vs just using an external one. Lots of Photos, and another user with lots of video, etc. The only advantage that I can see for another internal one...
Conexant Audio devices have been troublesome for Windows 10 since the earliest previews, and still are. on 2 YOga 2's I config'd, on one HP AMD-based G4, on one Thinkpad I've worked with - all Conexant drivers intalled would fail sooner or later ...
For keyboard nerds like me http://www.bleepingcomputer.com/forums/public/style_emoticons/default/laugh.png, this is one that I use many times daily. When I installed Win 7 back in 2010, I added this dword to revert the alt-tab order to the way it...
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd
All times are GMT -5. The time now is 20:12.
Find Us