If a cell is empty, QuickSum doesn't calculate any cell above the empty one. The little blue triangle that appears in the lower right corner indicates that a cell has a formula in it.Ī QuickSum formula in a column adds all the numbers in cells directly above it a QuickSum at the end of a row adds all the numbers to the left of it. Press Ctrl + =, or choose Table ? QuickSum. To use QuickSum, click in the cell where you want the total to appear. The QuickSum feature adds the values in all the cells above the formula in a column, or, in all the cells to the left of the formula in a row. Using QuickSumĪdding a column or row of figures is such a common task, there is a shortcut for it. And finally, I'll explain how to import information in a Quattro Pro (or Microsoft® Excel) spreadsheet into a WordPerfect table. After that, you'll learn how to create formulas using one of the 500 built-in spreadsheet functions. Next, we'll talk about how to create formulas that calculate a value (rather than typing it in). I'll start with a simple formula that totals a column (or row) of numbers. In this tutorial, I'll show you how to create formulas in tables. What you may not yet realize is that you can create formulas in WordPerfect tables and do some pretty fancy calculations on those numbers.Īnd if you can do calculations in WordPerfect tables, why turn to another program for simple tasks such as adding a series of numbers? Many users find that they construct small spreadsheets in WordPerfect and turn to Quattro Pro® for larger, more complex spreadsheets. You can use tables in a variety of situations, but most of us turn to them when we need to position text and numbers in columns. CorelDRAW Graphics Suite 2021 (Windows/Mac)Īs you may already know, the Table feature is one of the most powerful features in WordPerfect®.

How to insert a table in word perfect