Prevent people from falsifying your numbers

If you have carefully created an Excel sheet, you may want to prevent others from making changes. You can do this by learning how to lock cells in Microsoft Excel sheets.

In this tutorial, we'll also show you how to protect sheets and entire workbooks in Excel to prevent people from making changes to the entire document, rather than just a few cells. We'll also cover how to unprotect sheets in Excel.

You can use the Protect Worksheet feature to prevent people from modifying your Excel worksheets. To do this, open an Excel workbook and select the Review tab above the ribbon menu. The Review tab is located between the Data and View tabs.