[ Go to 2,001 Tips Table of Contents ]

2,001 Tips


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).

Date Conversion

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.

[ Go to 2,001 Tips Table of Contents ]