Working with toolbars
Toolbars give you quick access to the features you frequently use. You can create your own toolbars from a wide assortment of toolbar buttons. Quattro Pro creates a personal toolbar to which you can drag or copy toolbar buttons.
You can edit a toolbar to display the buttons you want, and in the order you want them. Because of the enhanced toolbar functionality in Quattro Pro, you cannot use toolbars that you created in earlier versions of Quattro Pro. These toolbars must be re-created. However, you can import toolbars that other people have created in Quattro Pro by using the workspace feature.
You can display toolbars horizontally or vertically around the Quattro Pro window, or display a floating toolbar within the spreadsheet window. You can hide any toolbar you don’t want displayed. The following standard toolbars come with Quattro Pro:
|
•
|
|
Notebook — provides tools for entering and editing data
|
|
•
|
|
Selection formatting — provides tools for manipulating the current selection
|
|
•
|
|
Data manipulation — provides tools for working with notebook cells and selections
|
|
•
|
|
Drawing tools — provides tools for drawing or inserting objects in a graphics window, and for arranging objects on a layer on top of the notebook
|
|
•
|
|
Outlining tools — provides tools for grouping data in collapsible and expandable sets of information
|
|
•
|
|
Auditing tools — provides tools for tracing dependent cells, precedents, and even errors in large, complex notebooks
|
|
•
|
|
Review — provides tools for reviewing shared notebooks
|
|
•
|
|
Experts and numeric tools — provides tools for quickly creating maps, charts, and budgets, and for performing computations
|
|
•
|
|
CrossTab report — provides tools for manipulating cross-tab reports
|
|
•
|
|
Visual Basic — launches the Visual Basic Editor and Visual Basic Design Mode
|
You can reposition a toolbar by dragging it to the top, bottom, left, or right edge of the application window. If you drag the toolbar away from all edges of the application window, it becomes a floating toolbar. You can also rename or delete a toolbar you have created. If you make changes you no longer want, you can reset the toolbar to its default settings.
You can change the graphic or text of a toolbar button, or have Quattro Pro display text under all toolbar buttons.
Quattro Pro lets you create a button that will launch a Windows application or document. You can also create a button that executes either a Quattro Pro or PerfectScript macro.
To create a toolbar |  |
|
1.
|
|
Click Tools
 Customize. |
