how to hide and unhide a column in excel

Now, we will drag the mouse pointer towards the left until we see the border lose its colors (becomes white).Again, we will highlight column B using the header.As we move the pointer to the right, Column A will become visible.įigure 11- Unhide option for expanding column A How to Unhide Column A by Selecting it We will drag the mouse pointer to the right.We will place the cursor to the left until we see the double-sided arrow.We will highlight column B by clicking on the header.We can unhide the first column by using the second column, which in our example is Column B. We will select Cells group in the Home tab, click Format, select “Hide & Unhide” and lastly select “unhide” as in Figure 5įigure 9 – Column A Un-hidden How to Unhide the First Column by Expanding the Second Column to the Right.Once the “Go-To” dialog box opens, we enter A3 in the Reference field and select “OK”.We select “Find & Select” in the Home tab and click on “Go to”.We can unhide the first column of our worksheet using the Go-To option even as there is nothing before the first column that can be selected. We will select, “hide or unhide” and lastly “ unhide columns ”.įigure 6 – Column B and C unhidden How to use the Go-To Option to Unhide the First Column

We will click the home tab, select “Cells group” and then click format.We will unhide Column B (Product) and C (Rep).When we have multiple columns but wish to be specific, we can show certain hidden columns. Once selected, all columns hidden in our worksheet will be displayed.įigure 3 – How to Use the Unhide Function How to Show Specific Hidden Columns.We will right-click on the selection and choose the Unhide option.This will instantly select our worksheet.įigure 2 – Select the triangle located at the upper-left segment of the table. We will click on the small triangle found at the upper-left corner of our table adjacent to Column A.When we have one or a group of columns in a table, the Unhide option makes it easy to show all columns in our table at once. By putting our data in a table and using some simple steps, we can work ourselves through several ways to accomplish this.įigure 1 – How to unhide columns How to Unhide All Columns How to Hide and Unhide Columns and Rows in Google Sheets and ExcelĮxcel does not have any formula for hiding or unhiding rows and columns.

How to hide and unhide a column in excel