+ Reply to Thread
Results 1 to 3 of 3

how do i make a cell consistent in a column of calculations

  1. #1
    Registered User
    Join Date
    10-29-2009
    Location
    Bristol
    MS-Off Ver
    Excel 2007
    Posts
    1

    how do i make a cell consistent in a column of calculations

    I am wondering how to keep a cell number consistent in a column of calculations. i.e.

    i would like to have

    A1/C14
    A2/C14
    A3/C14

    Any solutions short of me just typing out the equation repeatedly?
    I think it has something to do with the $ sign, but am not sure.
    Thanks in advance

  2. #2
    Valued Forum Contributor JeanRage's Avatar
    Join Date
    03-02-2009
    Location
    Nice, France
    MS-Off Ver
    Excel 2003
    Posts
    705

    Re: how do i make a cell consistent in a column of calculations

    Hi,

    Use the function key F4 ...

    HTH

  3. #3
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: how do i make a cell consistent in a column of calculations

    Hitting the F4 key is only really useful if you understand the significance of each option...

    I would suggest first reading XL Help Files regards Relative / Absolute & Mixed References.

    $A1/$C$14

    If you wish to copy to right and have A1 become B1 but C14 remain fixed then:

    A1/$C$14

+ 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