Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   How to use absolute addressing in excel (https://www.askmehelpdesk.com/showthread.php?t=454581)

  • Mar 5, 2010, 03:59 AM
    [email protected]
    How to use absolute addressing in excel
    How to change absolute addressing to relative addressing
  • Mar 5, 2010, 11:14 AM
    JBeaucaire

    You use the $ symbols to make portions of a reference absolute.

    A1 - column relative, row relative
    $A1 - column absolute, row relative
    A$1 - column relative, row absolute
    $A$1 - column absolute, row absolute

    • All times are GMT -7. The time now is 11:27 AM.