Basic HTML Version

|  | Table of Contents |  | View Full Version

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

    Selecting Cell Range

                     To select a range of cells, follow the given steps:
                     Step 1  Click, hold and drag the mouse until all of the adjoining cells are highlighted.

                     Step 2  Release the mouse to select the desired cell range. The cells will remain selected until
                              another cell in the sheet is clicked.
                     Selecting More than One Range of Cells

                     To select more than one range of cells, follow
                     the given steps:
                     Step 1  Click and drag to select the first range
                              of cells.

                     Step 2  Hold down the Ctrl key and click and
                              drag to select the next range of cells.
                               The  multiple ranges  of  cells will be
                              selected.
                     Naming a Cell or Range

                     Naming a cell or range in allows you to assign a meaningful label to a specific cell or group
                     of cells for easier reference in formulas. This helps improve readability and simplifies complex
                     formulas.

                     To name a cell or range, follow these steps:
                     Step 1  Select the cell or range of cells you want to name.
                     Step 2  Click on the Insert menu from the Menu bar.

                     Step 3  Select the Names option from the drop-down menu. A submenu appears.
                     Step 4  Click on the Define option. The Define Name dialog box appears.

                     Step 5  Type the desired name in the Name text box.
                     Step 6  Click on the Add button.

                     The cell or range is now named and you can reference it easily in formulas.
                     Note: While naming a cell or range, make sure it starts with a letter and contains no spaces.

                                                                                     Formulas and Functions in Calc      35

| 32 33 34 35 36 37 38 39 40 41 42 |