![Excel 2016 For Mac Constantly Locks Up Excel 2016 For Mac Constantly Locks Up](http://cdn.osxdaily.com/wp-content/uploads/2011/08/howto-always-show-scroll-bars-mac-os-x.jpg)
Jan 09, 2017 1. First of all, the Excel is very unstable. Excel keeps freezing and it basically disables my enter Mac. I end up force quitting Excel and Mac works fine. First I thought it might be something to do with Office 365 and ended up investing more in Office 2016. When I move the cursor from one cell to another, the whole sheet starts.
Part 1: How to Protect All Cells in Excel 2016/2013 By default, all cells will be protected from editing, reformatting or deleting if you protect a worksheet. Follow steps below to password protect your Worksheet. Open your worksheet in Excel 2016. Go to Review tab and then click on Protect Sheet. Optionally, you can enter a password that's required to unprotect the sheet (optional).
Keep Protect worksheet and contents of locked cells checked, and then you can select the actions you want to allow users of this worksheet to do. Finally click OK to protect the sheet. Part 2: How to Lock Certain Cells in Excel 2016/2013 Sometimes, you only want to lock selected cells in a Worksheet so that other user still can modify other cells. So follow steps below to lock specific cells in a Worksheet. Select the target cells you don’t want to lock. Right click on the selection and then select Format Cells from the menu. When the Format Cells dialog opens, select the Protection tab, uncheck the box next to Locked and then click OK to unlock the selected cells.
Now you have to go to Review tab - Protect Sheet to protect the worksheet to unlock the selected cells and lock the rest of the cells. Part 3: How to Unlock Protected Cells in Microsoft Excel 2016/2013 No matter you want to unlock all cells or specific cell on a protected Worksheet, simply follow steps below:. Open your worksheet in Excel 2016. Go to Review tab and then click on Unprotect Sheet. If it asks the password to unprotect the sheet, enter the password in the box and click OK. That’s all for how to lock or unlock all/specific cells in Microsoft Excel 2016/2013. Another more secure way to protect your excel document is encrypted it with an opening password to prevent others from accessing to the workbook.
But if you unfortunately forgot the opening password, Microsoft cannot retrieve it. You can use a professional tool to recover lost Excel password for you.
When I had a similar problem, disabling dropbox integration (I never realized I had enabled it) made a huge difference in performance, especially for otherwise trivial things in Office/Excel like copy and paste (which had become unbearable). System Preferences-Security & Privacy-Privacy Tab-'Allow the apps below to control your computer' (dropbox was checked, I unchecked it). Not sure exactly what functionality this took away from dropbox, but it still syncs folders fine, which is all I used it for anyway. (I know this is thread is over a year old, but it's one of the first results in Google so I'm adding this for all the others who come along in hopes it may help them).
I believe there is an out of control process causing this that needs to be force quit to get performance back to normal. Here are my online findings on the topic:.
![Excel 2016 For Mac Constantly Locks Up Excel 2016 For Mac Constantly Locks Up](http://s3.amazonaws.com/digitaltrends-uploads-prod/2017/04/Excel-2016-Info-Options.jpg)
The comments hint towards too many 'open ports'. Force quitting the excel process via activity monitor with the most ports seems to do the job.
I suspect this is a registration connection issue. Office tries to constantly connect home and check that the product is registered.
If you are offline and then go online then the issue occurs. I'm guessing these open ports are in reference to internet connections to a registration server. I have Office 365 Excel 16.10 running on High Sierra (10.13.3).
Copying takes several seconds, sometimes cell comments are not viewable at all & often my previously working Hyperlinks to other files in the same folder don't work. Neither unfreezing pans/rows, adding Excel to System Preferences Security & Privacy Privacy Tab Accessibility nor using Normal View (my standard anyway) made any improvement in its performance. I didn't have Dropbox in my Privacy list. Disconnecting from the internet improved the situation, however. Copying is a little quicker, although viewing comments and using Hyperlinks are still unreliable. I have to say that I don't consider this a practical solution, merely a workaround while waiting for Microsoft to fix the problem.