If the column cannot be selected, then an error is generated and the user is again asked for input. 2 To do this, you need to press ( CTRL + SHIFT + 0 ) keys and it will unhide columns of the current selection in Excel.
The macro prompts the user for which column should be made visible, and then tries to select that column. How to use keyboard shortcut to unhide columns in Excel Shortcut Description: 1 This shortcut key will unhide columns that intersect the current selection. MsgBox "Column " & UCase(Col) & " is now visible.", _ MsgBox "Invalid input! Please input a valid column."
Consider the following:Ĭol = InputBox("Enter column to unhide.", "Unhide Column") Unhiding either a single column or a range of columns is very easy to do through a spiffy little macro. There are a few other ways to unhide the column, as well, but (as I said) I find such approaches a bother. Enter cell F1 into the Name box and then press Ctrl+Shift+0 to unhide the column.
After that press, Ctrl+Shift+9 buttons simultaneously from the keyboard or just right-click anywhere on sheet and select unhide.Īnd for unhiding all rows at once, after selecting the whole sheet, right-click on the top area of the rows where the serial numbers are given (A, B, C.) and select unhide.I regularly hide and unhide columns in my worksheets. To unhide all hidden columns in any Excel sheets, go to the top left corner of your sheet area and click on + icon to select the whole sheet or alternatively you can use Ctrl+A shortcut. You might need to hide/unhide rows or columns during a visual prese. To unhide the entire column, highlight the upper and lower column, for example in the above screenshot we hid 12th number column and to get it back we use mouse pointer for highlighting above and lower ones and after that, we will right-click on it to select the unhide option or use keyboard shortcut Ctrl+Shift+9. In this Microsoft Excel Tutorial, you will learn how to hide and unhide columns and rows. Hide entire column, select, right-click and hide.
On your Excel to hide any complete row, go to it and right-click on top of it where the serial number series is given such as A, B, C, D and so on.If you already on that move to the next step. Unhide all columns and rows in excel Hide or Unhide a complete Row in Excel