+ Reply to Thread
Results 1 to 2 of 2

Dragging formula no longer skips hidden cells

  1. #1
    Registered User
    Join Date
    04-08-2011
    Location
    Arkansas
    MS-Off Ver
    Excel 2007
    Posts
    5

    Dragging formula no longer skips hidden cells

    I know for a fact that as of one month ago my version of Excel (2016 MSO 32-bit) would skip hidden rows if I dragged down formatting or formulas. However, this morning I was working on a project and I dragged down a few formulas and the hidden rows were changed as well. Did Excel change something? Did I inadvertently change a setting? Thanks in advance for the help!

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,887

    Re: Dragging formula no longer skips hidden cells

    I'd guess, that when you previously performed drag down operation, you had Autofilter to filter out specific rows.

    When autofilter is used to filter out specific rows, those rows are ignored in drag down operation.
    However, if these rows are manually hidden, it will overwrite with dragged value/property, even when hidden.
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

+ 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] drag multiple functions, formula skips cells
    By larsweil in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 01-23-2017, 11:43 PM
  2. [SOLVED] Running total formula that skips blank cells
    By pittsburghr2 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-10-2015, 01:27 PM
  3. Replies: 4
    Last Post: 07-22-2014, 06:05 PM
  4. Formula that skips blank cells
    By chisox721 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-17-2013, 01:03 AM
  5. [SOLVED] Create a Formula That Skips Every n Cells
    By tj2434 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 11-20-2013, 05:30 PM
  6. [SOLVED] Need Formula that skips cells when using Autofill
    By Asaan in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-20-2012, 10:54 AM
  7. creating a formula that skips empty cells
    By turbo90talon in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 10-19-2007, 08:31 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