Block Out Spreadsheet Form For Free

On the Home tab, in the Font group, click the Format Cells dialog box launcher. Keyboard shortcut You can also press CTRL+SHIFT+F. In the Format Cells dialog box, on the Fill tab, under Background Color, click the background color that you want to use.

Hide cell valuesSelect the cell or range of cells that contains values that you want to hide.On the Home tab, click the Dialog Box Launcher.In the Category box, click Custom.In the Type box, select the existing codes.Type ;;; (three semicolons).Click OK.

Go to the Protection tab and uncheck Locked option and click Ok. Now select only the cells or columns, rows that you want to protect. Right click and choose Format cells again. Go to the protection tab and check Locked option and click Ok.

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...

Create forms that users complete or print in ExcelStep 1: Show the Developer tab. On the Excel menu, click Preferences.Step 2: Add and format content controls. On the Developer tab, click the control that you want to add.Step 3: Protect the sheet that contains the form.Step 4: Test the form (optional)

How to quickly grey out all unused area in Excel?Enable the sheet in which you want to display working area only, and click View > Page Break Preview.Select a range you want to display only, and click Kutools > Show & Hide > Set Scroll Area.If you want to display all, click Kutools > Show & Hide > Unhide All Ranges.

By default, when you protect cells in a sheet or workbook, all of the cells will be locked. This means they can't be reformatted or deleted, and the content in them can't be edited. By default, the locked cells can be selected, but you can change that in the protection options.