Microsoft
Excel Templates, Training and Add-ins, Business Software and more!
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 ... |
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!
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
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