Block Out Columns Deed For Free

Hide and Unhide Columns and Rows Click the Format button located on the Home tab / Cells group then choose Hide Columns or Rows (another option is to Right click on a highlighted column or row heading and select hide). Your Columns and Rows are now hidden.

Select the column that's immediately to the right of the last column you want frozen. Select the View tab, Windows Group, click the Freeze Panes drop down and select Freeze Panes. Excel inserts a thin line to show you where the frozen pane begins.

Click the Format button located on the Home tab / Cells group then choose Hide Columns or Rows (another option is to Right click on a highlighted column or row heading and select hide). Your Columns and Rows are now hidden.

How to freeze a row in ExcelSelect the row right below the row or rows you want to freeze.Go to the View tab.Select the Freeze Panes option and click "Freeze Panes." This selection can be found in the same place where "New Window" and "Arrange All" are located.Jul 20, 2021

Press the Keyboard Shortcut Ctrl + A to select all the cells of the sheet. Right click and choose Format cells. 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.

Hide columnsSelect one or more columns, and then press Ctrl to select additional columns that aren't adjacent.Right-click the selected columns, and then select Hide.

These are the steps you should follow:Select the column you want to protect.Press Ctrl+Shift+F.Make sure the Protection tab is displayed.Make sure both the Locked and Hidden check boxes are selected.Click OK to dismiss the dialog box.With the column still selected, display the Home tab of the ribbon.More items...