But it seems that this is the only thing that's possible. This was not exactly what I'm looking for, as I still cannot bulk edit multiple cells. 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? ABS Excel function is also known as Absolute function which is used to calculate the absolute values of a given number, the negative numbers given as input. 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.
