When your mouse pointer changes to this special double-headed arrow, all you have to do is right-click and choose Unhide. It is different, however, because instead of a black line dividing the double arrows, there are two black lines with a gap between them. Now, column B should no longer be hidden. Right-click and select 'Unhide' from the popup menu. This double-headed arrow is a bit difficult to describe it looks most closely like the double-headed arrow that appears when you position the pointer over the dividing line between column headers. Question: How do I unhide a column that has been hidden in Microsoft Excel 2010 Answer: Select the column to the right and the column to the left of the hidden column. If you move your mouse pointer into the column header area, and then slowly move it to the left, you notice that it turns into a double-headed arrow with a blank spot in the middle as you position the pointer over the small area immediately to the left of the column B header. You can then display the Home tab of the ribbon and click Format | Hide & Unhide | Unhide Columns.Ī third method is even niftier, provided you have a good eye and a steady mouse pointer. If you release the mouse button when the pointer is over the gray block that marks the intersection of the row and column headers (the blank gray block just above the row headers), then column B and everything to its left, including the hidden column A, are selected. Click the Format tool in the Cells group, then choose Hide & Unhide, then Unhide Columns.Īnother way to display the first column is to click on the header for column B, and then drag the mouse to the left.Make sure the Home tab of the ribbon is displayed.Cell A1 is now selected, even though you cannot see it on the screen.
Download Free Excel 2007, 2010, 2013 Add-in for Creating Innovative Dashboards, Tools for Data Mining, Analysis, Visualization. The below macro will loop through the first 25 columns and check if the value in the row 1 is 0, then hide it. In the Reference field at the bottom of the dialog box, enter A1. Hide-UnHide Columns in Excel Worksheet using VBA Download Example File.To unhide the left-most columns of a worksheet when they are hidden, follow these steps: If you later want to unhide column A, the solution isn't so obvious. For instance, if you hide column A, Excel will dutifully follow out your instructions. What isn't so easy is displaying a hidden column if that column is the left-most column in the worksheet. Excel makes it easy to hide and unhide columns.