Our Service

The Best Shortcut for Hiding Columns in Excel

If you’re like most people, you probably use Excel to keep track of a lot of different things. Whether it’s a personal budget, a list of contacts, or something else entirely, Excel is a great tool for organizing and keeping track of data. But what happens when you need to hide some of that data? Maybe you don’t want everyone to see your budget, or maybe you want to keep certain columns hidden so you can focus on other things. Whatever the reason, hiding columns in Excel is a pretty simple process.

The first thing you need to do is select the columns you want to hide. You can do this by clicking on the column header of the first column you want to hide and then dragging your mouse over to the header of the last column you want to hide. Once you’ve selected the columns you want to hide, right-click on any of the selected headers and choose “Hide” from the menu that appears.

That’s all there is to it! The columns you selected will now be hidden from view. If you ever need to unhide them, simply right-click on any header and choose “Unhide” from the menu. You can also unhide columns by going to the “Home” tab and clicking on the “Format” drop-down menu. From there, select “Unhide Columns” or “Unhide Rows” (depending on which you hid) and all of your hidden columns will be back.

Hiding columns is a great way to keep your Excel sheets tidy and organized. It’s also a great way to make sure that only the people who need to see certain data have access to it. So next time you need to hide some columns, remember this shortcut and you’ll be done in no time!

Excel is a powerful tool that can help you manage and analyze data with ease. However, with so many features and functions, it can be overwhelming to navigate. That’s why shortcuts are essential to help you work more efficiently. One of the most useful shortcuts in Excel is hiding columns. In this article, we’ll explore the best shortcut for hiding columns in Excel.

Why Hide Columns in Excel?

Before we dive into the shortcut, let’s first discuss why you might want to hide columns in Excel. There are several reasons why you might want to do this:

  • To focus on specific data: Hiding columns can help you focus on the data that’s most important to you. By hiding irrelevant columns, you can reduce visual clutter and make it easier to analyze the data you need.
  • To protect sensitive information: If you’re working with sensitive data, you may want to hide certain columns to prevent unauthorized access.
  • To make your spreadsheet more presentable: If you’re sharing your spreadsheet with others, you may want to hide certain columns to make it look more professional.

The Best Shortcut for Hiding Columns in Excel

Now that we’ve covered why you might want to hide columns in Excel, let’s talk about the best shortcut for doing so. The easiest way to hide a column in Excel is to use the keyboard shortcut:

Ctrl + 0

Simply select the column or columns you want to hide, and then press Ctrl + 0. The selected columns will disappear from view, but the data in those columns will still be present in the spreadsheet. To unhide the columns, simply select the columns on either side of the hidden columns, and then press Ctrl + Shift + 0.

Alternatively, you can also hide columns using the ribbon. To do this, select the column or columns you want to hide, and then go to the Home tab. In the Cells group, click on the Format dropdown, and then select Hide & Unhide > Hide Columns.


Hiding columns in Excel is a simple but powerful way to manage your data more effectively. Whether you’re trying to focus on specific data, protect sensitive information, or make your spreadsheet more presentable, hiding columns can help. And with the Ctrl + 0 shortcut, it’s never been easier to do so.

So next time you’re working in Excel, remember this handy shortcut and start hiding those columns!


Did you find this article useful?

Share it with your friends or colleagues

About Aepoch Advisors

We are a boutique accounting and consulting firm servicing international businesses operating in China. We offers book keeping and business advisory service. We also help our clients select and implement SAAS business applications
Cloud technology significantly reduces cost foreign companies traditionally spent on tax compliance and ERP systems. Our cloud professionals can help with streamlining your management and controling structure, as well as advising you on how to reduce risks and maximize profits with software purposely built for Chinese business. Contact us today to learn more about our services.