How to Protect Cells in Microsoft Excel

Taylor Karl
/ Categories: Resources, Microsoft Office
How to Protect Cells in Microsoft Excel 1866 0

How to Protect Cells in Microsoft Excel

Select the cells you want to lock: You can complete this in several ways.

  1. Click the first cell, then hold the CTRL button on your keyboard down, and continue clicking on the cells you want to select. This option is perfect for cells scattered throughout your sheet.
  2. If your cells are grouped together, you can select them by clicking on the first cell you want to protect and dragging your mouse in the direction of the other cells until they are all highlighted in gray.

Select the Home tab: This section resides right next to your "File" tab in the top right corner of the page
Head to the Alignment Section and click the small arrow to open the Format Cells popup window: This is completed by hitting the 90-degree angle with the arrow inside of it as pictured below.


Select the Protection tab: Listed as the last tab on your pop-up screen.

Select the Locked check box, and then click OK to close the popup: This will result in all the cells you selected to now be protected.

Just like that, you are done!

Still, looking for more Excel tips? Head to our blog for more instructional articles or you can venture to our webinar page to see our schedule of upcoming events.

Top 20 Office Tips eBook

Submit your email below to download our free 49-page eBook, Top 20 Office Productivity Tips