How to hide and show columns in Excel

0
69

Sometimes certain columns are hidden in an Excel spreadsheet can be useful: it can make it easier to read spreadsheets or you may have other reasons to hide them. Either way, hiding the columns in Excel is actually quite simple and involves just a few clicks. And if you decide later, what do you want to see them again? They are even easier to return.

Either way, in this guide we’ll look at your column needs. Keep reading and we will show you how to hide columns and how to instantly show columns in Excel.

How to hide columns in Excel

Hiding columns in Excel quite simple and fast. Here’s how to do it:

Step 1: Select the column you want to hide. It depends on how many columns you want to hide at one time:

If you only need to hide one column: just click on the column header letter at the top of the desired column.

If you need to hide multiple columns at once: click on the column header letter at the top of any of the desired columns, then click and hold CTRL a key on the keyboard when you click the title letters of the remaining columns that you want to hide.

how to show columns in excel, hide screenshot 1

screenshot

Step 2: Then right-click any of the column header letters that are selected. (Don’t right-click anywhere else, just right-click the letter headings. Clicking somewhere else will bring up another menu where you won’t need the option.)

how to show columns in excel, hide screenshot 2

screenshot

Step 3: In the menu that appears, select Hide.

The columns you selected should now be hidden from view.

How to show columns in Excel

If you’re ready for the hidden columns to reappear in your spreadsheet, here’s how to show the columns in Excel:

Step 1: All column headers have boundaries separating them from the heading of the next column. When a column is hidden, the boundary between the columns, which are usually adjacent to the hidden column, becomes thicker and more noticeable. Hover your mouse over this border until you see a set of black arrows pointing in opposite directions and have space between them. These arrows should not look connected to each other.

how to show columns in excel screenshot 1

screenshot

Step 2: Once the arrows described in the previous step appear, double-click this border.

Your once hidden columns should automatically reappear. (If you’ve hidden multiple columns at once, they should all reappear at the same time, but if they don’t, you’ll still be able to make them appear one at a time by double-clicking each of the appropriate borders.)

Step 3: Alternatively, you can also right-click the same border (after these arrows appear), and a menu will appear. From this menu you can choose Show. Your columns should also appear with this method. (If you have hidden multiple columns at once, they should all reappear at the same time, but if they don’t, you’ll still be able to make them appear one at a time by right-clicking on each of the appropriate borders and selecting Show.)

How to show columns in the screenshot excel 2

screenshot

Step 4: And if you hide a column and immediately decide that you want to show it, you can also just click CTRL + Z on the keyboard, and Excel will automatically undo this and your column will reappear.

Editorial recommendations




How to hide and show columns in Excel

Source link How to hide and show columns in Excel