Home / Computers / Microsoft Excel

Working with Ranges (Continued)

Ranges in Excel are used in a variety of ways. You can select a range to apply the same formatting to all the cells (such as font, size, color, borders, and shading), or you can enter the same data into each of the cells in the range using the Ctrl + Enter shortcut:

1. Select the range.

2. Type the data.

3. Press Ctrl + Enter.

Ranges are also used in performing calculations. When you enter a formula in the formula bar, you designate a range by typing the first cell in the range, followed by a colon (, followed by the last cell in the range. For example:

A1:F20

The range above includes cells A1 through A20, B1 through B20, C1 through C20, and so on through cell F20.