Copying Information

Suppose that you are getting ready to finance a new home and you want to compare several different scenarios involving varying down payments, loan terms, and interest rates. You set up a spreadsheet like the one shown in Figure 4.8 and then decide that you also want to calculate the Monthly Payment amount at 6.5% and 5.5% for 30 years and then all three interest rates (6%, 6.5%, and 5.5%) for 15 years. In this example, you could start by copying the values in Column B to Columns C through E and then simply edit the cells that need to change.

Figure 4.8. Select the cells that contain the information you want to copy.

To copy the information, select all of the information that you want to copyin this example, you need to select B1.B11and then click the Copy tool on the Notebook toolbar.

Tip

If you select a single cell, Quattro Pro copies the information into as many cells as it needs to complete the copy operation. So, for example, if you select A1.A4 and copy them and then select B1 and paste, Quattro Pro fills B1.B4 with the copied information.

Then, highlight the cells where you want the information to appearin this example, I highlighted C1.E11and click the Paste tool. Quattro Pro copies the information into the selected cells (see Figure 4.9). Click in any cell to cancel the selection. You can now change individual cells as needed.

Figure 4.9. Quattro Pro copies information into the selected range.