How to hide and unhide columns in Excel

How to hide and unhide columns in Excel

Trending 6 months ago 91

Sometimes hiding definite columns in an Excel spreadsheet tin beryllium helpful: Doing truthful tin marque spreadsheets easier to work oregon you whitethorn person different reasons to fell them. In immoderate case, hiding columns successful Excel is really beauteous casual and lone involves a fewer clicks. And if you determine later, that you privation to spot them again? It's adjacent easier to bring them back.

Either way, we've got your file needs covered with this guide. Keep speechmaking and we'll amusement you however to fell columns and however to unhide columns successful Excel successful a flash.

How to fell columns successful Excel

Hiding columns successful Excel is beauteous straightforward and quick. Here's however to bash it:

Step 1: Select the file you privation to hide. Doing truthful depends connected however galore columns you privation to fell astatine once:

If you lone request to fell 1 column: Just click connected the file heading missive astatine the apical of your desired column.

If you request to fell aggregate columns astatine once: Click connected the file heading missive astatine the apical of immoderate of your desired columns and past property and clasp the CTRL cardinal connected your keyboard arsenic you click connected the file heading letters of the remainder of the columns you privation to hide.

how to unhide columns successful  excel fell  screenshot 1 screenshot

Step 2: Then right-click connected immoderate of the file heading letters of the columns that are selected. (Don't right-click anyplace else, conscionable right-click connected the missive headings. Clicking anyplace other volition effect successful a antithetic paper popping up that won't person the enactment you need.)

how to unhide columns successful  excel fell  screenshot 2 screenshot

Step 3: From the paper that appears, take Hide.

Your selected columns should present beryllium hidden from view.

How to unhide columns successful Excel

If you're acceptable for your hidden columns to reappear successful your spreadsheet, here's however to unhide columns successful Excel:

Step 1: All of the file headings person borderlines that abstracted them from the adjacent column's heading. When a file is hidden, the borderline betwixt the columns that usually neighbour the hidden file becomes thicker and much noticeable. Mouse implicit this borderline until you spot a acceptable of achromatic arrows look that are pointing successful other directions and person a abstraction betwixt them. These arrows should not look connected to each other.

how to unhide columns successful  excel screenshot 1 screenshot

Step 2: Once the arrows described successful the erstwhile measurement appear, treble click that borderline.

Your erstwhile hidden columns should automatically reappear. (If you hid aggregate columns astatine once, they each should reappear astatine the aforesaid time, but if they don't, you should inactive beryllium capable to marque them reappear 1 astatine a clip by double-clicking connected each of their respective borderline lines.)

Step 3: Alternatively, you tin besides right-click that aforesaid borderline (after those arrows appear), and a paper volition popular up. From that menu, you tin take Unhide. Your columns should reappear with this method arsenic well. (If you hid aggregate columns astatine once, they each should reappear astatine the aforesaid time, but if they don't, you should inactive beryllium capable to marque them reappear 1 astatine a clip by right-clicking connected each of their respective borderlines and choosing Unhide.)

how to unhide columns successful  excel screenshot 2 screenshot

Step 4: And if you fell a file and past instantly afterward determine that you privation to unhide it, you tin besides conscionable deed CTRL + Z connected your keyboard and Excel volition automatically undo it and your file volition look again.

Editors' Recommendations