So right-click the column and select Hide option Now I want to hide the multiple columns namely Column F and G since I want to know only the Name, Email, Marks and Result. Here is an example which contains the following data: Name, Email, Marks, Result, Subject and Send Email.
Then right-click the column and select Hide from the drop-down box.Select the column you want to hide and press the shortcut key. The shortcut key to hide the column is Ctrl + 0 (zero). you can see the double line between Column C and Column E which indicates that Column D is hidden from the worksheet. Once you select Hide Columns, the Status column will be hidden from the worksheet. So select Hide Columns options from the Formats option in the Home tab. Now I want to hide the Status (Column D) of the product since I want to see only the name and price of the product. Here is an example which contains the following data: Product name, Price and Status. Once you select Hide Columns, the selected column will be hidden.Then go to Home >Format (under the group name “Cells”) > Hide & Unhide (under the menu name “Visibility”) and select Hide Columns.you can either select the entire column or top of the column. Select one or more column which you want to hide.You can hide your data in the following two ways. There may be a situation where you don’t want your data to be deleted but you want to hide it for some time until you want the data to be known.
Now we will move on to the process of hiding and unhiding columns. Once you examine with the example, you will get a clear idea about the hiding and unhiding process in spreadsheet. You can easily do this by using Format option or just by right-clicking and specifying the hide or unhide option. Sometimes it’s better to use hide and unhide columns to see the data you want without any complications. Introduction to Hide and Unhide Columns in Excel Hidden property is turned off, thereby making the column visible.You cannot identify what data you need in a huge set of rows and columns? Want to know the trick to hide and unhide columns in Excel? Then this article will help your worksheet to look easier by using some basic steps to hide and unhide columns. If the column cannot be selected, then an error is generated and the user is again asked for input. The macro prompts the user for which column should be made visible, and then tries to select that column. 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.Enter cell F1 into the Name box and then use the controls available through the Format tool on the Home tab of the ribbon to unhide the column.Unhide the entire range and then rehide C:E and G:M.There are a number of ways this can be done: For instance, I may hide columns C:M and want to later unhide column F. If I have an entire range of columns hidden, I find it a bother to unhide a single column out of all those hidden. I regularly hide and unhide columns in my worksheets.