Skip to main content

How to hide and unhide columns in Excel

tips to make email more productive less burdensome on computer
Image used with permission by copyright holder

Sometimes hiding certain columns in an Excel spreadsheet can be helpful: Doing so can make spreadsheets easier to read or you may have other reasons to hide them. In any case, hiding columns in Excel is actually pretty easy and only involves a few clicks. And if you decide later, that you want to see them again? It's even easier to bring them back.

Either way, we've got your column needs covered with this guide. Keep reading and we'll show you how to hide columns and how to unhide columns in Excel in a flash.

Recommended Videos

Difficulty

Easy

Duration

5 minutes

What You Need

  • Microsoft Excel

  • A PC

How to hide columns in Excel

Hiding columns in Excel is pretty straightforward and quick. Here's how to do it:

Step 1: Select the column you want to hide. Doing so depends on how many columns you want to hide at once:

If you only need to hide one column: Just click on the column heading letter at the top of your desired column.

If you need to hide multiple columns at once: Click on the column heading letter at the top of any of your desired columns and then press and hold the CTRL key on your keyboard as you click on the column heading letters of the rest of the columns you want to hide.

how to unhide columns in excel hide screenshot 1
screenshot

Step 2: Then right-click on any of the column heading letters of the columns that are selected. (Don't right-click anywhere else, just right-click on the letter headings. Clicking anywhere else will result in a different menu popping up that won't have the option you need.)

how to unhide columns in excel hide screenshot 2
screenshot

Step 3: From the menu that appears, choose Hide.

Your selected columns should now be hidden from view.

How to unhide columns in Excel

If you're ready for your hidden columns to reappear in your spreadsheet, here's how to unhide columns in Excel:

Step 1: All of the column headings have borderlines that separate them from the next column's heading. When a column is hidden, the borderline between the columns that normally neighbor the hidden column becomes thicker and more noticeable. Mouse over this borderline until you see a set of black arrows appear that are pointing in opposite directions and have a space between them. These arrows should not look connected to each other.

how to unhide columns in excel screenshot 1
screenshot

Step 2: Once the arrows described in the previous step appear, double click that borderline.

Your once hidden columns should automatically reappear. (If you hid multiple columns at once, they all should reappear at the same time, but if they don't, you should still be able to make them reappear one at a time by double-clicking on each of their respective border lines.)

Step 3: Alternatively, you can also right-click that same borderline (after those arrows appear), and a menu will pop up. From that menu, you can choose Unhide. Your columns should reappear with this method as well. (If you hid multiple columns at once, they all should reappear at the same time, but if they don't, you should still be able to make them reappear one at a time by right-clicking on each of their respective borderlines and choosing Unhide.)

how to unhide columns in excel screenshot 2
screenshot

Step 4: And if you hide a column and then immediately afterward decide that you want to unhide it, you can also just hit CTRL + Z on your keyboard and Excel will automatically undo it and your column will appear again.

Anita George
Former Digital Trends Contributor
Anita George has been writing for Digital Trends' Computing section since 2018. So for almost six years, Anita has written…
Best Microsoft Office deals: Get Word, PowerPoint, and Excel for free
Students using Microsoft Office software on their laptops outside.

There is almost always going to be a discussion between Microsoft vs. Google and which one has the best business and productivity tools, but Microsoft has certainly been around longer and ingrained itself in a lot of businesses, making it a standard. As such, you may want to grab yourself a copy or subscription, although Microsoft Office can get quite pricey, and while there is a free trial of Microsoft Word, it's not really the same thing. Luckily, there are a few Microsoft Office deals with grabbing, which is why we've gone out and collected some of our favorites for you below.
Best Microsoft Office deals
Microsoft Office is a pay once, receive once service. You don't have to pay recurring monthly fees to use it, but the software also never updates. For what it's worth, the Microsoft Office packages are labelled "2021", so they're all fairly recent but also ripe for a good deal. With the exception of AI integrations, not much has really changed in the past couple of years when it comes to your basic document creation and these programs should continue to be effective for years to come. Depending on what package you get, you'll get access to different apps, based on the needs of the target audience. For example, Microsoft Office Home & Student 2021 keeps it lean and cool and with Microsoft Word, Microsoft Excel, and Microsoft PowerPoint being the only apps included.

Here are our favorite deals for the classic Microsoft Office experience:

Read more
How to change margins in Google Docs
Laptop Working from Home

When you create a document in Google Docs, you may need to adjust the space between the edge of the page and the content --- the margins. For instance, many professors have requirements for the margin sizes you must use for college papers.

You can easily change the left, right, top, and bottom margins in Google Docs and have a few different ways to do it.

Read more
How to alphabetize data in an Excel spreadsheet
A Microsoft Excel icon in the dock on a Macbook.

Manually organizing data in Microsoft Excel is a real pain. That's why we don't recommend doing it. One simple task, learning how to alphabetize in Excel, is not necessarily as intuitive as we would like. Here's how to get things sorted in a logical, alphabetical order.

Read more