How to Unhide Columns in Excel?

As you work with large spreadsheets, you may need to hide certain columns temporarily to focus on specific information or create a cleaner view of your data. While hiding columns is handy, knowing how to unhide them when you need to access or work with that hidden information again is equally important. The blog will walk you through the simple and essential steps to unhide columns in Excel.

While working with spreadsheets, people often hide some information. The reason behind this could be anything, from protecting sensitive data to simplifying the worksheet. Note that hidden cells may be present in the worksheet but are not visible. This means that you can still use them in formulas and calculations. However, knowing hidden cells when working with a worksheet is essential, as you may need to unhide them to view or modify the data. In this blog, we will cover how to unhide columns in Excel. There are two ways to unhide columns in Excel:

Must Read – What is MS Excel?

Method 1:

1. Open your spreadsheet from where you need to access hidden column data.

2. Select the location between the columns to the left and right of the hidden columns. 

3. When the cursor is between the letters of the columns adjacent to the hidden columns, it will turn into two parallel lines with one horizontal arrow and one vertical line.

• You can identify a hidden column because two lines between the column letters exist.
• The cursor must be to the right of the two lines for this method to work. Placing the cursor to the left will increase the size of the adjacent column.

4. Click the cursor. You can see that the Hidden columns are unhidden now.

If you are unsure which columns are hidden, you can use the Unhide All command to unhide all hidden columns. To do this, click the Home tab of the ribbon and then click the Show button. In the Show drop-down menu, select Unhide All.

Must Explore – MS Excel Courses

Method 2

Step 1. Select the neighboring columns of the hidden cells.

Step 2. Click Home > Format > Hide and Unhide to show the hidden column or row.

You can see that the hidden columns are now visible.

Knowing how to unhide columns in Excel is a fundamental skill that can significantly improve your efficiency when working with spreadsheets. Excel’s ability to hide columns allows for better data organization and presentation. Following the straightforward steps outlined in this guide, you can confidently unhide columns whenever necessary, ensuring that your Excel tasks are carried out seamlessly.

Read More in MS Excel