

Drag your mouse pointer to the left until you see the border change its color.Now just drag the mouse pointer to the right to expand the hidden column A.Move the mouse cursor to the left until you see the double-sided arrow.Click on the header for column B to select it.
#HOW DO I HIDE COLUMNS IN EXCEL 2007 HOW TO#
How to unhide the first column by expanding it
#HOW DO I HIDE COLUMNS IN EXCEL 2007 FREE#
If you don't know VBA too well, feel free to explore its possibilities by reading our article How to insert and run macros. Click on a small triangle in the upper-left corner of your table to select the entire worksheet.Whether you have one or several hidden columns in your table, you can easily display them all at once using the Excel Unhide option. Show all hidden columns in Excel via Go To Special.Unhide the first column by expanding it.Unhide all columns automatically with VBA.In this post I'll share how to show hidden columns using the standard Excel Unhide option, a macro, the Go To Special functionality and Document Inspector. If you happen to work with Excel files where some columns are hidden, you may want to know how to unhide columns in Excel to view all data. It's possible to conceal some columns by using the Hide feature or by setting the column width to zero. The possibility to hide columns in Excel is really helpful. It will teach you to show all hidden columns or just the ones you select, how to unhide first column, and more. With the entire sheet selected, it doesn't matter where in the headings you right-click.From this article, you'll learn how to unhide columns in Excel 2016 - 2007. You can then right-click on row and column headings and select Unhide for each.

If you'd like to unhide all rows and columns in a worksheet, first, select the entire worksheet. Then, right-click in the row selection and choose Unhide from the menu. Notice the gap in row numbers when rows are hidden.Īs with columns, you need to select rows on both sides of the rows you want to unhide. Or, you can use the right-click menu, which is faster. You can hide and unhide rows using Hide Rows and Unhide Rows in the Format menu. Rows work in much the same way as columns.

Then, right-click and choose Unhide from the menu. To unhide the columns, make sure to select columns on both sides of the hidden columns. Select one or more columns, right-click in the selection, and choose Hide from the menu. You can also hide and unhide columns using the right-click menu. Then, choose Unhide Columns from the Format menu. To unhide a column, you need to select columns on both sides of the hidden column. Notice that when a column is hidden, its heading is also hidden, so that there is a gap in the column letters that run across the top of the worksheet. One way to hide a column is to choose Hide Columns from the Format menu on the home ribbon. Hiding rows or columns is a good way to visually simplify a worksheet without removing important information. In this lesson, we'll look at how to hide and unhide columns and rows.
