Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Excel: change relative address to absolute address (https://www.askmehelpdesk.com/showthread.php?t=8210)

  • Mar 7, 2005, 01:55 PM
    weixu68
    Excel: change relative address to absolute address
    Hi,
    In Excel spreadsheet, how to change relative address to absolute address for many cells at same time? I know how to use F4 to do the change, but it is not an option when I have to deal with the addresses in a 150 row x 50 column table.
    Thanks,
    Wei
  • Mar 9, 2005, 06:58 PM
    Dreamboat
    I'm getting this answer for you.
    It requires a macro.

    • All times are GMT -7. The time now is 06:50 AM.