Spreadsheet Assistant
Is an Excel add-in that adds many useful features and functions to Excel to make it even easier to use. Rated 5 stars by ZD Net.
Spreadsheet Assistant is an add-in for Microsoft Excel 2007, Excel 2003, Excel 2002 (XP), Excel 2000, and Excel 97.
Spreadsheet Assistant: Overview | Assistants | Screenshots
Spreadsheet Assistant assistants
The following is a list of the edit 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:
Select And Fill 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 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
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 and create hyperlinks to them
- Sort or Re-Arrange the Sheets
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
Warning: main(/home/sites/office-addins.com/_tpl/pr_lm-Spreadsheet-Assistant.html) [
function.main]: failed to open stream: No such file or directory in
/home/sites/office-addins.com/-excel-addins/spreadsheet-assistant-assistants.html on line
365
Warning: main() [
function.include]: Failed opening '/home/sites/office-addins.com/_tpl/pr_lm-Spreadsheet-Assistant.html' for inclusion (include_path='.:/usr/local/share/pear') in
/home/sites/office-addins.com/-excel-addins/spreadsheet-assistant-assistants.html on line
365
Order a fully-functional version of Spreadsheet Assistant
You can get more information at the developer's site.
