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.
![How To Show Hidden Rows In Excel How To Show Hidden Rows In Excel](/uploads/1/2/5/4/125439323/788646399.png)
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.
Sep 22, 2015 - Spotting hidden rows and columns in Excel is very troublesome. Luckily, there are two ways for simplifying the process to unhide all rows. Many people love the “Hide” function for hiding rows or columns, as it is very easy to use: (the numbers are corresponding with the image) Mark the row(s) or column(s) that you want to hide. Right-click on the row number or column letter and click on “Hide”. Unfortunately, it has one big disadvantage: Hidden rows or columns are very hard to be seen.
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).