Saturday, July 30, 2016

Unhide all columns to the right

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

No comments:

Post a Comment