 |
Quattro Pro
Homepage for tips and tricks for |
 |
|
Quattro Pro
Homepage for tips and tricks for |
|
List of all my WordPerfect Tips Pages
Try Corel's Knowledge Base
(More help for WordPerfect or Quattro Pro)
<enter> to move or continue in cell
Average of previous (newest) 4 entries
Bisecting A Cell
Calculate an average of cells
Column Head with multiple lines instead of multiple columns
Column Widths for printing
Fancy "flagged" items
Hiding Columns
Highest number in a range
If and Then formulas
Print only part a spreadsheet
Truncating instead of rounding off
Zero's not displayed
| Points | Max Points | Total |
| 65 | 50 | 50 |
| 35 | 50 | 35 |
| 46 | 50 | 46 |
If(A2>B2,B2,A2)
which means, if A2 is greater than B2 then use B2, otherwise if A2 is not greater than B2 then use A2.
Average of previous (newest) 4 entries
| A | B | C | D | E | F | |
| 1 | Last 4 | Wk 1 | Wk 2 | Wk 3 | Wk 4 | Wk 5 |
| 2 |
22.5 |
10 | 15 | 20 | 25 | 30 |
Cell entry for cell A2
@avg(@index(A2..BA2,@count(A2..BA2)-{1,2,3,4},0))
Change the panes to clear them out:
View, Panes, Clear (or click on the pane splitter and drag the window down or to the right. Adjust the column widths now to preview your report for the printer.
(You can change them back for screen view)
Tables: After you've created your table and inserted the numbers, click in the cell where you want the average to appear. Display your Feature Bar (right click inside the table and choose Feature Bar). In the long white box on above your Feature Bar, click inside and type: AVE( Then use your mouse to click and drag to select the cells you want to use for averaging. Next click inside the formula area and type: ) and press [enter]. Your average will appear. Quattro Pro: The formula is @AVG(A1..A10) (or what ever the range of cells are that you want to use for averaging.)
Select File:Page Setup from the menu and choose the Sheet tab. In the first box at the top (Print Area) enter the range of cells to print such as B5:G23 and press the Enter key.
Click on the column to select it, then select Column from the Format menu. This opens a submenu from which you can choose the Hide menu. When you want to see the column choose the Column command from the Format menu and choose the Unhide command from the submenu.
To change this option from one style to another, go to Tools, Options, Edit and check or un-check Move Selection After Enter .
Changing 14.156667 to 14.15
Use the formula @int(A1*100)/100 where A1 is the field you are working with
To make a diagonal line through a cell, Select View, Toolbars, Drawing, OK
Click on the diagonal line tool, hold the <Alt> key and drag a line from corner to corner in the cell.
Line properties can be changed to use different styles or colors. Change the style before doing the above.
Let's put some smilies in the columns of the good results and bad results.
You have a column (B) that has totals. If the total is lower than 50, you want a frown, if it's higher than 90, you want a smile. (Anything in between is just "ok")
In the first column, or insert a column if necessary, type this formula in the first cell where a smiles might be: @if(B1<50,-1,@if(B1>90,1,0)) (The B represents the column that has the total you are referencing)
Now, click on the cell and drag down to the last row you want to use for smilies. Right-click and select QuickFill. With selection still highlighted, select Format, Block, Numeric Format, User Defined. In the box, type this: N'J';N'';N'L' (note: after the second N, the character is 2 ' characters, not 1 of the " characters) Next, click on Font, select Windings and change the point size to 16 and click OK.
See the faces? But what about using a different character instead of a face. Open the program called Character Map and select the font Wingdings. You notice that if you click on the smile face you'll see that character is what you get when you press J key and the frown is the L key. (Don't have Character Map? Open WordPerfect and play around with fonts until you find different fonts that have characters instead of letters) If you want different characters, then just change the J and L where you typed in the Format, Block, Numeric Format, User Defined dialog box. Actually you can use any character you want from any font. You can try changing the font to WP Ionic Symbols A and use N'T';N'';N'V' and you'll get a check mark for good, and an X for bad.
Note: the User Define box is case sensitive
Zero's not displayed
If you don't want the zero's to show on a page, then click on Format, Page, Display, and click on No in the Display Zero section
Alt+Enter or Ctrl+Enter just won't work here. You need to type the heading as usual in the cell you want to use. The with that cell still selected, right click and choose Block Properties (or Format, Block) and click on the Alignment tab. Place a checkmark in the box for Wrap Text.
I have a time sheet that I use to record my hours, salary, tips, etc. In each 2 week sections I have a cell that tells me how much I averaged per hour for those 2 weeks. At then top of column C, the cell tells me what the most amount I have earned in a 2 week period (This is great when you're a waitress, or when you salary constantly changes from week to week.
To find the highest number in a range of cells, place your cursor where you want the result to show. Then for the formula type: @MAX(C10..C300)
This result will show the highest number in the cells from C10 to C300...presuming all the cells are data cells and not text.
To have the results of this cell range without including text, you would have to type each cell individually: @MAX(C100,C200,C300)
New Tips? E-Mail me at: Carney Creations
This page maintained by: Tracy
@ Carney Creations
Disclaimer: I am only responsible for the actions/inactions of myself.
All other use of the tips in connection with my home page and links are the sole responsibility of the end-user.