May 26 2020 10:33 PM - edited May 26 2020 10:36 PM
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.
May 26 2020 11:09 PM
@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.
May 26 2020 11:34 PM