Are you unable to modify cells because they are locked? Here’s how to lock or unlock cells in Microsoft Excel 2016 and 2013.

To lock cells. Select the cells that you want to lock. On the Format menu, click Cells, or press + 1. Click the Protection tab, and then make sure that the Locked check box is selected. Note: By default, all cells have the Locked formatting unless. If any cells should be unlocked, select them. I have recently bought a Mac book pro. Till now have been using a acer laptop. Can any one help with the following. I want to transfer all my data( mostly word, excel and photos) to my Mac. What software do i use to in Mac to be able to use the word and excel. Iam not computer savy so going nuts now.

1. Select the cells you wish to modify.
2. Choose the “Home” tab.
3. In the “Cells” area, select “Format” > “Format Cells“.
   
4. Select the “Protection” tab.
   
5. Uncheck the box for “Locked” to unlock the cells. Check the box to lock them. Select “OK“. As the dialog box says, locking cells or hiding formulas has no effect until you protect the worksheet. You can do so under the “Review” tab by selecting “Protect Sheet“.
   

FAQ

But, why is “Protect Sheet” is grayed out?

Corz wee script pack for mac. Corz wee script pack for Mac OS X Things to do in a terminal session. At first, had no scripts on my mac, then I had loads Now I seem to have just the right amount. I got tired of typing the same things over and over, especially long path statements. This is a small selection of my favourites. More to come soon, for sure. Up to Mac Archive Home. Soft stuff data for in your downloading the manager. Corz wee script pack fun things in your terminal Darkstat for OS X likes to sniff packets. Make big fun now!;o)Cor. A trillion batch tests later. Just Add Files! Faster than the others! Welcome to corz.org!

If it’s a shared workbook, “Protect Sheet” may be grayed out. Best free screensavers for mac. Unshare it by selecting “Review” > “Share Workbook“, then deselect “Allow changes by more than one user…“.

Otherwise, multiple worksheets are selected. Right-click any tab, then select “Ungroup Sheets“.