How to lock cells in Excel Open the Excel workbook and select all cells in the worksheet with the cells you want to lock by pressing the Ctrl + A buttons on your keyboard.

The ability to lock cells or elements of Microsoft Excel and Google Sheets, but not the full sheet, allows maximum customization and control of a project.

How to lock cells in Excel 1. Select your whole sheet, done most easily by pressing Crtl + A on your PC keyboard, or Command + A on a Mac. 2.

What if you want to lock some cells on your worksheet but not the entire worksheet? In Microsoft Excel, you can lock a specific cell or cells from people trying to edit essential information in them.

These options work in Word and Excel 2010 and later, but we’ll be using the Microsoft 365 versions of the two programs for this guide. The ability to mark a document as final and read-only are ...

Want to protect an important Word document or Excel spreadsheet? Here's how to add a password, make documents read-only, and tap into other tricks to safeguard sensitive files.