Then choose Format→Column→Hide. Or right-click the column header and choose the Hide option. To unhide rows or columns: You must first select the surrounding rows or columns by using the dark arrow cursor in the row number or column heading before you can unhide by choosing Format→Row (or Column)→Unhide. You can also select surrounding rows or columns, right-click the row or column header, and choose the Unhide option in the resultant menu. Excel brings back the hidden B column, and all three columns (A, B, and C) are selected. You can then click the mouse pointer on any cell in the worksheet to deselect the columns. You could also unhide column B by selecting columns A through C, right-clicking either one of them, and then choosing the Unhide command on the column shortcut menu.
Advertisement If you’re dealing with a data-heavy spreadsheet, sometimes it’s helpful to hide or unhide rows and columns to better see the information you need to analyze. Fortunately, Excel makes it easy to do this.
How to Hide Columns and Rows in Excel. Select the column(s) or row(s) you want to hide. You can select multiple columns or rows that are side-by-side by holding down the Shift key, otherwise you can select multiple cells by holding down the Control key ( Command on Mac). You can also type in the row or column identifier in the name box to the left of the formula field, so if you want to hide the second row, for example, type B2.
Once you’ve made your selection:. In the Home tab under the Cells group, click Format Hide and Unhide Hide Rows or Hide Columns. Or you can right click on the Excel worksheet in the column or row you want to hide and click hide. (This method will not work if you’ve typed in the row or column identifier.). The column or row will be removed, and you’ll see a thin double line indicating where the hidden column or row was.
How to Unhide Columns or Rows There are a few ways to select which rows or columns you want to unhide:. Right click the thin double line indicating a hidden row or column and click Unhide. Click on the thin double line indicating a hidden row or column to select it. If you want to unhide all rows or columns, select all using the keyboard shortcut Ctrl or Command + A.
In the Home tab under the Cells group, click Format Hide and Unhide Unh ide Rows or Unh ide Columns. While you can hide or unhide either multiple rows or multiple columns at the same time, you can’t hide or unhide both rows and columns simultaneously. What are your favorite Excel productivity tips? Let us know in the comments. Explore more about:.
Quick Tip for Microsoft Excel 2010 Here is how you Hide and Unhide Rows and Columns Microsoft Excel 2010 Sometimes you might want to present your information but choose not to show one or more columns of data. In Excel you can hide one or more columns so the information is still used in calculations on the sheet, but is not visible. To Hide a Column. Right-Click on the Column Heading of the column you wish to hide (1). In the menu that appears, Click on Hide (2) To hide more than one Column. Click and drag across the Column Headings to select the Columns you want to hide (1). Right-click on the Column Headings to bring up a menu (2).
Select Hide from the menu (3) Unhide a Column. Click and drag across the Column Headings (e.g. H-J in this example) to select the columns around the hidden column. Right Click on the Column Heading (2). Select Unhide from the menu (3) Hide a Row or Rows Sometimes you might want to present your information but choose not to show one or more rows of data. In Excel you can hide one or more rows so the information is still used in calculations on the sheet, but is not visible. To Hide a Row.
Right-Click on the Row Heading of the row you wish to hide (1). In the menu that appears, Click on Hide (2) To hide more than one Row. Click and drag down the Row Headings to select the rows you want to hide (1). Right-click on the Column Headings to bring up a menu (2). Select Hide from the menu (3) To Unhide a Row.
Click and drag down the Row Headings (e.g. 2-4 in this example) to select the rows above and below the hidden row. Right Click on the selected area (2). Select Unhide from the menu (3).