Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 32 - 2505_CoreGPT(Podar)_Flipbook_C7
P. 32

    Step 2  Drag the fill handle over the cell or cells to which you want to copy the formula, then
                               release the mouse button.

                      Using Copy and Paste

                      To copy a formulas using copy and paste, follow these steps:

                      Step 1  Select the rows where you want to paste the formulas.
                      Step 2  Click on the Edit menu.

                      Step 3  Click on the Paste Special option. The Paste Special dialog box appears.
                      Step 4  Uncheck  the  Paste All  checkbox  and  all other  checkboxes  except  the  Formulas
                               checkbox.
                      Step 5  Click on the OK button.

                      The formulas will be pasted into the selected rows.

                            USING A TEXT FORMULA

                      You can concatenate text using the & operator. Concatenation refers to the process of combining
                      two or more text strings into a single string. You can perform concatenation using either the &
                      operator.

                      To concatenate strings, follow these steps:
                      Step 1  Click on the cell where you want the concatenated result to appear.

                      Step 2  Type the following formula:
                               =A1 & B1

                     30     Premium Edition-VII

| 27 28 29 30 31 32 33 34 35 36 37 |