3 Quick Ways to Unhide Columns in Excel


Amazon Affiliate


Excel is largely used when you are working with a large amount of data and you need to sort through them.

Excel is for professional use and daily use as well. Students use it as well when they are working with large data. And it also offers so many functions which make working with a large amount of data pretty easy.

And you can create different columns for different ranges of data. And excel also offers the option to hide certain columns if you are not working on them.

3 Quick Ways to Unhide Columns in Excel

If you were not aware of how to hide or unhide columns in excel then in this article I will give you a complete step-by-step guide on how to hide and then unhide columns on excel sheets.

Excel

  • Step no.1: Open Microsoft Excel on your computer.
  • Step no.2: Now open the document you are working on.
  • Step no.3: Now select the columns you wish to hide.
  • Step no.4: Once you have selected the column to hide, right-click on the column.
  • Step no.5: Now tap on hiding from the menu to hide the columns you have selected.

Now that you have learned how to hide a column on excel sheets. Now let’s take a look at how to unhide the column and begin working on it again.

Excel sheets

  • Step no.1: Open Microsoft Excel on your computer.
  • Step no.2: Now open the document you are working on.
  • Step no.3: Highlight the columns on either side of the excel document.
  • Step no.4: Once highlighted, now right click on the columns.
  • Step no.5: Now choose to unhide from the drop-down menu to unhide the hidden columns.

Once you have to unhide the columns you can begin editing and working on them however you like.

Now let’s learn how to unhide all the hidden columns at once.

How to unhide all the hidden columns on excel at once?

  • Step no.1: Open Microsoft Excel on your computer.
  • Step no.2: Now open the document you are working on.
  • Step no.3: Now to unhide the hidden columns go to your Home tab.
  • Step no.4: Now on the right-hand side of the toolbar navigate the format option.
  • Step no.5: Now from there go to the visibility option and there you will find a hide or unhide option.
  • Step no.6: Now click on the hide or unhide option.
  • Step no.7: Now click on unhide option. And this will reveal all your hidden columns at once on your excel sheet.

Conclusion

Since excel allows you to work with a large amounts of data. And it can often get confusing with so many rows and columns. So now you hide certain columns if you are not working on them and unhide them later once you are ready to work on them again.

And in this article, I have given a complete guide on how to do that with my step-by-step guide.



Source link

Leave a Reply

Your email address will not be published.