Spreadsheet Assistant's Row & Column Assistants Menu

Time saving row and column commands for Microsoft Excel.

Download a trial version now!

The following are just a few of the time-saving row and column features added by the Spreadsheet Assistant that make Microsoft Excel easier to use:

  • Hide and un-hide rows and columns with ease
  • Quickly un-hide the next row or column
  • Hide rows when a cell is selected
  • Works hand-in-hand with the Conditional Select Assistants
  • Add any feature to Excel's quick access toolbar for instant use

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.

Row and Column Assistants menu
The Row & Column Assistants menu

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.

Return to the Spreadsheet Assistant overview to explore all the other assistant menus.

Customers who viewed this also viewed