To unhide row 1, right-click the row 2 header or label and pick Unhide Rows. To unhide column A, right-click the column B header or label and pick Unhide Columns. In this picture column A and row 1 are hidden. T here are certain situations when you can’t unhide columns on the left and/or rows at the top and it is not a sheet protection issue. Using the modified code in my post, ToggleButton2 currently shows all the Budget from columns D:AA and AF:BC, I actually want it show all the budget columns from D:AA but the actuals from columns AF:BC (so the budget columns in AF:BC should be hidden). If you don’t see the first column (column A) or row (row 1) in your worksheet, it might be hidden. When the GoTo window appears, enter A1 in the Reference field and click on the OK button. Let's say I hide column A in excel or in google doc, how can I unhide it (show column A again).Column A is the most left column. In the Editing group, click on the Find button and select 'Go To' from the popup menu. ValueĪwesome - just a slight requirement change for ToggleButton2 as it actually came to my mind - my apologies. Question: How do I unhide row 1 in a sheet in Microsoft Excel 2007 Answer: Select the Home tab from the toolbar at the top of the screen. Caption = "Hide Budgets"įor Each col In Range("D:AA, AF:BC").Columns
0 Comments
Leave a Reply. |