Skip to main content
A range in Excel is a collection of two or more cells. This chapter gives an overview of some very important range operations.

Cell, Row, Column

Let's start by selecting a cell, row and column.

1. To select cell C3, click on the box at the intersection of column C and row 3









2. To select column C, click on the column C header.









3. To select row 3, click on the row 3 header









Range Examples

A range is a collection of two or more cells

1. To select the range B2:C4, click on cell B2 and drag it to cell C4.









2. To select a range of individual cells, hold down CTRL and click on each cell that you want to include in the range.









Fill a Range

To fill a range, execute the following steps.

1a. Enter the value 2 into cell B2.









1b. Select cell B2, click on the lower right corner of cell B2 and drag it down to cell B8.














Result:














This dragging technique is very important and you will use it very often in Excel. Here's another example.

2a. Enter the value 2 into cell B2 and the value 4 into cell B3.









2b. Select cell B2 and cell B3, click on the lower right corner of this range and drag it down.
















Excel automatically fills the range based on the pattern of the first two values. That's pretty cool huh!? Here's another example.

3a. Enter the date 6/13/2016 into cell B2 and the date 6/16/2016 into cell B3.









3b. Select cell B2 and cell B3, click on the lower right corner of this range and drag it down.















Comments

Post a Comment

Popular posts from this blog

Know about Excel Tables

23 things to know about Excel Tables by Dave Bruns | May 17, 2018 Excel Tables have a boring (and confusingly generic) name, but they are packed with useful features. This article is a summary of the things you should know about Excel Tables. 1. Creating a table is fast You can create an Excel Table in less than 10 seconds. First, remove blank rows and make sure all columns have a unique name, then put the cursor anywhere in the data and use the keyboard shortcut Control + T. When you click OK, Excel will create the table. 2. Navigate directly to tables Like named ranges, tables will appear in the namebox dropdown menu. Just click the menu, and select the table. Excel will navigate to the table, even if it's on a different tab in a workbook. 3. Tables provide special shortcuts When you convert regular data to an Excel Table, almost every shortcut you know works better. For example, you can select rows with shift + space, and columns with control ...
Post a Comment
Read more

Why Learn Excel?

A nalysts, consultants, marketing professionals, bankers, and accountants all use Excel on a consistent basis. You might even find that other random professionals like graphic designers and engineers are working away with the powerful formulas and charts that come with Excel.   Seeing as how Excel is so prominent in the workforce, it pays to learn all about it and put that experience on your resume. You might find that your current degree isn’t yielding any job prospects, so getting into Excel could get you a job in the meantime. Developing your Excel skills using online resources could improve your employment prospects without the need to spend a lot of money on college courses. Learning Excel might even improve your job opportunities if you lack educational experience. People who didn’t go to college can get into coding, of course, but the same can be said about Microsoft Excel. Upon completing the right training, you automatically make yourself more val...
1 comment
Read more

Getting Started

E xcel is a massive application with 1000s of features and 100s of ribbon (menu) commands. It is very easy to get lost once you open Excel. So one of the basic survival skills is to understand how to navigate Excel and access the features you are looking for. When you open Excel, this is how it looks. There are 5 important areas in the screen. 1. Quick Access Toolbar : This is a place where all the important tools can be placed. When you start Excel for the very first time, it has only 3 icons (Save, Undo, Redo). But you can add any feature of Excel to to Quick Access Toolbar so that you can easily access it from anywhere (hence the name). 2. Ribbon : Ribbon is like an expanded menu. It depicts all the features of Excel in easy to understand form. Since Excel has 1000s of features, they are grouped in to several ribbons. The most important ribbons are – Home, Insert, Formulas, Page Layout & Data. 3. Formula Bar : This is where any calculations or form...
Post a Comment
Read more