Page 28 - Excel Data Analysis
P. 28

02 537547 Ch01.qxd  3/4/03  11:45 AM  Page 14







                     EXCEL DATA ANALYSIS





                  COPY AND PASTE A RANGE OF CELLS



                     f you want to use the same values in multiple locations,  After you copy a range of cells, you can paste the cell
                     instead of retyping, you can copy and paste. For  contents at any location within your current workbook,
                  I example, you may want to copy a data list for use in  another Excel workbook, or any other Microsoft Windows
                  another report, or duplicate a formula in multiple cells. You  program. Excel replaces the content of the cells where you
                  can repeat information within Excel using the Copy and  paste with the copied values. You can paste the copied cells
                  Paste options. When you copy a cell or range of cells, Excel  as long as you have not copied another range of cells or
                  duplicates everything in the cell — including the cell values,  until you close Excel.
                  formulas, formatting, comments, and data validation — and  Be careful when you paste the copied cells. The best
                  leaves the original cell values unchanged. You can use  method is to select the first cell where you want to
                  multiple cells so long as they are adjacent. You cannot copy  paste the contents of the cells and then apply the Paste
                  multiple cell ranges.
                                                                      command. If you attempt to select the entire range of cells
                  When you apply the Copy command to a range of cells,  where you want Excel to paste the contents and do not
                  Excel surrounds the cells with a dotted line. The selected  select the exact number of cells, you receive an error
                  cells remain marked until you perform a task that deselects  message.
                  them. You can quickly press the Esc key to deselect cells.
                  You can also apply menu options that change the
                  worksheet, including copying another range of cells,
                  inserting cells, or hiding rows.


                   COPY A RANGE OF CELLS


























                  ⁄ Select the cells you want   ¤ Click Edit ➪ Copy.  ■ Excel displays a dotted line
                  to copy.                                           around the copied cells.
                                            ■ You can also copy by
                  Note: See the section "Select a   clicking the Copy button.
                  Range of Cells" for more
                  information.

                   14
   23   24   25   26   27   28   29   30   31   32   33