HomePrivacy PolicyFeedbackLink to usSite Map

MS Excel: Unhide all columns to the right in Excel 2003/XP/2000/97


Also learn how to unhide all columns to the right in Excel 2011 for Mac | Excel 2010 | Excel 2007 | Excel 2003/XP/2000/97.

Question:  In Excel 2003/XP/2000/97, 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.


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.)


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


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


Also learn how to hide a column in Excel 2011 for Mac | Excel 2010 | Excel 2007 | Excel 2003/XP/2000/97.