Block Out Spreadsheet Resolution For Free

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.

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.

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.

Step by step process How to grey out unused areas of a worksheet: ExcelFirstly, open your Excel document.After that, select the row header under the last row that contains a record of information on your sheet.Press (Control/Command + Shift + Down arrow).Click the fill color button.Select any shade of grey.More items...

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.

Unlocking a Locked Excel File on a PCFrom Explorer, search for the Excel File in question.Right-click on the Excel file you want to edit.Select Properties.Go to the bottom of the General Tab.Uncheck the Read Only check box.Click OK to finalize.

Open your workbook and select the worksheet you want to hide rows and columns in. Click the header for row 31 to select the entire row. Press and hold the Shift and Ctrl keys on the keyboard. At the same time, press the down arrow key on the keyboard to select all rows from row 31 to the bottom of the worksheet.