Excel Ranges

Contents:
Vertical RangeHorizontal RangeMixed Range Non adjacent RangeCopy a range Move a RangeFill a range

Excel Ranges is a collection of cells (two or more cells). This post will guide you how to use excel ranges from the below 5 topics:

  • Ranges types
  • Copy a range
  • Move a range
  • Fill a range

Ranges types

4 Range types will be descripted in the following examples. You just need to drag the mouse to select the range that you want.

Vertical Range

The vertical range contains two or more cells in the same column, such as: A1:A4 or entire column (A:A).

excel vertical range

Horizontal Range

The horizontal range is in the same cell, such as: A3:C3, and if you selected the entire row, such as: row 1, it can be indicated as  “1:1” .

excel horizontal range

Mixed Range

The mixed range contain multiple rows and columns, such as: row2-row4 and column A-Column C, it can be indicated as: A2:C4.

excel mixed range

Non adjacent Range

Non adjacent Range is a collection of nonadjacent cells, For example: we can select multiple selection range as one Range: such as: A2:A4, B6:B9, C2:C5.

excel non adjacent range

Note: before select other range, you need to press “Ctrl” key so that you can select multiple selection range or just only can select the current range.

Copy a range

The below will guide how to copy an existing range in excel from the below steps:

Step1#  Select one range, then right-click on it, click “Copy” or just press “CTRL” +”C

excel copy range rightclick

Note: the selected range will be highlighted at this moment.

Step2#  Select destination cell where you want to paste that range, such as: we will select F2. Right click it, then click Paste under “Paste Options:” or just press “CTRL” + “V”.

excel paste range

Move a Range

If you want to move a range to another location, just following the below steps:

Step1#  Select one range, then right-click on it, click “Cut”  or just press “CTRL” +”X”

excel move range right click

Note: the selected range will be highlighted at this moment.

Step2#  Select destination cell where you want to paste that range, such as: we will select F2. Right click it, then click Paste under “Paste Options:” or just press “CTRL” + “V”.

excel move range cut

Another way: you can click on the border of the range, then drag it to the new location.

excel move range drap border

Fill a range

If you want to fill a range or copy a cell to other cells quickly, just refer to the following steps:

Step1# Enter the value “one” into Cell B2

excel fill range select

Step2# Click on the lower right corner of Cell B2 and drag it down to cell B5

excel fill range drag

Step3# Let’s see the result:

excel fill range result

 

Related Posts

How to Add Prefix or suffix to Cell
add prefix to cell113

This post will guide you how to add common prefix or suffix to all cells or the range of cells in your worksheet in Excel. How do I add the same prefix or suffix to a range of cells without ...

Quickly Insert Multiple Rows or Columns in Excel
insert multiple rows or columns13

This post will guide you how to quickly insert multiple rows or columns in your Microsoft worksheet. You will see that how to add new multiple rows or columns with shortcut or insert feature, or insert copied cells in excel. ...

Split Excel workbook into separate Files
split workbook into separate file3

This post will guide you how to split a large workbook to separate files and each worksheet should be saved as a single file. How do I split the whole workbook into several excel worksheets or single excel file. Assuming ...

How to Get the List of File Names From a Folder
get list of file names from a folder11

This post will teach you how to get the list of file names in a given directory to a worksheet in Excel. You will learn that how to use Excel to view Files and Folders in your worksheet by get ...

Find Duplicate Values in Two Columns
find duplicate cells in two columns111

This tutorial will show you how to find duplicate values in two given columns in Excel. Or How to compare two columns and find duplicate entries in Microsoft Excel worksheet. And you will learn two methods to compare columns so ...

Remove Leading and Trailing Spaces
remove leading and trailing spaces112

In this tutorial you will learn that how to remove leading or trailing spaces from a text string in a cell in Excel. This post will guide you how to delete leading or trailing spaces of all cells in a ...

Generate Random Passwords
generate random passwords5

This post will teach you how to quickly generate a random password with Formula in Excel. You can combine a series of worksheet functions to create a complex formula to generate a random password in Microsoft Excel. Generate Random Password ...

Sort by Second or Third character in a Column
sort string by second character13

This post will guide you how to sort text string by second or third character in a Column in Excel. You may be want to sort a string in a Cell by the Second or last character in excel, how ...

Copy a Cell to Clipboard with Single Click
copy a cell to clipboard3

This post will teach you how to use the Excel VBA macro code to copy a Cell to clipboard with only single click in Excel. How do I automatically copy the content of cell to Clipboard while clicking on the ...

How to Convert Positive Numbers to Negative
change positive to negative 112

This tutorial will teach you how to change positive numbers to negative with Paste special multiply operation in excel. How to convert positive number to negative or how to reverse the number signs with VBA code in Excel. Convert Positive ...

Sidebar