Share via

Absolute reference in Excel

Anonymous
2022-07-06T16:29:32+00:00

in excel, what shortcut do I use to get an absolute reference instead of a relative reference (Ex. =$G$4) On my former computer, I would simply hit F4 but on my HP laptop that doesn't work.

Microsoft 365 and Office | Excel | For home | Android

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-07-06T16:45:27+00:00
    4 people found this answer helpful.
    0 comments
  2. Anonymous
    2022-07-06T17:02:14+00:00

    Hi Bob,

    I'm Michelle and I'd be glad to help you out with your query or concern.

    An absolute cell reference is necessary when we want to lock the position of a certain cell in order to copy the cell for further use. This should work now.

    SHORTCUT CELL REFERENCE DESCRIPTION
    Press F4 key Single Cell or Cell Range Allows changing neither the column nor the row.
    Press the F4 key twice Row Reference Allows changing the column reference but the row reference is fixed.
    Press the F4 key thrice Column Reference Allows changing the row reference but the column reference is fixed.

    If you’re running MAC, use the shortcut: ⌘ + T to toggle absolute and relative references. You can’t select a cell and press F4 and have it change all references to absolute. You need to have your marker placed inside the reference in the formula before it works when you hit the shortcut.

    I hope this information helps you. If you have any questions, please do let me know and I'll be more than happy to assist you further with this.

    Best Regards,

    Michelle

    10 people found this answer helpful.
    0 comments