![]() 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 To know more on Excel go through our Formulas.ĭo follow our YouTube channel for regular updates.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. The below image will help you to visualize better. Once you select UnHide, the Column F and G will be shown again in the worksheet. So right click the column and select UnHide option. Once you select UnHide, the selected column will be shown.Īs we already know this example, i want to unhide the Column F and G again.Then right click the column and select UnHide from the drop down box.Highlight the column on either side of the hidden column which you want to unhide.Once you select UnHide Columns, the Status column will be shown again in the worksheet. So select UnHide Columns options from the Formats option in the Home tab. Once you select Unhide Columns, the selected column will be shown.Īs we already discussed this example for the hiding process, now i want the Status column again to be shown which we previously hide it.Then go to Home >Format (under the group name “Cells”) > Hide & Unhide (under the menu name “Visibility”) and select Unhide Columns.Highlight the column on the hidden column which you want to unhide.what if you want to unhide the data again? You can unhide your data in the following two ways. #TO UNHIDE A COLUMN IN EXCEL HOW TO#Now you know how to hide the data according to your needs. you can see the double line between Column E and Column H which tells that the in-between columns is hidden from the worksheet. Once you select Hide, the Column F and G will be hidden from the worksheet. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |