lock

If you have an Excel spreadsheet or workbook that you want to either share with others, you likely have data that you don’t want them to be able to change. Maybe you want to allow them access to only edit certain cells. On the other hand, you may have data that you want to make sure doesn’t get accidentally changed as you work on the sheet yourself.

Unlike Numbers, you can lock cells in Microsoft Excel in a variety of ways. You can lock specific cells, cell ranges, rows, and columns. There are a few sets of steps in the process, but after you do it once, it will come easily for future workbooks. Here, we’ll walk you through how to lock cells in Microsoft Excel on Mac.