|
2.
|
|
Open the Customization menu.
|
|
3.
|
|
Click Toolbar.
|
|
4.
|
|
Click New.
|
|
5.
|
|
Type a name for the toolbar.
|
|
6.
|
|
Click Commands.
|
|
7.
|
|
Choose the commands you want from the Commands list.
|
|
Each command appears under the appropriate menu name.
|
|
8.
|
|
Drag the commands from the list to the toolbar.
|
To edit a toolbar | 
ads/sub/quattro-pro/en/source/images/btnbacktotopproc.gif" alt="Back to Top" border="0" height="10" width="10"> |
|
1.
|
|
Click Tools
Customize. |
|
2.
|
|
Open the Customization menu.
|
|
3.
|
|
Click Toolbar.
|
|
4.
|
|
Enable the check box beside the toolbar you want to customize.
|
|
5.
|
|
Click Commands.
|
|
6.
|
|
Choose the command you want from the Commands list.
|
|
Each command appears under the appropriate menu name.
|
|
7.
|
|
Drag the command to the desired location on the toolbar.
|
|
•
|
|
If you want to customize a context menu, select Context menu from the toolbar list.
|
To display a toolbar | |
|
1.
|
|
Right-click any toolbar.
|
|
2.
|
|
Click the toolbar you want to display.
|
To move a toolbar | |
|
1.
|
|
Point to the two vertical gray lines at the left of a toolbar.
|
|
2.
|
|
Drag the toolbar to a new position.
|
|
•
|
|
To have a toolbar title display on a floating toolbar, enable the Show title when toolbar is floating check box in the toolbar customization dialog box.
|
To rename a toolbar | |
|
1.
|
|
Click Tools
Customize. |
|
2.
|
|
Open the Customization menu.
|
|
3.
|
|
Click Toolbar.
|
|
4.
|
&nbs
p; |
Select a toolbar.
|
|
5.
|
|
Press F2.
|
|
6.
|
|
Type a new name.
|
|
•
|
|
You cannot rename system-defined toolbars.
|
To delete a toolbar | |
|
1.
|
|
Click Tools
Customize. |
|
2.
|
|
Open the Customization menu.
|
|
3.
|
|
Click Toolbar.
|
|
4.
|
|
Select a toolbar.
|
|
5.
|
|
Click Delete.
|
|
•
|
|
You cannot delete system-defined toolbars.
|
To reset a toolbar | |
|
1.
|
|
Click Tools
Customize. |
|
2.
|
|
Open the Customization menu.
|
|
3.
|
|
Click Toolbar.
|
|
4.
|
|
Select a toolbar.
|
|
5.
|
|
Click Reset.
|
|
•
|
|
You can only reset a system-defined toolbar.
|
To add a graphic or text to a toolbar button | |
|
1.
|
|
Right-click a button on a toolbar, and click Customize
Toolbar item. |
|
2.
|
|
Enable one of the following display options:
|
|
•
|
Image only
|
|
•
|
Caption only
|
|
•
|
Caption below image
|
|
•
|
Caption to right of image
|
|
•
|
&nb
sp; |
You can revert the toolbar button to its original display setting by right-clicking the button, and clicking Customize
Toolbar item Default. |
To display text under all toolbar buttons | |
|
•
|
|
Right-click a button on a toolbar, and click Customize
Notebook toolbar Caption below image. |
To add a button to the toolbar or property bar | |
|
1.
|
|
Right-click the toolbar or property bar, and click Customize
Property bar or Notebook toolbar Add new command. |
|
2.
|
|
Choose a command category from the list box.
|
|
3.
|
|
Drag a command from the list and position it on the property bar or toolbar.
|
To add a toolbar button that starts an application or opens a document | |
|
1.
|
|
Click Tools
Customize. |
|
2.
|
|
Open the Customization menu.
|
|
3.
|
|
Click Commands, and choose Programs from the list box.
|
|
4.
|
|
Click the Program command category tab.
|
|
5.
|
|
Click Add.
|
|
6.
|
|
In the Target list box, choose the file or application for which you want to create a button.
|
|
7.
|
|
In the Parameters list box, specify any command line options.
|
|
8.
|
|
In the Working folder list box, specify the working directory.
|
|
Leave the Working folder list box blank if you want to use the Quattro Pro startup folder.
|
|
9.
|
|
Click Apply, and drag the new button to a toolbar.
|
|
•
|
|
You can change the appearance and associated tooltip for the new button by clicking the Appearance and General tabs.
|
|
•
|
|
You can delete a toolbar button by selecting the command from the list and clicking Remove.
|
To add a toolbar button that plays a macro | 
otopproc.gif" alt="Back to Top" border="0" height="10" width="10"> |
|
1.
|
|
Click Tools
Customize. |
|
2.
|
|
Open the Customization menu.
|
|
3.
|
|
Click Commands, and choose Macros from the list box.
|
|
4.
|
|
Click the Macro command category tab.
|
|
5.
|
|
Click Add.
|
|
6.
|
|
Click one of the following buttons:
|
|
•
|
Quattro Pro macro, and type the macro command in the Enter macro box.
|
|
•
|
PerfectScript macro, and specify the macro file (.wcm).
|
|
7.
|
|
Click Apply, and drag the new button to a toolbar.
|
|
•
|
|
For more information about macros and toolbar buttons, see “To attach a macro to a toolbar button.”
|
|
•
|
|
You can change the appearance and associated tooltip for the new button by clicking the Appearance and General tabs.
|
|
•
|
|
You can delete a toolbar button by selecting the command from the list and clicking Remove.
|