totn Excel 2007 Basics

MS Excel 2007: Unhide all columns to the right

This Excel tutorial explains how to unhide all columns to the right of a specific column in Excel 2007 (with screenshots and step-by-step instructions).

Question: In Microsoft Excel 2007, if ALL columns to the right of column D are hidden, how do you "unhide" columns E, F, etc.?

Answer: In the spreadsheet below, all columns to the right of column D are hidden.

Microsoft Excel

To unhide these columns, click on the column D heading. While holding down the left mouse button, drag your cursor to the right until a bubble window appears displaying "253C". (The text in the bubble window may vary based on your version of Excel.)

Microsoft Excel

Now, over the column D heading, right click and select Unhide from the popup menu.

Microsoft Excel

Now all of the columns to the right of column D should appear.

Microsoft Excel