How to Unhide Columns in Excel 2013

Excel 2013 is an infinitely useful program with assorted tools and functions that make it ideal for a number of different scenarios. But one problem that you might encounter is simply that your worksheet has too much data, and that important information is in cells that are off the screen. One solution to this problem is to hide columns of your worksheet that might contain less important information. Hiding is a preferable choice to deletion, because the hidden columns are still in the worksheet, allowing them to be used in formulas without disrupting the formula output cells. But the process for unhiding columns in Excel 2013 is not immediately obvious, so continue reading below to learn how to display columns that have been hidden in Excel 2013.

 

Show Hidden Columns in Excel 2013

 

If you receive an Excel worksheet from someone else that contains hidden columns, it is not always immediately obvious. There are, however, two ways that you can find hidden columns. The first is that the columns that are displayed will not be in alphabetical order. Second, the column border for a visible column will look different when there is a hidden column on either side of it. You can see an example of both of these signals in the image below.

Example of hidden columns

Example of hidden columns

 

So now that you know how to identify when columns have been hidden, you can use the steps below to unhide those columns in Excel 2013.

 

Step 1: Open the workbook containing the columns that you want to unhide.

 

Step 2: Click the top-left corner of the worksheet to select the entire sheet. Note that you are clicking the space between the letter “A” and the number “1” that is identified in the image below.

Select the entire Excel 2013 worksheet

Select the entire Excel 2013 worksheet

 

**If you only want to unhide certain columns, then you can select the columns on either side of the hidden columns. For example, columns C, D and E are hidden in the image below. I want to unhide only those columns, so I select columns B and F instead of the entire worksheet.

Select only some columns

Select only some columns

 

 

Step 3: Right-click on one of the highlighted columns, then click the Unhide option.

Right-click, then select the "Unhide" option

Right-click, then select the “Unhide” option

 

 

If you have been thinking about getting additional copies of Office 2013 for home or work, you should consider the subscription option. It has a lower up-front cost, allows multiple computer installations that can be managed, plus it gives you access to the full Office suite of programs as opposed to only Word, Excel and PowerPoint.

 

If you are looking for a good way to simplify the process of viewing and summarizing your data, you should consider using Pivot Tables. They are very helpful for many different situations and can replace a lot of complicated formulas and manual mathematical operations.