+ Reply to Thread
Results 1 to 2 of 2

Auto fill options

  1. #1
    Registered User
    Join Date
    04-14-2010
    Location
    Florida
    MS-Off Ver
    Excel 2007
    Posts
    1

    Auto fill options

    I can't find online how to deal with this fill problem.

    I have a column where I want to drag a fill. Usually that's no problem. But the equation has some cell values in it that I DON'T want it to change, but it does no matter what I do. How can I have some values increment (A1, A2, A3... etc) but others don't (C5 is always C5)

    Example of what I want to happen after using the auto fill from

    A1+C5
    A2+C5

    Creates

    Cell Row 1: A1+C5
    Cell Row 2: A2+C5
    Cell Row 3: A3+C5
    Cell Row 4: A4+C5
    Cell Row 5: A5+C5
    ...
    Cell Row n: An+C5

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885

    Re: Auto fill options

    Hi Schreck, welcome to the forum.

    To keep a cell reference static, you add $ in front of the column letter or row number.

    $C$5 will always reference cell C5
    $C5 will always reference column C, but the row can change if you drag up or down
    C$5 will always reference row 5, but the column can change if you drag left or right.

    So:

    =A1+$C$5

    filled down should do what you're after.

+ 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