The Mac keyboard shortcut command A will perform the Select All action. They can still turn off the protection, if they know what to look for-but luckily, most people don't. The diagram below shows the special characters a US Mac keyboard will produce.
a mac book pro thanks Select one line above or below: Shift+Home/+End: Select. This feature will give people warning if they try to edit the spreadsheet. Learn how to use Command or Shift to select multiple items in the Finder. Instead, we recommend just turning on the protection without adding a password. However, be careful with password protection, as you can risk locking yourself out of the spreadsheet if you forget the password (unlike your Facebook account, for example, you can’t just reset your Excel spreadsheet password). Another nice feature is the ability to add a password. Only people who know the password can turn off the protection and make edits. In the same window, you also have the option of turning on certain functionality while keeping others locked. To turn on Protection, go to Tools > Protection.
The Protection function locks all cells by default, so nobody can enter or alter any information. On the toolbar for Excel for Mac, select Layout 9 from the Quick Chart Layouts. Some of the Microsoft Excel shortcut keys below may not work in. Add the equation to the trendline and you have everything you need. If you share spreadsheets with colleagues but don’t want them to change the content, the Protection function in Excel can be helpful. Excel 2016 Mac - Where is Find & Select, Find & Select on Excel for Mac.
