How to Hide or Unhide Columns in MS Excel – Guide
The ability to hide columns in Excel is very useful. It is possible to hide some columns using the “Hide” function or by setting the column width to zero. If you are working with Excel files where some columns are hidden, you might want to know how to unhide columns in Excel to see all the data. Unhide columns in Excel may seem easy until you have several columns hidden, but you only need to show the leftmost one. Choose one of the following tricks to unhide only the first column of the worksheet. Excel is great for sorting large amounts of data, whether alphabetically, adding or merging cells. When organizing this data, it can be helpful to hide columns that you no longer use but don’t want to exclude from your document. Select the two surrounding columns or rows. At the Home tab, in the Cells group, click Format > Hide & Unhide, and choose Unhide Rows or Unhide Columns. Remember that while you can show or hide multiple columns or multiple rows at the same time, you cannot show or hide columns and rows at the same time.
How to hide columns in Microsoft Excel
How to show columns in excel
Final note
I hope you like the guide How to Hide or Unhide Columns in MS Excel. In case if you have any query regards this article you may ask us. Also, please share your love by sharing this article with your friends.
