totn Excel 2016 Basics

MS Excel 2016: Unhide all columns to the right

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

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

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

Microsoft Excel

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

Microsoft Excel

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

Microsoft Excel

Now all of the columns to the right of column C should be visible again.

Microsoft Excel