Home Tutorials 3 Quick Ways to Unhide Columns in Excel

3 Quick Ways to Unhide Columns in Excel

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

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

Open Microsoft Excel

  • Now open the document you are working on.
  • Now select the columns you wish to hide.
  • Once you have selected the column to hide, right-click on the column.

Unhide columns in Excel

  • 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

  • Open Microsoft Excel on your computer.
  • Now open the document you are working on.

Unhide columns in Excel

  • Highlight the columns on either side of the excel document.
  • Once highlighted, now right click on the columns.
  • 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?

Open Microsoft Excel on your computer

  • Now to unhide the hidden columns go to your Home tab.
  • Now on the right-hand side of the toolbar navigate the format option.
  • Now from there go to the visibility option and there you will find a hide or unhide option.

Unhide columns in Excel

  • Now click on the hide or unhide option.
  • 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.

LEAVE A REPLY

Please enter your comment!
Please enter your name here