OzGrid.comMicrosoft Excel Templates, Training and Add-ins, Business Software and more!

The Spreadsheet Assistant Add-in for Microsoft Excel

The Spreadsheet Assistant® is a great time saver for anyone who uses Microsoft Excel.  Get the Spreadsheet Assistant® and Start saving time right away

GO TO Excel Add-ins, Training and Templates ... Business and Charting Software ...
Excel Templates Business Software Categories
Microsoft Excel Add-ins Financial Calculators
Downloadable Excel and Excel VBA Training Charting Tools and Software
Bundled Add-ins and Software Savings Trading Software & Add-ins
Free Excel and VBA Support Financial Add-ins and Software
Excel and VBA books Construction and Estimating Excel Add-ins
Excel Password Recovery Corrupt Excel, Word, Access File Recovery
Search All Excel Add-ins and Software Convert Excel to text, html, csv, sql, pfd etc

Read Regnow (our order processor) Privacy Statement! RegNow strives to ensure that you receive quality service, and that also means that the information you provide us is seen only by a select few here at RegNow.

The Spreadsheet Assistant $39.95

Add to Cart In next screen click "Add to Basket" then Close the next Window via the X, Not Continue Shopping. Note that clicking "Continue Shopping" will take you to our Software Category page

Please note, order page may default to your own countries currency

HUGE collection of Excel Add-ins and Business Software...Click Here

Order online from our secure service - Get delivery in minutes!
Order Risk Free - Money back guarantee if not satisfied
FREE CD - just e-mail your order confirmation to cds@add-ins.com - no shipping or handling!

Buy on its own, or part of the Analysis Collection ...See features   and Save

Or as part of the Excel Toolkit   and Save!The Spreadsheet Assistant® is a great time saver for anyone who uses Microsoft Excel.  Get the Spreadsheet Assistant® and Start saving time right away

Screen Shots

Customer Testimonials

The following is a list of all the features that the Spreadsheet Assistant adds to Microsoft Excel.  All are accessible from the Excel menus.  And all can be easily assigned to a button for instant use. The Spreadsheet Assistant adds over 200 features to Microsoft Excel.

The Spreadsheet Assistant Feature List

********* FILL AND SELECT ASSISTANTS *********
Select Cells to the Right of the Selected Range
Select Cells Below the Selected Range
Select ALL Cells to the Right of the Selected Range
Select ALL Cells Below the Selected Range

Fill Highlighted Cells to the Right
Fill Highlighted Cells Down
Fill Highlighted Cells ALL the Way to the Right
Fill Highlighted Cells ALL the Way Down

Set the Target Column/Row...

Select to the Target Column
Select to the Target Row
Fill to the Target Column
Fill to the Target Row

Find Next Different Entry Up
Find Next Different Entry Down
Select Down Until Entry Changes

Select Blank Cells Only
Select Cells with Entries
Select Cells with Numbers Only
Select Cells with Formulas Only
Select Text Cells Only
Select Cells Based on Format
Select Error Cells
Select Cells with #REF!
Select Unprotected (Unlocked) Cells
Select Protected (Locked) Cells
Select Only Visible Cells
Select Cells Using An IF Test

Find and Select Duplicates

Find the Longest Text Entry

Select Every Other "N" Rows
Select Every Other "N" Columns
Select the Rows of All Selected Cells
Select the Columns of All Selected Cells

Select the Used Range

*** The following are great to assigned to a button
Next Blank Cell Down
Next Blank Cell To The Right
Next Entry Cell Down
Next Entry Cell To The Right

********* EDIT ASSISTANTS*********
Copy Sum of Selected Cells to Clipboard
Copy Average of Selected Cells to Clipboard

Modify Cell Entries
Indent Or Truncate Text...

Exact Formula Copy..
Fix (text flow) A Paragraph

** Copy From
** Cut From

The following three work if assigned to a button
** Paste Just Formulas
** Paste All But Borders
** Paste Values and Transpose

Capitalize All Letters
Convert All Letters to Lower Case
Capitalize the First Letter of All Words
Capitalize the First Letter of the First Word Only

Remove Blank Rows...
Remove UnNeeded Blank Rows
Insert Blank Rows Every X Rows...
Insert Blank Rows If Cells Are Different...

Insert a Big Dot
Insert a Thick Dash
Insert a Thick Underline
Insert a Long Thick Underline

Trim Excess Blanks From Cell Entries
Trims Blanks from Left Side Only
Trim Blanks from Right Side Only
Trim Blanks from Left And Right Sides
Remove All Blanks

Fill Blanks With the Contents of the Cell Above
Blank Entries If the Same As the Cell Above

Blank Cells Based On A Reference Column...
Blank Cells Based On A Reference Row...

