+ Reply to Thread
Results 1 to 2 of 2

Unable to drag the formulae to subsequent cells in Excel 2007

  1. #1
    Registered User
    Join Date
    12-29-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    1

    Unable to drag the formulae to subsequent cells in Excel 2007

    Hello ExcelForum Members,

    My worksheet contains the following data.
    Cell A1 = 65
    Cell A2 = 85
    Cell A3 = 115
    Applied the formula for Cell C1 as =A1*2

    Q:
    After this, I would like to drag the formula to cells C2 and C3, referring to cells A2 and A3 respectively. But I couldn't see the '+' symbol at the right bottom part of the cell C1 after applying the formula.
    Do I need to change the settings anywhere to get this drag facility enabled ?

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,142

    Re: Unable to drag the formulae to subsequent cells in Excel 2007

    hi kktheblogger, welcome to the forum. go to the Windows icon -> Excel Options -> Advanced -> Enable fill handle and cell drag-and-drop. that might be the problem

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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