What's the shortcut to apply absolute reference to a cell in Google Sheets on Mac?

user_8837512 0
Viewed 11079

I want my cell B12 to be anchored using absolute reference. So it needs to become $B$12.

According to this answer: Shortcut to anchor a cell in Google Sheets + Chrome + Mac + 2020

And also according to the official documents from Google sheets: https://support.google.com/docs/answer/181110?p=spreadsheets_shortcuts&visit_id=637202590745115819-3984292513&rd=1

The shortcut for applying absolute reference (or "anchoring") to a cell in Google Sheets on a Mac is: fn + f4

However, on my Mac this isn't working...

Could someone please provide a solution so that I can anchor multiple cells at once in my Google Sheet?

I have a lot of cells that need to be anchored like this, and doing it manually will take a lot of time.

NB: I'm not looking for this solution where you use find and replace. It's a workaround, not a solution. Lock multiple cells in Google Spreadsheets with absolute reference ($)

EDIT:

I've found out that fn + f4 does work when you're inside the formula editor.

This was not exactly what I'm looking for, as I still cannot bulk edit multiple cells. But it seems that this is the only thing that's possible.

google-sheets macos
1 Answers

I was having the same problem with my Mac but found a solution. When creating an absolute reference, you have to put your cursor between the cell column letter and cell row number within the cell formula and then press fn + F4. So, =SUM(B5.... to make the "B5" an absolute reference you would need to put your cursor between the B and 5 and then press fn + F4.

user_156479820
Related