Excel Basics Iv

Filling A Range
Excel has a feature that helps you automatically enter data in a range of cells, it is called AutoFill. The autofill has a fill
handle (black cross at bottom right of a cell box) that does this.
Fill Handle of cell A1
Autofill A Range With Same Number

If you want to enter same number or data in a range of contiguous cells, you only need to enter it in one cell and use
autofill to extend it to other cells. You can autofill a range to the RIGHT, LEFT, UP or DOWN.
You can Autofill a range in two ways or options. For example, to autofill a range A1:A7 with the number 5;
Option 1: Using the Fill Handle

1. Enter the value 5 into a cell.
2. Select cell A1, click and drag the fill handle down to cell A7.
Result:
Option 2: Using the Ribbon Command
1. Enter data in the first cell and select the range of cells to be filled (A1:A7)
2. Click on Home Tab > select Fill > Down
NOTE: You can select DOWN, RIGHT, UP, LEFT to fill the range in that direction.
Result:
Autofill A Range With A Sequence
A sequence refers to numbers with a unique pattern of growth such as:
5,10,15,20,……
1,9,16,25,49,…..
-6,-4,-2,0,2,4,6,…..
There are different types of sequence such as Arithmetic, Geometric and Fibonacci Sequences.
If the difference between terms of a sequence are of equal steps, you can quickly determine nth term by
AUTOFILL.
Example 1: Extend the sequence 0, 2, 4, .. ….

You need to enter the first two values of the sequence to give Excel an idea of the increment or pattern
of growth, and the AutoFill command will then automatically extend the sequence.
1. Enter the first two values of the series in a Column and select them.
2. To fill in increasing order UPWARDS, select G8:G9 and drag the fill handle UP
3. To fill in decreasing order DOWNWARDS, select G8:G9 and drag the fill handle DOWN.
4. To fill in increasing order HORIZONTALLY, enter 2 in H9, select G9:H9 and drag the fill handle
RIGHT
5. To fill in decreasing order HORIZONTALLY, select G9:H9 and drag the fill handle LEFT
RESULT
Example 2: Find the 29th term of the arithmetic sequence 5,8,11,... .
Select the three terms and drag the fill handle The 29nth term will be at Row 29
down
Filling A Non-Numeric Series
The entry of values in first two cells is applicable to numeric data only. For non-calculated values or
series like days of the week, dates in a month, months of the year, you need only the first entry.
1. For example, Type Sun or Sunday into cell B2.
2. Click on the Fill Handle of cell B2 and drag it across to cell H2.
Result:
Date Sequence
NOTE: Excel uses the date setting on your computer for its workbook activities. Make sure your date
setting is current. You can adjust your computer date settings on your Taskbar
In this tutorial, the date format is day/month/year (not month/day/year).
Example 1: To fill a sequence to display midweeks (all Wednesdays) in 4th quarter of 2019
1. Type the first two dates
2. Select A2:A3 and drag the fill handle down
Result:
Sequence Using The Ribbon

You can also create a sequence using the Ribbon command. This method is valuable for a sequence
across large number of rows or columns. For example to fill a 0,2,4,… sequence up to 8650 (which is
difficult to achieve with fill handle),
1. Enter the first data of the sequence in a cell
1. Click Home Tab > Fill > Series
2. To fill HORIZONTALLY select ROWS
To fill VERTICALLY select Columns, enter the Step (difference) value, and stop value (last term).
Result:
Fibonacci Sequence
In Fibonacci sequence, a number is found by adding up the two numbers preceding (before) it.
Example: complete the sequence 1, 1, 2, 3, 5, ……
C1 is the sum of A1 and B1

To extend the sequence, drag the fill handle of C1 to the right
Result:
Move a Range
Sometimes, there is need to move a range of data from one location to another on a worksheet. You can
achieve this using the Move handle.
A cell showing the Move Handle
For example, to move the following range of data from column A to column C,
1. Select and click on the border of the range.
2. Drag the range to Column C and release the mouse

Result:
“Move a Range” achieves the same result as Cut and Paste.

Using the Ribbon option:
1. Select range to be moved, click Home Tab > click Cut (or press Ctrl x)
2. Select a destination cell in column C, click Paste or Ctrl v
Copy and Paste a Range

To duplicate a range, use the copy and paste command
1. Select the cell or range, click Home Tab > click Copy or ctrl c (or right click, and select Copy).
2. Click on the destination cell C and click Paste (or press Ctrl v)
Result:
PASTE OPTIONS:
There are several paste options available under the Paste icon and you can explore them.
To paste values only, click Values.
To paste cell formats only, click Formatting.
To paste formulas only, click Formulas.
PRACTICE EXERCISE
New General Mathematics for JSS1 Page 18
New General Mathematics for JSS 2
Page 16 Ex. 1g
Page 40 Ex. 4b (1)

Excel Basics Iv

Uploaded by

Copyright:

Available Formats

Excel Basics Iv

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Excel Basics Iv

Uploaded by

Copyright:

Available Formats

Filling A Range

Fill Handle of cell A1

Autofill A Range With Same Number

Option 1: Using the Fill Handle

2. Click on Home Tab > select Fill > Down

Example 1: Extend the sequence 0, 2, 4, .. ….

Example 2: Find the 29th term of the arithmetic sequence 5,8,11,... .

In this tutorial, the date format is day/month/year (not month/day/year).

Sequence Using The Ribbon

C1 is the sum of A1 and B1

A cell showing the Move Handle

2. Drag the range to Column C and release the mouse

“Move a Range” achieves the same result as Cut and Paste.

Copy and Paste a Range

To paste cell formats only, click Formatting.

To paste formulas only, click Formulas.

You might also like