Spreadsheet Assistant's Fill Assistant menu

Time-Saving fill features for Microsoft Excel.

Download a trial version now!

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

  • Fill cells down or to the right without first selecting the range
  • Add fill buttons directly to Excel's quick access toolbar
  • Use the Fill Cells QAT Menu button for an expandable sub-menu
  • Fill right or down without the screen scrolling
  • Fill Blanks with the Entry Above or Below
  • Make imported data with blanks usable for filtering and pivot tables

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

Fill Assistants menu
Fill Assistants menu
Fill Cells QAT sub-menu
Fill Cells QAT sub-menu

The first four features on the Fill Assistants menu let you quickly and easily fill cells down or to the right without first having to select the range to fill. These buttons may be added directly to Excel's quick access toolbar, or you may add instead the Fill Cells QAT Menu button, which expands into a sub-menu.

These are buttons we use all the time to fill right or down without the screen scrolling.

The Fill Blanks with Entry Above or Below feature is one that we have found very useful. Quite often we import data with blanks in the data to make it easier to read. Unfortunately, such blanks make the data unusable for filtering or with pivot tables. With this feature, one just selects the range with the blanks and cell entries and tells it to fill the blank cells!

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

Customers who viewed this also viewed