When the pointer changes from the selection arrow to a double arrow - this will happen as the mouse pointer nears the Select All cell - right-click and choose Unhide. Hover the mouse over column B’s header cell and move left.Now, choose Column from the Format menu, and the choose Unhide. Doing so will selecteverything to the left, including column A. Release the mouse with the pointer over the Select All cell (the blank gray cell that intersects the header and row cells). Don’t click any borders, just drag the selection mouse pointer (the fat arrow pointing down). Click column B’s header cell and drag the mouse pointer to the left.Don’t panic, column A isn’t gone forever, and there’s more than one way to unhide it: Selecting just column B won’t select column A. So, all you need to do is apply the same steps we’ve provided above. That works fine until you try to unhide column A, as there’s only one adjacent column, column B. If you’re an Excel 2016 user, the steps to hide and unhide tabs are identical to Excel 2019. After selecting the hidden column and its adjacent columns, choose Column from the Format menu and then select Unhide. You’re really selecting three columns: the hidden column and both columns on either side of it. Select the columns that are adjacent to the hidden column. Unhiding a column takes a bit of specialized knowledge, but it isn’t difficult. To hide a column, select it, choose Column from the Format menu, and then select Hide. SEE: Download: Build your Excel skills with these 10 power tips (TechRepublic) Hiding a column tucks data out of sight without interfering with its function. Even you won’t want to see all of it all the time. Confidentiality aside, sometimes endless data is just a nuisance. Not everything in your worksheet needs to be privy to everyone. Fortunately, there are two simple tricks for unhiding it. If Cells(1, i) = 0 or Cells(1, i) = “” Then Columns(i).EntireColumn.The secret to unhiding column A in an Excel worksheetĪfter you hide column A, it might seem like it's gone forever. You might need to hide/unhide rows or columns during a visual prese.
#HOW TO UNHIDE A COLUMN IN EXCEL 2016 HOW TO#
‘Hide all the columns with the values as 0 in Row 1 In this Microsoft Excel Tutorial, you will learn how to hide and unhide columns and rows. Sub hideColumnsBasedOnConditionZeroBlank()įor i = 1 To LastColumn ‘Lopping through each Column If Cells(1, i) = 0 And Cells(1, i) "" Then Columns(i).EntireColumn.Hidden = TrueĮxample macro to check if row 1 of a column is 0 or blank and hide: 'Hide all the columns with the values as 0 in Row 1 The below macro will loop through the first 25 columns and check if the value in the row 1 is 0, then hide it.Įxample macro to check if row 1 of a column is 0 and hide:įor i = 1 To LastColumn 'Lopping through each Column We can hide the columns based on certain condition. Note that you are clicking the space between the letter A and the. Step 2: Click the top-left corner of the worksheet to select the entire sheet. Step 1: Open the workbook containing the columns that you want to unhide.
#HOW TO UNHIDE A COLUMN IN EXCEL 2016 CODE#
You can download the example file and see the code for each button.ĪNALYSISTABS – Hide-Unhide Columns Hide Columns Based On Condition in Excel Worksheet using VBA I am using Microsoft Excel 2013 in the steps below, but these steps will also work in other versions of Excel as well. Hide-UnHide Columns in Excel Worksheet using VBA – Download Example File You can click on the buttons to view the respective data.
You can download the file below and see how its working. Hide-UnHide Columnsin Excel Worksheet using VBA – Case study Here is sample screen-shot of the example file.
Copy the above code and Paste in the code window.Code:Ĭolumns("B:D").EntireColumn.Hidden = TrueĬolumns("B:D").EntireColumn.Hidden = False And then un hiding by setting the Hidden=FALSE. In this example I am hiding the Columns B,C and D by setting the Hidden property as TRUE. The following example will show you how to hide and unhide the Columns in Excel using VBA. Hide-UnHide Columns in Excel Worksheet using VBA – An Example You can set the property value to TRUE if you want to hide, Set to FALSE if you want to un-hide the Columns. We can use EntireColumn.Hidden property of a Column. Hide UnHide Columns in Excel Worksheet using VBA – Solution Hide Columns Based On Condition in Excel Worksheet using VBA.Hide UnHide Columns in Excel Worksheet using VBA – Download Example Files.
We may need to Hide UnHide the Columns in Excel for some types of requirements.
0 kommentar(er)
