+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : How to do auto filling of cell from cell above if cell of the left is filled up?

  1. #1
    Forum Contributor
    Join Date
    07-29-2005
    Location
    Singapore
    MS-Off Ver
    2007
    Posts
    253

    Question How to do auto filling of cell from cell above if cell of the left is filled up?

    Hi,

    I noticed that sometimes when I filled in a cell, the respective cells on the right automatically grabs the formula from the cell above and fill in the data but sometimes I need to drag the cell manually down to fill up the data.

    Example.

    A1 = 1
    B1 = 2
    C1 = A1+B1

    A2 = 2
    B2 = 4
    C2 = A2+B2

    Sometimes after entering A2 and B2, C2 will automatically grabs C1 formula and fill in the answer. Sometimes I need to copy C1 and paste to C2 for my answer. Is there an option to do this "auto grab" function?

  2. #2
    Registered User
    Join Date
    01-21-2011
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: How to do auto filling of cell from cell above if cell of the left is filled up?

    Hi There,

    if you want to automate this through vba, I can do. Please let me know.

    rgds

  3. #3
    Forum Contributor
    Join Date
    07-29-2005
    Location
    Singapore
    MS-Off Ver
    2007
    Posts
    253

    Re: How to do auto filling of cell from cell above if cell of the left is filled up?

    Hmm...but my excel did not do any vba and it happened.

+ 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