Page 2 of 2 FirstFirst 12
  1.    28 Sep 2017 #11
    Join Date : Feb 2016
    Maribor, Slovenia
    Posts : 8,971
    Windows 10 (Pro and Insider Pro)

    Quote Originally Posted by Fafhrd 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.    30 Sep 2017 #12
    Join Date : May 2016
    Cebu City
    Posts : 22
    Microsoft Windows 10 Pro 64-bit 14393.693
    Thread Starter

    Thank you all!
      My ComputerSystem Spec

 
Page 2 of 2 FirstFirst 12


Similar Threads
Thread Forum
Solved Excel ?
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...
Software and Apps
Internal Or External HD Addition ?
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...
General Support
Can we force-install a HID Audio device IN ADDITION to OEM?
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 ...
Drivers and Hardware
Solved Win 10 Alt-Tab Order - Dword Addition - Will it work?
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...
General Support
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 21:05.
Find Us
Twitter Facebook Google+ Ten Forums iOS App Ten Forums Android App



Windows 10 Forums