Excel for Office 365 for Mac Excel 2019 for Mac Excel 2016 for Mac To prevent a user from accidentally or deliberately changing, moving, or deleting important data, you can lock cells and protect them. Locking cells takes two steps: adding the Lock formatting to the cells, and then turning on protection of the sheet. To lock cells • Select the cells that you want to lock. • On the Format menu, click Cells, or press + 1.

Keyboard Shortcut to Lock Cells in Excel (Mac Office) February 28. New to mac, the excel program is driving me insane. But I’m trying. I’m largely self-taught on the program too. Hey dude, U rock, I short of words to explain how much your tip has helped me. Faith on November 30, 2009.

• Click the Protection tab, and then make sure that the Locked check box is selected. Note: The password is optional. If you do not supply a password, any user can unprotect the sheet and change what was protected. If you do enter a password, make sure that you choose a password that is easy to remember, or write it down and keep it in a safe place. If you lose the password, you can't access the protected parts on the sheet. • If you don't want people to select locked cells, click to clear the Select locked cells check box. • If you want people to be able to select and fill out unlocked cells, click to select Select unlocked cells.

• Before you click OK to finish, you might want people to do other things to the locked cells, like select them or format them. If so, under Allow users of this sheet to, choose the elements that you want people to be able to select or change.

To unlock cells • You may need to temporarily turn off protection so that you can unlock cells. On the Review tab, click Unprotect Sheet or Unprotect Workbook. Setting up gmail account in windows mail. Then type the password. • Select the cells that you want to unlock.

Then click to clear the Locked check box so that it is not selected. • If there are other cells that still need to be locked, on the Review tab, click Protect Sheet or Protect Workbook. Then type a password for the sheet, and verify it by typing it again.

If you use Excel on both the Mac and the PC, you’re probably aware that there are numerous differences between the two platforms’ keyboard shortcuts. Using the View -> Customize Toolbars & Menus menu item (in Excel 2008; View -> Toolbars -> Customize Toolbars/Menus in Excel 2004), you can change the shortcuts on your Mac to match those on your PC.

(You could do it the other way around, of course, setting your PC up to match your Mac.) This works well for most shortcuts, but there’s one in particular that I use all the time that’s immune to this solution: the keyboard shortcut for ‘edit this cell.’ On the PC, you can edit the current cell in place by simply pressing F2. On the Mac, the equivalent keyboard shortcut is Control-U, as F2 is assigned to cut the contents of the current cell.

(If you’d like to see all of Excel’s keyboard shortcuts, open Help -> Excel Help, then type keyboard shortcuts in the search box, and then select Excel Keyboard Shortcuts in the results box. You’ll probably find quite a few that you didn’t know about.) After many years of using a PC in my prior job, I found the Control-U shortcut not only hard to remember, but harder to type. Unfortunately, you won’t find the “edit this cell” command listed in Excel’s keyboard customization section, so there’s no apparent way to change the shortcut. With a bit of help from a third-party program, though, you can achieve the same end result—make F2 edit the current cell in Excel (2004 or 2008) on the Mac.

To make this work, you’ll need some sort of program that supports macros; I’m going to use, but you should be able to use,, or, or any similar program. You’ll have to modify the instructions, of course, to match the program you’re using, but it’s a pretty simple technique—the macro program will be used to send a Control-U to Excel when you press F2. To do this in Butler, select Butler -> Customize from Butler’s menu, and then make sure you’re on the Configuration tab. Click somewhere in the Hidden section (or in any other section where you’d like to put the command), then click the Plus sign at the bottom left of Butler’s interface. Select Smart Item -> Keystrokes, which will add a new macro entry in the Hidden section. To define your macro, name it (using the topmost box on the right-hand side of Butler’s window), and click on the Keys tab immediately below that. In the Keys section, type Control-U, then click the Triggers tab.