how to freeze first two rows in excel on mac

Editors will be able to see locked columns/rows, but they won't be able to delete or edit the data in them.

Others with Owner or Admin permissions will be able to edit and delete locked columns and rows.

You must have Owner or Admin permissions to a sheet to lock or unlock columns and rows.

Here are some things to keep in mind about locking columns and rows:

More information on this is available in Automate Your Work with Alerts and Actions. You can create rules that lock rows automatically when specific conditions are met. Similarly, cells in newly inserted rows won't be editable in locked columns.Īnother way to protect your data is to use the right sharing permissions when you share your sheet (for example, share a sheet to someone with Viewer permissions rather than Editor permissions if you don't want them to be able to make changes). Data contained in cells in locked rows or columns cannot be edited.

If you want to protect key data from being changed or deleted by others who are shared to your sheet, you can lock columns and rows.

How to freeze first two rows in excel on mac