Hiding Unused Columns & Rowsīy default, a new Sheet has more than sixteen thousand blank columns and over a million blank rows. Now, when a user scrolls vertically or horizontally, the two columns and rows of interest remain static. Place focus on the first data cell (in the example file, the first data cell is located at C3 and has the text 'C3 data').There are row headers in cells B3 to B10 in the second column of the sheet, so we would recommend also freezing the first two columns: To freeze more than one column and/or row: The first column of this sheet has been left empty to provide some visual spacing for the table. In this example we recommend freezing the first two rows: The column headers are in cells B2 to Z2, in the second row of the sheet. This sheet has descriptive text-'Freeze Panes'-in the upper-left corner, which in this case is cell B1, in the first row of the sheet. There may be times when you want to freeze more than one column and/or row at a time. Now the row headers remain visible as a user scrolls right: Freeze Panes Return to the View tab and click 'Freeze First Column': When a user scrolls across to see more columns, the row headers are moved out of the visible area: The 'Freeze First Column' sheet has a table with row headers, and columns of information that extend beyond the visible area: Now when a users scrolls down, the column headers remain visible and the rows appear to slide under them: Freeze First Column To prevent this, click 'Freeze Top Row' on the View tab on the Ribbon: When a user scrolls down to see the all the rows in the table, the column headers are no longer visible: The same convention is used in the other sheets in this workbook. Starting at the left, the data cells are labeled: A2 data, B2 data, C2 data, etc. The column headers are labeled with generic text that corresponds to Excel's built-in labels: Column A, Column B, Column C, etc. The 'Freeze Top Row' sheet on the example file has a table with column headers, and rows of information that extend beyond the visible area: In the fourth section from the left there are three 'freeze' tools: In this circumstance we recommend that you use one or more of Excel's 'freeze' tools. When a sheet has populated columns and/or rows that extend beyond the visible area, a user must scroll with the keyboard or mouse to see all of the sheet's contents. These techniques are applied at the sheet level, so the columns and rows in each sheet of a workbook must be evaluated separately. With some spreadsheets, managing how columns and rows function, and their visibility, will provide benefits for some users. Increase the numerical value in the 'Row Height' dialog box.Right-click on any row label and select 'Row Height' from the drop-down menu.Select the whole sheet with the keyboard shortcut Control + A.Increase the numerical value in the 'Column Width' dialog box.Right-click on any selected column and select 'Column Width' from the drop-down menu.Place focus on the populated columns by selecting their column labels.To practice these techniques, switch back to the 'Visual Spacing' sheet. Some users will find this visual presentation easier to process.

To see the visual impact of increasing the column widths and row heights, switch to the 'Freeze Top Row' sheet in the example file: This sheet shows a table with the default spacing for the columns and rows: When the example file is opened, the 'Visual Spacing' sheet should be displayed by default. A common legibility issue in Excel workbooks is minimal spacing around text. In the context of electronic documents legibility may defined as 'How easy text is to see and comprehend based on its visual presentation”.

Excel keyboard shortcut row height