Microsoft Excel Using Ranges - Microsoft Excel

How to Use Ranges in Excel 2010?

Ranges in MS Excel

A cell is a single element. In a worksheet it can hold a value, text or a formula. A cell is identified by address, it consists of a column letter and row number.

Example: cell B1 is the cell in the second column and the first row.

A group of cells is called a range. A range address is designated by specifying its upper-left cell address and its lower-right cell address, separated by a colon.

Example of Ranges :

  • C24 : A range that consists of a single cell.
  • A1:B1 : Two cells that occupy one row and two columns.
  • A1:A100 : 100 cells in column A.
  • A1:D4 : 16 cells (four rows by four columns).

Selecting Ranges

The range can be selected in number of ways:

  • Press the left mouse button and drag, highlighting the range. Then release the mouse button. If you drag to the end of the screen, the worksheet will scroll.
  • Press the Shift key while you use the navigation keys to select a range.
  • Press F8 and then move the cell pointer with the navigation keys to highlight the range. Press F8 again to return the navigation keys to normal movement.
  • Type the cell or range address into the Name box and press Enter. Excel selects the cell or range specified by us.

range intro

Selecting Complete Rows and Columns

To select an entire row or column, select entire rows and columns in the same manner as the ranges are selected:

  • Click the row or column border to select a single row or column.
  • To select multiple adjacent rows or columns, click a row or column border and drag to highlight additional rows or columns.
  • To select multiple (nonadjacent) rows or columns, press Ctrl while you click the row or column borders needed.

selected complete

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd Protection Status

Microsoft Excel Topics