totn Excel 2010 Basics

MS Excel 2010: Unhide all columns to the right

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

Question: In Microsoft Excel 2010, 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 "16381C". (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