Hiding columns in Excel is a great way to declutter a worksheet, or to make sensitive data more secure. But it can be a little tricky to know how to hide columns in Excel using the various shortcut methods.
In this ultimate shortcut guide, we'll show you how to hide columns in Excel using the following methods:
Let's get started!
If you want to hide columns in Excel using the Ribbon, first select the columns that you want to hide. Then, click the Home tab on the Excel Ribbon, and click the Hide Columns button, as shown in the image below.
That's all there is to it! The selected columns will be hidden from view.
If you prefer using the right-click context menu to hide columns in Excel, first select the columns that you want to hide. Then, right-click on any of the selected column headers, and click the Hide option, as shown in the image below.
The selected columns will be hidden from view.
If you want to quickly hide columns in Excel using a keyboard shortcut, first select the columns that you want to hide. Then, press the Ctrl+- keys on your keyboard (that's the Ctrl key and the minus sign key).
You'll see a dialog box appear, asking you which columns you want to hide. Select the Entire column option, and click the OK button, as shown in the image below.
The selected columns will be hidden from view.
If you want to quickly unhide columns in Excel, there are a couple of different methods you can use.
If you know which column you want to unhide, you can simply select the column to the right of the hidden column, and then press the Ctrl+Shift++ keys on your keyboard (that's the Ctrl key, the Shift key, and the plus sign key).
Or, you can click the Home tab on the Excel Ribbon, and click the Unhide Columns button.
You'll see a dialog box appear, asking you which columns you want to unhide. Select the columns you want to unhide, and click the OK button.
That's all there is to it! These are the three methods you can use to hide columns in Excel.