Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 30 - CodePilot V5.0 C6
P. 30

    SELECTING CELLS IN A WORKSHEET

                      To perform any editing operations on cells, you need to select them. You can select a single cell
                      by simply clicking on it. If you want to select multiple cells or cell ranges, there are various ways:
                          Entire Row: Click on the row number to select the whole
                         row. This highlights  all cells  in  that  row across  the

                         spreadsheet.

                                          Entire Column: Click on  the  column  letter  to select  the  whole column.  This

                                         highlights all cells in that column down the entire sheet.

                          Entire Worksheet: Click on the Select All button       located below

                         the Name box to select the entire worksheet.

                                                     Range of Cells: Click on the first cell you want to select, then hold
                                                    the mouse button and drag to the last cell. Alternatively, you can
                                                    use the Shift key: click on the first cell, press and hold Shift and then
                                                    click on the last cell to select the range.

                          Selecting Multiple Cells: To select multiple cells that are not adjacent,
                         click on the first cell. Then, hold the Ctrl key and click on the other

                         cells you want to include. The selected cells will be highlighted.

                       RAPID RECALL                             Tick ( ) if you know this.

                          1.  A custom list allows you to define your own series of data that can be used to

                              automatically fill cells.
                          2.  Formatting text in a worksheet involves changing how the text appears to make

                              it easier to read and more visually appealing.

                             COPYING/MOVING DATA

                      You can copy and move cell contents or an entire worksheet. Copy creates a duplicate, while Cut
                      moves the data to a new location.

                       28
                            CodePilot (V5.0)-VI

| 25 26 27 28 29 30 31 32 33 34 35 |