Keyboard Shortcut to Lock Cells in Excel (Mac Office)

K

While using a Macbook for a period of time in 2013, I realised that there are some differences when using Mac Office and Windows Office. One example is if I wanted to lock a cell, say for example A1. I would put the dollar sign ($) in from of both the column and row number as follows: $A$1.

This still works in the Mac world if I enter it manually, but in the Windows version of Excel, there was a keyboard shortcut (highlight A1 in the formula bar and then press the F4 button) which would put the $ signs in for you. This method is, by far, very much less tedious than typing the dollar sign each time and moving the mouse to precisely the right location.

However, F4 doesn’t work in Mac. It was only after poking around did I find out that the Mac keyboard shortcut equivalent is not F4, but Apple key + T.

Similar Posts:

About the author

Alvin Poh

I've over 17 years of entrepreneurship experience, having built a tech company to be the top in the country, which was subsequently acquired for an 8-figure sum. As CEO, I led the company through robust growth to 150 employees across 4 countries. After the acquisition, I embraced minimalism, sold off my personal possessions, and started living around the world.

Read more about my story here.

37 comments

By Alvin Poh

About Author

I've over 17 years of entrepreneurship experience, having built a tech company to be the top in the country, which was subsequently acquired for an 8-figure sum. As CEO, I led the company through robust growth to 150 employees across 4 countries. After the acquisition, I embraced minimalism, sold off my personal possessions, and started living around the world.

Read more about my story here.