Comparing Microsoft Excel and Quattro Pro features
Many features in Microsoft Excel are similar to those in Quattro Pro, despite different naming conventions. The following table can assist you in moving from Microsoft Excel to Quattro Pro.
|
Microsoft Excel feature
|
Quattro Pro feature
|
To access the feature in Quattro Pro
|
|
Array formulas
|
Array
|
|
|
AutoFill
|
QuickFill
|
Click Edit  Fill QuickFill. |
|
AutoFit
|
Fit As-You-Go
|
Click Tools Settings, and then in the list of categories, expand Workspaces Application, and click General. Enable the Fit As-You-Go check box. |
|
AutoFormat
|
SpeedFormat
|
Click Format SpeedFormat. |
|
Automatic file backup
|
Timed backup
|
Click Tools Settings, click File options, and enable the Timed backup every check box. |
|
AutoSum
|
QuickSum
|
Click the QuickSum button on the Notebook toolbar.
|
|
Built-in full debugger
|
Debugger
|
Click Tools Macro Debugger. |
|
Calculation methods
|
Formulas
|
Type a plus sign (+) in a blank cell and type a formula.
|
|
Cell-based auditing
|
Auditing toolbar
|
Click Tools Auditing Show auditing toolbar. |
|
Cell formatting
|
Cell properties
|
Click Format Selection properties. |
|
Cell notes
|
Comments
|
Click Insert Insert comment. |
|
Center across block
|
Center across block
|
Click Format Selection properties, and click the Alignment tab. In the Horizontal alignment area, enable the Center across block option. |
|
External range links
|
Notebook links
|
|
|
Floating text boxes
|
Text box graphics
|
Click Insert Shapes Text box. |
|
Formula bar
|
Formula view
|
Click View Formulas. |
|
Function Wizard
|
Formula Composer
|
Click the Formula Composer button.
|
|
Goal Seeker
|
Solve for
|
Click Tools Numeric tools Solve for. |
|
Headers and footers
|
Page setup
|
Click File Page setup. |
|
Mail enabled
|
Send mail
|
Click File Send to Send mail. |
|
Merge
|
Join cells
|
Select the cells you want to join and click the Join cells button on the toolbar.
|
|
Multi-Variable Backsolver
|
Optimizer
|
Click Tools Numeric tools Optimizer. |
|
Nameable sheet tabs
|
Nameable sheet tabs
|
Click Format Sheet properties, then click the Name tab. |
|
Nonlinear Solver
|
Optimizer
|
Click Tools Numeric tools Optimizer. |
|
Normal view
|
Draft view
|
Click View Draft view. |
|
Notebook drawing layer
|
Shape insertion
|
Click Insert Shapes, and click a shape. |
|
Password-protect file
|
Password-protect file
|
Click Format Notebook properties, and click the Password level tab. |
|
Queried import
|
Notebook query
|
Click Tools Data tools Notebook query. |
|
Save as Web page
|
Publish to Internet
|
Click File 
jpg" height="14" width="9" border="0" hspace="0" vspace="0" align="absmiddle"> Publish to Publish to Internet. |
|
Save workspace
|
Save notebook group
|
Click File Notebook group Save notebook group. |
|
Search/replace
|
Find and replace
|
Click Edit Find and replace. |
|
Sort databases
|
Sort databases
|
Click Tools Sort. |
|
Templates
|
New from project
|
Click File New from project. |
|
Toolbar Designer
|
Toolbar customization
|
Click Tools Customize, and open the Customization category. |
|
Trace mode
|
Macro debugging
|
|
|
Visual Dialog Builder
|
Dialog designer
|
Click Tools Macro Dialog designer. |
|
Wizards
|
Experts
|
Right-click a toolbar, and click Experts and numeric tools.
|
Comparing Microsoft Excel and Quattro Pro features