Quick Number Selected Cells
Transpose Rows and Columns Without Changing Cell References...

Clear Just Cell Formats
Clear All - cell formats, contents, and notes

Flip AutoComplete Off And On

********* FORMULA ASSISTANTS *********
Perform Any Math Action (Add, Subtract, Multiply, Divide)...

Convert Text Numbers to Numbers
Modify Formulas to Hide Error Values
Modify Large Percents to <-100%, >100%
Insert Formulas to Round Values

Convert Formulas to Absolute References
Convert Formulas to Relative References
Convert To Absolute Row, Relative Column Refs
Convert to Absolute Column, Relative Rows Refs

Convert Trailing Negatives to Leading Negatives...

Insert Sum Across Sheets Formula

********* FORMAT ASSISTANTS *********
Center (Not Merge) Across Selection
Turn Word Wrap On
Turn Word Wrap Off

Protect (Lock) Selected Cells
UnProtect (UnLock) Selected Cells

Change settings on the next 8 quick format features

Format: 0
Format: 0.0
Format: 0.00
Format: 0.000

Format: 0%
Format: 0.0%

Format: $0
Format: $0.00

Custom Align Cell Entries

Unhide the Row Below the Cell Pointer
Unhide the Column to the Right of the Cell Pointer

Hide The Entire Row if Cell is Selected
Hide The Entire Column If Cell is Selected

Hide Row If Entry In Cell
Hide Row If Cell Empty

Copy Row Heights...
Copy Column Widths...

Dot Borders
Color cells when Value Changes
Color Alternate Rows

********* RELOCATION ASSISTANTS *********
Set All Selected Sheets to the Same Upper Left Cell and Zoom...

Relocate Current Cell to the Upper Left
Relocate Using Last Relocate

Store Current Cell Location For Easy Return
Return to Stored Location - From Any Spreadsheet
Store Second Cell Location For Easy Return
Return to Second Location - From Any Spreadsheet

********* PIVOT TABLE/DATA ASSISTANTS *********
Group Multiple Row Selections

