Row & Column Assistants Menu

The following is the Row and Column Assistants menu that appears when you click on the Row and Column Assistants button. Any of the features can be added to Excel’s quick access toolbar for instant use any time.

The Format Row and Column Assistants make hiding and un-hiding rows very easy — especially un-hiding the next row or column. We often use the Conditional Select Assistants to select the cells in a column we want to hide, then come to this menu and choose Hide Row if Cell is Selected to hide them. For example, on a worksheet of accounts and their values, we will select all the low-value accounts and hide their rows so we just see the high-value accounts.