Block Out Spreadsheet Document For Free

To protect a sheet, select a tab in your Excel workbook, click on the Review tab and choose the Protect Sheet menu option. This option allows for very specific protections of your spreadsheet. By default, the options will almost totally lock down the spreadsheet.

Select the cells which you only allow to change in a worksheet, right click on the selected cells, and then click Format Cells from the right-clicking menu. See screenshot: 2. In the Format Cells dialog box, go to the Protection tab, uncheck the Locked box, and then click the OK button.

Lock selected cells.With the required cells selected, press Ctrl + 1 to open the Format Cells dialog (or right-click the selected cells and click Format Cells), switch to the Protection tab, and check the Locked checkbox.On the Review tab, in the Changes group, click the Protect Sheet button.More items...?Feb 16, 2016

Although the word 'block' is not commonly used in Excel it could refer to perhaps a range of cells or possibly 'blocking' someone from using data in a spreadsheet. This discussion focuses on the term being used to identify a range of selected cells.Hold your shift key down and then click cell F52.

1. Select the cells you need to protect their formatting but only allow data entry, then press Ctrl + 1 keys simultaneously to open the Format Cells dialog box. 2. In the Format Cells dialog box, uncheck the Locked box under the Protection tab, and then click the OK button.

Lock cells to protect themSelect the cells you want to lock.On the Home tab, in the Alignment group, click the small arrow to open the Format Cells popup window.On the Protection tab, select the Locked check box, and then click OK to close the popup.More items...

Protect an Excel fileSelect File > Info.Select the Protect Workbook box and choose Encrypt with Password.Enter a password in the Password box, and then select OK.Confirm the password in the Reenter Password box, and then select OK.

Regular Way of Hiding a Worksheet in Excel PRO TIP: To hide multiple sheets at one go, hold the Control key and then select the sheet tabs (that you want to hide) one by one. Once selected, right-click on any one of the selected tabs and click on 'Hide. This will hide all the worksheets at one go.

To protect a sheet, select a tab in your Excel workbook, click on the Review tab and choose the Protect Sheet menu option. This option allows for very specific protections of your spreadsheet. By default, the options will almost totally lock down the spreadsheet. Let's add a password so that the sheet is protected.

Restrict data entrySelect the cells where you want to restrict data entry.On the Data tab, click Data Validation > Data Validation.In the Allow box, select the type of data you want to allow, and fill in the limiting criteria and values.