Menu
Not every problem is big. Sometimes, it’s the little repetitive gotchas that drive you nuts. This month, I’ll share a few problems that seemed large to the readers but have simple solutions. Unhide columns and rows Mark had trouble applying the technique I shared in a previous post called, '.' When unhiding columns or rows, you select the adjacent columns or rows first.
Excel 2010 offers two types of column headings; the letters the Excel assigns to each column, which you can toggle in both view and print modes, or the. Click the 'View' tab, and then click the 'Freeze Panes' button in the Window area of the ribbon. Your column headers now stay visible as you scroll down the spreadsheet.
That’s a problem if the hidden column or row is column A or row 1. You can’t select the column to the left or the row above, because neither exists. The technique I shared works, but Mark was trying to unhide columns A though D, not just column A. If you have adjacent columns or rows hidden, you have two options:. You can unhide column A using the technique shared in the linked article above and then unhide the remaining columns as you normally would by selecting the adjacent columns. You can unhide the continuous block of columns using the technique shared in the linked article above, which is more efficient that the first method.
Let’s walk through the second method with a short example where columns A through D are hidden:. First, hide columns A through D by selecting those four columns and right-clicking the selection. Choose Hide from the resulting contextual menu. Now, you’re ready to unhide them. In the Name box — to the left of the Formula bar — enter A1:D1 (as shown in Figure A). Notice that the first visible column is E. Figure A.
Press Enter. Doing so will select A1: D1, but you won’t see that happen. The columns are still hidden. Click the Home tab.
From the Format dropdown in the Cells group, choose Hide & Unhide. In Excel 2003, choose Column from the Format menu, and choose Unhide.
Select Unhide (as shown in Figure B) and Excel will expose all four hidden columns at the same time.