+ Reply to Thread
Results 1 to 3 of 3

Dragging the fill handle leaves cells blank

  1. #1
    Registered User
    Join Date
    12-21-2016
    Location
    Los Angeles, California
    MS-Off Ver
    15.29.1 (161215) for Mac
    Posts
    2

    Dragging the fill handle leaves cells blank

    I have a financial workbook I have been working with and I'm just starting to come across an issue where sometimes if I drag the fill handle to copy a basic SUM formula down a column it will instead erase the contents of the cell and leave it blank. Sometimes the cell will return 0, but not have the formula in the cell, just 0. This seems to happen in specific places of the workbook, but not all of it. Any idea what is causing this?

    I have tried pressing control and selecting copy cells when I drag the fill handle but it didn't change anything.

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    20,553

    Re: Dragging the fill handle leaves cells blank

    I have never seen this happen. Just to be clear, you are saying that an attempt to fill down your SUM formula causes the cell containing the SUM formula to be changed to a 0 value. Right? Does the zero get filled down when you do this?

    As a workaround, first select the area where you want to fill, with the SUM formula as the top cell, then press CTRL-d to fill down.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    12-21-2016
    Location
    Los Angeles, California
    MS-Off Ver
    15.29.1 (161215) for Mac
    Posts
    2

    Re: Dragging the fill handle leaves cells blank

    Sorry no, not the cell containing the SUM formula. The afflicted cells are those I am dragging down to. Some number appears (or doesn't) and there is no formula attached to it.

    When the cell returns a number with no formula it is not always 0. It returns various numbers in different parts of the workbook.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Excel Macro Step that Duplicates Dragging Fill Handle Down
    By Quinn.Farley in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-05-2015, 12:39 PM
  2. [SOLVED] Dragging the fill handle and keeping table headers locked
    By Butcher1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-04-2014, 10:44 PM
  3. Replies: 11
    Last Post: 09-15-2014, 02:36 AM
  4. [SOLVED] Formula to handle Blank Cells
    By coreytroy in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-10-2014, 08:08 PM
  5. formula for name order switch that leaves empty cells blank
    By redzan in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-17-2013, 07:01 PM
  6. Dragging form leaves trail
    By 1eyedjack in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-13-2012, 04:53 AM
  7. using the fill handle All the cells return the value of the first
    By Chris Simmons in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-12-2005, 12:30 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1