 |
Tables Within WordPerfect Homepage for tips and tricks for |
 |
|
Tables Within WordPerfect 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)
By selecting the entire section you want to add, you can use the autosum feature in any spreadsheet.
Select cells A1 through E5. Select autosum (or Sum)
This will give you a sum in column E and row 5
| A | B | C | D | E | |
| 1 | 3 | 5 | 1 | 5 | 14 |
| 2 | 6 | 8 | 9 | 5 | 28 |
| 3 | 5 | 7 | 6 | 1 | 19 |
| 4 | 6 | 7 | 9 | 5 | 27 |
| 5 | 20 | 27 | 25 | 16 | 88 |
In the Total (or Current Balance) column create the formula Sum(E2+C3-D3)
| Current Balance | $50.00 | ||
| Payment | $10.00 | ||
| New Balance | $40.00 |
| 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.
Tired of typing so much for increments? Try this when you make a table that will have increments of date and/or time This will give you a table that looks like this, without all the typing. All you have to do is fill in the first 2 columns of date and first 2 rows of time.
| 8/1/96 | 8/2/96 | 8/3/96 | 8/4/96 | 8/5/96 | |
| 1:00 | - | - | - | - | - |
| 1:15 | - | - | - | - | - |
| 1:30 | - | - | - | - | - |
| 1:45 | - | - | - | - | - |
| 2:00 | - | - | - | - | - |
Click on Insert, Date, Date Format, Custom. Delete the contents of the box titles Edit Date Format.
Click on Time Codes, select Hour(12)#, Leading Space, press Insert.
Type a colon (:) at the end of the line in Edit Date Format box. Select Minute#, Leading Zero, click on Insert. (If you want am or pm also, then insert a space at the end of the line in the Edit Date Format box, select Am/Pm from the Time Codes, and press insert) Click OK.
Now, in the table, select the entire first row (excluding the first cell). Right-click, select Number Type, Date/Time, Custom, and select the format you want to use. Click OK twice.
Now select the entire first column (excluding the first cell). Right-click, select Number type, select Date/Time, then OK
Finally, type information in the first 2 rows (1:00 and 1:15) and first 2 columns (8/1/96 and 8/2/96).
Once again, select the entire first row, right-click and choose Data Fill (QuickFill). Select the entire first column, right-click and choose Data Fill (QuickFill). That's it. Easy? You'll get used to it if you use this very much.
A simple solution- -create an extra column in the table and remove the lines.
* If you want to join the cells, right-click in the column and choose Join Cells.
* To remove the lines from this column, right-click and choose Lines/Fill.
To copy the cell information down the column, select Down: and type the number of cells down you want to fill in. To copy the information across the row, select Right: and type the number of times you want to copy it. Choose ok to copy the information. Any formatting used by the cell is also copied.
If you only want to copy the text in the cell and not any of the formatting, you can use the Data Fill feature. To do this, select the cell containing the information and the adjacent cells that you want to copy it to (either below or to the right of the original cell). Right-click and choose Data Fill from the QuickMenu. This automatically copies the text--without any of the formatting--to the other selected cells.
When columns or rows don't have figures for the last row to calculate, you can change the "total" so it doesn't show $0.00. Just leave it blank: Here's how
Modify your formula for the last column/row so it looks something like this:
IF(A*E9=0, NA(),A*E9)
Note: I don't know if there should be a space after 0, or not.
To automatically have rows numbered in tables and updated, try the following tip:
Place the insertion point in the first column of your table where you want the row numbers to appear.
Choose Format/Layout, Line, Numbering
Select Turn Line Numbering On and deselect Restart Numbering on Each Page (to allow for continuous numbering if the table spans a page break).
In the From Left Edge of Page: text box, insert the position where the line number should be placed so it appears in the first table column. For example, if you have a 1" left margin and the table starts at the left margin, you might insert 1.25" to have the line number appear slightly inside the first table column.. Choose OK
If the line number isn't positioned where you want, choose Format/Layout, Line, Numbering and change the amount.
When the line number is positioned correctly, place the insertion point on the first line after the end of your table. Choose Format/Layout, Line, Numbering. Deselect Turn Line Numbering On and choose OK to turn off the line numbering after the table. Now Lock the cells to avoid typing over by mistake. Select the entire column by double clicking when the cursor turns to an arrow. Right click and choose Format, Cell, Lock.
Place the insertion point in the last row. Insert a dummy row just above this row by right clicking, choosing Insert, then OK.
Now place the insertion point in the cell that should contain the formula. Right click and choose Formula Bar. Then click inside the formula box and type SUM, then click the first cell in the column that should be included in the cum. Click in formula bar box and type : Click the cell in the dummy row you just inserted (just above the last cell) to insert this cell reference in the formula. Click again the in formula box and type a closing parenthesis. It will look like SUM(C1:C4). Click the green check mark to insert the formula then close.
1. Select the entire blank dummy row you just inserted and edit the row format. By selected a fixed size with a row height of .02". Select Cell at the top of the dialog box and select Lock, choose OK.
With the row still highlighted, choose Lines/Fill and choose 100%fill, then OK.
2. Select the last row without changing the height and choose the entire row. Use the cell lock feature to lock the cell with the formula as well as the entire blank row above it. You'll be able to insert rows only above the calculation
Now you will be able to insert rows and keep the formula calculating.
Place Text NEXT to your table
1. Create the text you want inside of a Text Box with no borders. Then position the text box next to the table.
2. Create the table in a text box. Choose Border/Fill and select <None>, choose OK.
Choose Size from the feature Bar and type the approximate total width of your table in the Set text box. Choose OK
With the insertion point still in the graphics box, create and format the table as you normally would.
When you're done, click outside the graphics box and return to your document.
Now you can click and drag the table anywhere in the document
In order to have numbering portrait style and the table landscape style, you must place the number of the page in a text box and rotate the words
This feature is best used when you don't have calculations to create, only text.
Edit your preferences. Press Table, Calculate and make sure the calculation mode is set to off
Ensure that the cess is formatted so the Ignore Cell When Calculating is checked marked
Select one of the rows entirely and right click, Choose Format, Column and simply click within the "Width: text box" without typing anything. The row will automatically change to all columns to be the same size. From there you can adjust any column you need.
Before beginning the sort, use the mouse to select only those rows you want to sort. Only then will you continue with the regular process of going to Tools, Sort and continue as usual
Click on a cell and hold the click. The cell will change color to a yellow border. At that time, you can just drag it to where you want to go.
Now you can easily split your table cells diagonally with WP 7. Place the insertion point in the table cell you want to divide, or select a group of cells. Right-click the table and choose Format. In the Diagonal Lines group box, select the option you want, such as Upper right to lower left. You can even create an "X" in the cell by selecting Both. Choose OK. The diagonal line automatically adjusts to the width of the cell.
Need to show a date? But only 10 days before a specified date? Well now you can using floating cells.
Place your cursor right where you want the date to "suddenly appear".
Choose Table, Create, Floating Cell, OK. (Then, if the formula bar doesn't appear on your screen, click Table, Formula Bar). Click inside the formula box and type: DateText (DateValue (Date ())+10) You can change the number 10 to any number of days in advance that you want
Click on the green checkmark, then Close
Then next time you start this document, you may have to go to Table, Calculate, Calc Document.
If you want a different style of date showing, place your cursor somewhere in the date and choose Table, Number Type, Date/Time, Custom and select whatever style you want
Well, then sometimes it doesn't. Maybe you need to check your settings. Go to Table, Calculate. Make sure that Calculate Document radio button is deleted. Now click OK. Your changes will, from now on, recalculate on their own.
That top line probably has your column names in it, right? All you have to do is change the style for that row. Place the cursor in that top row. Press Table, Format, Row, Header Row, OK
In tables, when you sort, the columns are considered alphabetically. You just have to change the keys a bit. Go to Tools, Sort, Select First cell in a table, then Edit. Change the Type from Alpha to Numeric. To sort from the highest number to the lowest, change the sorting order to Descending
When adding rows to a table, you need to ensure that the formula where you inserted the row is included within the formula's range.
"For example : if the total cell at C6 and the formula to sum all the above cells is sum(C2:C5), then when you add a row, you have to put the cursor at row 5 then insert one or more row above row 5 in order the formula will cover your added row; because when you add as describe above the formula will change to sum(C2:C6)."
"If you put the cursor at row 6 and add one row above row 6, then it won't change the formula because the formula refer to row 5 while you didn't change row 5 but add a row below row 5.
If the formula was in difference format, e.g. C2+C3+C4+C%+C6, then you have to change it using sum(C2:C6)"
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.)
To have columns of tables, first turn on Reveal Codes (View, Reveal Codes). Click on View, Zoom and select Page Width. Now Resize the table so it is about half the width of the page.
Place your cursor right before the table definition. (you will need to use your arrow keys to get to the right point.) Now click on Format, Columns, Define and select 2 columns. If you want to have 3 columns, you will need to make sure the width of the table is about one-third of the width of the page.
Now, lets say that you have your table in 2 columns and you now want to go back to full page
width of your text. Using your cursor, go to the point right after the table off code. Again, click
on Format, Columns, Off. Now your right back to where you started.
Now that you know how to create tables in columns, try this out. It will give you your header in each column.
You won't be able to use the Column Break feature, so you may have to create a new table. So, first (before you start your table) go to Format, Page, Subdivide and select 2 columns and 1 row (unless you want to have more than 2 columns of tables).
Now create your table as usual (Table, Create). Go to Table, SpeedFormat. Use one of the styles that will give you a header style for the columns. Type the name of the columns in the top of the 2 columns (or the one column if you chose something like Header Fill Title style).
Now just start filling in your information. Like I said, you can't use a Column Break, so you will have to keep tabbing until you get to the bottom of the page in order to start your second column of tables.
When you're done with that page of tables, place your cursor just after the table ends and go to Format, Page, Subdivide, and press Off. This will stop the subdividing and the remaining pages of your document.
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.