[ Go to 2,001 Tips Table of Contents ]|
QUATTRO PRO 6.0
Save a Print Setting
To store a number of different blocks of information in a single notebook, each with its own print settings, use File/Named Settings to create separate print settings for each block you need to print.
Get the Answer Before You Commit
Find the answer to a formula before leaving a cell by entering the cell formula and pressing F9. The value is then displayed. To keep the answer, press Enter and the value will be placed in the current cell.
Use Edit Mode
To use the left and right arrow keys to move through the characters in an entry, press F2 and switch to Edit mode. To delete all data on the edit line, press Ctrl+Backspace; to erase all data to the right of the cursor, press Ctrl+/.
Manage Your Macros
Press Shift+F3 to see a list of macros. You can move directly to the macro commands in a category by navigating through the dialog boxes. Press Alt+F3 to call up a list of all available functions.
Custom SpeedFill Lists Made Easy
Custom SpeedFill Lists are easier than ever in Quattro Pro 6.0. Choose Notebook/Define Series and select Create. Give your series a name, then type each item in the list, clicking Add after each entry. Decide whether or not you want your list to be repeating, then press OK.
I Get Around
Press F5 to use the arrow keys to look at another area of a spreadsheet. Press Esc, not Enter, to return to your original location.
Add an Annotation
To add a nonprinting annotation to a cell, add a semicolon, followed by the comment text, after a formula or value. Example: 8.50; current annual percentage rate.
Less Than Zero
Hide (or display) zero values by right-clicking on the Page tab, choose Display Zeros and select Yes or No. This setting applies only to the current notebook page.
Load Your Favorite Notebook
To load a specific notebook each time you open Quattro Pro, select the Application Property Inspector and right-click on the title bar. Select File Options and enter the filename (with path).
To convert a date label to a serial number date, select the cell containing the label, delete the initial apostrophe, and press Ctrl+Shift+D.
Keep Those Macros Safe
To keep from accidentally overwriting your macros with data, put all of them on a dedicated notebook page. Name the page "Macros" so you won't forget what it contains, and protect it from inadvertent changes by using the Property/Active Page/Protection menu.
Lost & Found
Can't find a file? Word's File Open dialog box lets you search
for files by name, text in the document or date saved. Type the
search criteria and click on Find Now. To see thumbnails of found
files, click on the Preview button on the toolbar.