Unhide All Hidden Columns at One Time

Copper Contributor

I used to be able to select the whole spreadsheet by clicking on the upper left corner and choosing "Unhide" from the pop-up menu in order to unhide all hidden columns at the same time.  This was in Excel 10.  However, now (using the Excel in Office 365) the menu doesn't include "Hide" or "Unhide" as a choice.  What happened??  I hide many columns often and it was very convenient to unhide them all at one time.  Where did that function go?  Thanks.

2 Replies

@spbocgirl Can't tell what happened to the pop-up. Never used it myself. In Office 365, select all cells and the navigate to Format Cells in the Home ribbon, as shown in the picture below. Or use the keyboard shortcuts indicated with the menu options.

Screenshot 2020-05-27 at 08.02.12.png

Thanks Riny. Don't know why it's no longer on the pop-up. I guess MS wants me
to use more steps to perform a simple task. I appreciate your help.