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.
