If you’ve found this tutorial helpful, like us and subscribe to receive more videos from Eas圜lick Academy. The whole sheet is now highlighted.ĭo the right-click on the column headings part, pick the Unhide option – all columns in the whole spreadsheet will become visible. If you want to unhide all columns in the whole spreadsheet, click here, into the top left-hand corner. How to Unhide All Columns in the Whole Spreadsheet Let’s undo the changes to see the second useful tip. This is how you highlight the hidden column A from both sides. If the column hidden is the column A, which is the very first in the spreadsheet, you’ll need to select the column B first (which is the column on the right), and then highlight the row headings (containing numbers) on the left. How to Unhide the Very First Column in Excel Go to the Home tab, Cells section, choose the option Format, then option Hide & Unhide from the menu, and we’ll click on Unhide Columns.īefore we wrap it up, I’ve got a couple of handy tips for you. Once again we’ll select the columns we want to unhide the same way we did earlier.
#How unhide a column in excel how to#
The Second Way How to Unhide Columns in Excel We’ll undo the changes now to have a look at the other way how to unhide columns in Excel. These columns then appear in the table on the screen and if you want to print the sheet out, they will also appear on the printed copy. Right-click, find the option Unhide which will make the hidden columns visible again. You can do it by selecting one column on the left- and one on the right-hand side of the column or columns you want to unhide. Here’s one of them! The First Way How to Unhide Columns in Excelįirst, you’ve got to select the columns you want to unhide. In this case, however, we see the column C right next to the column F, which means that the columns D and E have been hidden.Īnd it’s time to learn two simple ways how to unhide these columns. Normally, the letters would go A, B, C, D, and so on. Skipped letters of the alphabet is another sign how to recognise that some columns have been hidden. One way to find them is to look for ‘a double-line’ among the column headings. How to Spot the Hidden Columns in a Spreadsheet Generally, it’s quite easy to spot the hidden columns in a spreadsheet. In the previous tutorial, we learned how to hide columns in Excel. If Cells(1, i) = 0 or Cells(1, i) = “” Then Columns(i).EntireColumn.5 How to Unhide All Columns in the Whole Spreadsheet ‘Hide all the columns with the values as 0 in Row 1 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.
#How unhide a column in excel 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 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. Save the file as macro enabled workbookĭownload the example file available at end of the topic and execute the macros.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. Unhiding columns in newer versions of Excel I f youre in a newer version of Excel, like I am, and you have a really steady hand, you can try clicking and dragging on the double lines up in the Column Header bar. The following example will show you how to hide and unhide the Columns in Excel using VBA. So thats a great way to unhide columns when you have randomly hidden columns and you want to avoid unhid ing ALL of the columns. 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.Hide UnHide Columns in Excel Worksheet using VBA – Case study.Hide UnHide Columns in Excel Worksheet using VBA – An Example.We will see this in the following examples… We can achieve this by Hiding or Un-hiding the Columns in Excel. For examples we may have data for 3 different categories and want to show it based on the user selection. We may need to Hide UnHide the Columns in Excel for some types of requirements.