Set Print Area and Titles And Preview A Pivot Table
Expand the Pivot Table Range...
Freeze Panes for a Pivot Table
Refresh All Pivot Tables In A Workbook
Insert A Page Break And Underline In a Pivot Table
Format (Bold and Incr'd Row Height) Pivot Table Total Rows

********* PRINT ASSISTANTS *********
Export Selected Sheets' Reports to an XLS File
Export A Range or Embedded Graph to a Picture File

Print Just the Page containing the Active Cell
Print Multiple Selections on One Page
Print Current Selection and Then Restore the Print Area

Add or Subtract Rows or Columns to the Print Area...
Display Bottom of Print Area (F8 then allows extension)

Copy Print Settings...

Set the Print Area
Set Print Titles (First select rows, hold ctrl key down, select columns)
Update Footer Date And Time On Selected Sheets

Remove Print Area, Titles, Page Breaks...
Insert page breaks every N rows
Insert Multiple Page Breaks based on cell entries

********* SHEET ASSISTANTS *********
Insert Multiple Worksheets
Add Sheets Based Cell Entries
Duplicate (Copy) Active/Selected Sheets

Protect or UnProtect Multiple Sheets..

Extract Multi-Sheet Values..

Hide/Show Grid Lines
Hide/Show Formulas
Hide/Show Zeros
Freeze/Unfreeze Scroll Area

Select Multiple Sheets At One Time....
Hide/Unhide Multiple Sheets At One Time...

Delete Empty (Blank) Sheets

Initialize Selected Sheets...

Select the Sheet to the Left
Select the Sheet to the Right

List All Sheets In The Active Workbook

********* WINDOW ASSISTANTS *********
Display Just Selected Windows

Hide / Unhide Windows
Minimize / Restore Windows
Re-size Windows
Duplicate A Window

Freeze Panes on Multiple Sheets

Zoom To The Selection
Zoom In +5% increments
Zoom In -5% increments
Zoom to 85%
Set Zoom Back to Normal (100%)

********* FILE ASSISTANTS *********
Favorite Directories List...
Bookmark Locations for Quick Access

Add File To Recently Opened List
Create Hyperlink to Open File
Save As to File's Directory
Save Multiple Files At One Time...
Close Multiple Files At One Time...

Select the Previous File
Select the Next File

Delete The Active File...
Rename The Active File...
Create a Backup of the Active File

Toggle File Read Write Mode
Return The Path and Size of The Active File...

Create an ASCII or CSV File...

Windows Explorer

********* OTHER ASSISTANTS *********
Multi-Cell Precedent Tracer
Multi-Cell Dependent Tracer
Clear Tracer Arrows

Insert a Sticky Note...
Draw a Circle Around Selected Cells

Insert Months or Years...
Calendar

Add or Remove Range Names
Create Local Range Names On Selected Sheets...

Compare Two Ranges...
Display Range Information - Sum, Average, etc

Hide Or Show Comments

Flip Calculation between Manual and Automatic

Data Correlation

Analyze Links of All Open Workbooks
Workbook Statistics

Calculator
Control Panel
Notepad
Windows Write/Wordpad

Quick Access to the Windows Desktop
Quick Access To DOS

Show or Hide The Spreadsheet Assistant's Toolbars...

Print the Spreadsheet Assistant's Features List
About The Spreadsheet Assistant
The Spreadsheet Assistant Welcome Message
The Spreadsheet Assistant File Location

The Spreadsheet Assistant's top ten time saving features

  1. Selecting or filling ranges without the screen moving!
    Just highlight the initial cells in the range, right click on the range and pick the select or fill feature that you want to run! The screen does not move when you select or fill a range! Eliminate the wild screen scrolling you used to do (unless you enjoy it).
  2. Perform any math action on a range of cells!
    Highlight a range of cells, select the Any Math Action feature and enter the action (/ 100, * 1000, ...) you want to take. Bingo! The cells are changed instantly. Now think ;about how long the same change would have taken you to do manually.
  3. Insert Sticky Notes anywhere in your worksheets for quick reminders.
    Simply select Insert, Sticky Note from the menus. You have a choice of colors and features. Even better, the sticky notes do not print unless you want them to. If sticky notes are useful for you paper work, you can image how useful they are in your complex spreadsheets.
  4. The new Zoom toolbar that lets you zoom in plus or minus 5% increments.
    Now you can get the zoom setting you want quickly and easily.
  5. The Favorite Directories feature and Bookmark feature
    which lets you quickly access your favorite directories. We know that is two features, but the are companion features! These features are especially useful if you have files in different directories, such as on your PC and on a network.
  6. The Hide and Un-Hide Sheets feature
    surprised us, and we wrote it! Now, when you are working on two widely separated sheets in a workbook, just hide the sheets between the ones you are working on. This makes it easy to move from one sheet to the other with just a single mouse click. You will not believe how much un-needed sheet scrolling this one feature eliminates! And, clicking on those small, tiny sheet scrolling buttons is a pain. We liked it so much, we also put it on the workbook tab pop-up menu. And we make it easy to un-hide many sheets at one time!
  7. The Save or Close Multiple Files features.
    Instead of having to go to each individual file and save or close it, just run one of these features instead!
  8. The special pivot table features found under the Data Menu.
    Our favorites are the extend the pivot table data range feature, the refresh all pivot tables feature, the format pivot table fields feature, and ... well you get the picture. Check them out!
  9. The set print area and titles features.
    These features are the easiest way to set the print area and titles that you can find. A runner-up on our top ten list is the "Display bottom of Print Area" feature.
  10. The rename or delete the active file features.
    The first feature allows you to rename a file after you have opened it. You can even use this feature to move the file to another directory. The delete the active file feature allows you to delete a file after you open it. Now you do not have to close the file, go to File Manager or Windows Explorer, find the file, make certain it is the right file, and then finally delete it..

Honorable mention goes to the Conditional Select features.
For example, these features allow you to select just number cells (a great way to find our which cells are the input cells), select just formula cells, or select just the cells containing #REF values (you've probably been there before). There is even a special select cells feature that selects cells based on an IF test.

Some other features that almost made the top ten list are:

Did we mention that the Spreadsheet Assistant allows you to easily assign any feature to a button for even faster and easier use? And to help you save time finding just the right feature, we put a "find a feature" feature at the top of the Spreadsheet Assistant's feature list. That is a lot of features, but that's what the Spreadsheet Assistant gives you.

The Spreadsheet Assistant $39.95

Please note, order page may default to your own countries currency

Excel Add-ins | Excel Training | Excel Add-in Collection | Excel Book Store | 1200+ VBA Solutions | XL Duplication Manager | Excel Everywhere HTML, Java / JSP, ASP & ASP.NET | Excel Smart Tools | 80% Off Add-ins | Timesheet | Templates | Templates & Calculators

Free Excel Support | Excel Timesheet | Excel Newsletter Archive | Excel Templates | OzGrid Excel Add-ins | Bundled Savings | 1200+ Excel Macro Examples | Excel & VBA Downloadable Training | Cost Estimating | Financial Calculators | Trading Software & Add-ins | Chart Tools & Add-ins | Excel Password Recovery | Corrupt Excel, Word, Access File Recovery | Microsoft Windows and Internet Software