Unit 6: Selecting Ranges

➔ CONTIGIOUS AND NON CONTIGIOUS TECHNIQUES

To create text in a cell, position the cell-pointer at the desired cell address and then type the entry from the keyboard. For example, to enter text Entering Text in cell address A1;

      1. Move the mouse-pointer to cell address A1 and click the left mouse-button just once. Instantly, the cell pointer changes like rectangle shape at cell address A1.

      2. Now type entering text in a cell.

      3. Then press the enter key from the keyboard, your workbook will be shown.

      4. Text entries are normally used as row and column headings, for entering phone numbers, addresses, etc. all texts are left aligned. And for a formula cannot be applied over text entries.

Each cell has a default width of 9-10 characters, i.e. each cell can hold up to 9-10 characters. In case, the entry of a cell address is more than its default width, its display gets extended to the next cell. This does not mean that it has occupied the space of the next cell. It has just got displayed over it.

➔ USING NUMBER AND DATA SERIES

Excel makes it very easy to enter a series of dates, number or text. For example, you can insert column heading like Jan, Feb, Mar, etc.…. or enter number at equal intervals, such as 2,4,6,8 etc. very easily. You can enter the above type of series in two ways:

      1. Using the mouse to drag the fill handle.

      2. Using a command that gives you the capability to create many types of series.

Dragging the fill handle to the right and down fills the series in increasing order; dragging the fill handle up or left fills the series in decreasing order.

➔ TO ADD A LIST IS IN A RANGE OF CELLS IN WORKSHEET, DO THIS;

      1. Select the cells that contain the list you want to create.

      2. The selection range appears in the Import List from cells: box you can reselect the list by clicking the arrow on the right.

      3. After the selection is final, click Import, and then click OK. The list you create is sorted in excel file, the list can then be used in any worksheet also.

➔ INSERTING AND DELETING ROWS & COLUMNS

WITH Excel you can delete or insert entire rows or columns. You can also easily delete or insert cells, leaving the surrounding rows and columns unaffected. This technique enables you to add or remove cells without having to change entire rows and columns. Sometimes you may need to insert cells, rows, or columns to make room for new formulas or data.

The delete command completely removes cells, rows or columns from the worksheet. This is the different from the Clear command in the Editing group. The Clear command removes a cell’s contents, format, or comments, but it leaves the cell intact.

UNIT 6 – Selecting Ranges


There aren't any posts currently published in this category.