Open your workbook and navigate to the worksheet where you wish to conceal rows and columns. To select the complete row, click the header for row 31. Hold down the Shift and Ctrl keys on your keyboard. Press the down arrow key on the keyboard at the same time to select all rows from row 31 to the bottom of the worksheet. Now right-click one of the selected rows and choose Limit Rows from the menu.
Check that the "Home" tab on the ribbon is selected. Click "Format" in the "Cells" group. Select "Hide & Unhide" from the "Visibility" submenu, and then "Unhide Sheet" from the submenu. The dialog box "Unhide" appears. Select the worksheet you wish to unhide and click "OK," as indicated above. Click the "View" tab to hide a full worksheet. Clicking this button will cause all sheets in the workbook to be hidden.
You can conceal sensitive or confusing data by hiding rows or columns. A mechanism for hiding and revealing columns and rows.
Click Format in the Cells group on the Home tab. Choose one of the following options: Click Hide & Unhide under Visibility, then Unhide Rows or Unhide Columns. Both methods hide and show cells based on their contents, not their location.
Select Hide Columns or Rows from the Format menu on the Home tab/Cells group (another option is to right click on a highlighted column or row heading and select hide). Your columns and rows are no longer visible. You can show them again by selecting Show All from the same menu.
Limiting the displayed or scrollable worksheet size
To remove undesired rows and columns from your spreadsheet, just highlight the row or column by clicking the marker at the top of the column or to the left of the row, then right-click it and select delete. I hope this is of assistance to you.
Choose the row or rows that you wish to modify. Click "AutoFit Row Height" under Cell Size. To rapidly auto-fit all the rows on the worksheet, click the Select All button, then double-click the border beneath one of the row headings. To change the size of only a few cells, use the font and cell style options available in the Fonts and Styles groups.