AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
![]() ![]() I've found out that fn + f4 does work when you're inside the formula editor. Lock multiple cells in Google Spreadsheets with absolute reference ($) NB: I'm not looking for this solution where you use find and replace. I have a lot of cells that need to be anchored like this, and doing it manually will take a lot of time. The shortcut for applying absolute reference (or "anchoring") to a cell in Google Sheets on a Mac is: fn + f4Ĭould someone please provide a solution so that I can anchor multiple cells at once in my Google Sheet? So it needs to become $B$12.Īccording to this answer: Shortcut to anchor a cell in Google Sheets + Chrome + Mac + 2020Īnd also according to the official documents from Google sheets: I want my cell B12 to be anchored using absolute reference. ![]()
0 Comments
Read More
Leave a Reply. |