As Seen on TechCrunch: Finofo Raises $1.65M CAD!

Excel Guide

How to Unhide All Columns in Excel: A Step-by-Step Guide

Sometimes in Excel, columns may be hidden either accidentally or intentionally. If you find yourself needing to unhide all columns in Excel, follow this step-by-step guide.

How to Unhide All Columns:

  1. Select the First Cell:
  2. Click on the first cell in your data set. This ensures that the entire worksheet is selected.
  3. Access the Format Menu:
  4. Go to the "Home" tab on the Excel ribbon.
  5. In the "Cells" group, click on "Format."
  6. Adjust Column Width:
  7. Under "Format Cells," find and click the drop-down arrow next to "Column Width."
  8. AutoFit Selection:
  9. Choose "AutoFit Selection" from the options.
  10. View Unhidden Columns:
  11. Your columns should now be unhidden, and you should be able to see all your data.

Why Columns Become Hidden:

Columns may become hidden due to various reasons:

  • Accidental hiding.
  • Large data set exceeding the default view.
  • Opening a workbook created by someone else where columns were intentionally hidden.

How to Avoid Accidentally Hiding Columns:

To prevent accidental hiding of columns, follow these steps:

  1. On the "Home" tab, in the "Cells" group, click "Format."
  2. Under "Format Cells," click the drop-down arrow next to "Column Width."
  3. Choose "AutoFit Selection."


Unhiding columns in Excel is a simple process, and it's crucial to know, especially when working with large datasets. By following the steps outlined in this guide, you can quickly unhide all columns and ensure that your data is visible and accessible. If you have any further questions or concerns, feel free to ask!