How to hide and unhide columns in Excel

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.

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.)

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.

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.)

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.

Editors' Recommendations

Anita has been a technology reporter since 2013 and currently writes for the Computing section at Digital Trends. She began…
How to get Android apps on a Chromebook

Over the last few years, Android apps have been added to more and more Chromebook models. A brilliant expansion of the overall user experience, Google went ahead and integrated the Play Store into most Chromebooks made after 2019. This is the most convenient way to download an Android app or two, but if you own an older Chromebook, the machine may not have native support for downloading and installing applets.

To confirm this, we recommend referencing this extensive Android app support list from The Chromium Projects.

Read more
How to find your Windows 11 product key

Your Windows 11 product key is an important piece of information for your PC. One can think of this long batch of characters as the golden ticket to your Windows 11 experience. And not only does a product key give you access to the full breadth of your PC’s features, but it’s also a digital gatekeeper that won’t let you in if you didn’t properly pay for Windows 11.

Read more
How to insert a checkbox in Word on Windows and Mac

Whether you’re outlining a recipe or putting together a daily to-do list, Microsoft Word is a great tool for keeping all your ideas and information organized. Beyond its word processing capabilities, you’ll even be able to create electronic checkboxes that you can tick and untick. It’s really easy to do, and we put together this step-by-step guide to teach you how.

Read more