Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Shortcut keystroke for locked cell in a formula?

  1. #1
    Guest

    Default

    Do you guys know if there's a keystroke I can use when I want to lock onto a single cell in a formula, instead of having to type those dollar signs every time?

    i.e. If I want the cells to be divided by the total in L32, could I push something and then click on L32 directly instead of having to type in $L$32 instead?

    Thanks!
    Ro

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Denver, CO
    Posts
    1,743
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-02-26 14:39, Anonymous wrote:
    Do you guys know if there's a keystroke I can use when I want to lock onto a single cell in a formula, instead of having to type those dollar signs every time?

    i.e. If I want the cells to be divided by the total in L32, could I push something and then click on L32 directly instead of having to type in $L$32 instead?

    Thanks!
    Ro
    Try typing in
    =2+l32 and then hit f4 before enter.

    This acts a little finicky sometimes. If you highlight your whole formula in the formula bar and cycle through f4 you will run through the various absoluting options.

    good luck

  3. #3
    Guest

    Default

    Perfect, thanks!!!!

    Couple related questions:

    1) If I'm editing a formula that's already on a worksheet, and it refers to four different cells, and I want to go in and change a reference to a single cell to get that locked, is there a way to do so without going in and retyping it with dollar signs?

    2) Is there a way to reference a cell and instead of locking on the individual cell, lock on only the column or only the row?

    Thanks again,
    Rohan

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Denver, CO
    Posts
    1,743
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-02-26 15:08, Anonymous wrote:
    Perfect, thanks!!!!

    Couple related questions:

    1) If I'm editing a formula that's already on a worksheet, and it refers to four different cells, and I want to go in and change a reference to a single cell to get that locked, is there a way to do so without going in and retyping it with dollar signs?

    Hit F2 to edit the formula. Highlight the cell of interest and hit f4.

    2) Is there a way to reference a cell and instead of locking on the individual cell, lock on only the column or only the row?
    A1 is relative
    $a$1 is absolute
    a$1 is relative column/absolute row
    $a1 is abosolute column/relative row.

    Hitting f4 several time will run through these options.

    The help file is a great resource for this. See About cell and range references, and click on the note about relative and absolute references.

    Thanks again,
    Rohan

  5. #5
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-02-26 15:08, Anonymous wrote:
    Perfect, thanks!!!!

    Couple related questions:

    1) If I'm editing a formula that's already on a worksheet, and it refers to four different cells, and I want to go in and change a reference to a single cell to get that locked, is there a way to do so without going in and retyping it with dollar signs?

    2) Is there a way to reference a cell and instead of locking on the individual cell, lock on only the column or only the row?

    Thanks again,
    Rohan
    F4 toggles thru all of the combinations of absolute, mixed and relative references. While editing a formula before pressing F4 highlight the references that you want to change.

    Sorry , IML didn't see your response.

    [ This Message was edited by: Mark W. on 2002-02-26 15:42 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •