Similarly, you can select any range of cells in your Excel worksheet. As you can see, we have dragged our pointer to the D5 cell.

Drag your cursor to the last cell of your range.

In our case, we have selected the B2 cell.

Select the cell from where you want to start selecting your range.

You select the range and change the background colour of the cells.įollowing are the steps to select a range in Excel: A. For example, let's suppose you can highlight the headers in the cell range A2:E2. While working with excel, you may want to select a multi cell range so you can easily make a command for all the cells at once. In this tutorial, we will briefly cover all the topics about ranges. You can perform many operations with ranges in your Excel worksheet, unlike copying the dataset, moving data from one position to another, formatting cells, and even you can name your range. In excel, each range has its defined set of coordinates or positions, unlike A4:A7, B5: F9C, etc. It can also be used to refer to the adjacent cells or non-adjacent cells in the dataset. Press 'Enter' and the cell will display the range for your set of data.Whenever we see the word range in excel, we refer to it as a cell or a collection of cells in an excel spreadsheet. Enter the following formula, without quotes, into the cell: '=MAX(A:A)-MIN(A:A)'. Press 'Enter' and the cell will display mode of the data set. Enter the following formula, without quotes, into the cell: '=MODE.MULT(A:A)'.

Press 'Enter' and the median of your set of numbers will appear in the cell.Ĭlick cell B3.

Enter the following formula, without quotes, into the cell: '=MEDIAN(A:A)'. Press 'Enter' to complete the formula and the mean of your numbers will appear in the cell.

Enter the following formula, without quotes, to find the arithmetic mean of your set of numbers: '=AVERAGE(A:A)'. Enter the second number into cell A2 and continue until you have entered the entire set of numbers into column A.Ĭlick on cell B1. Press 'Enter' and the program will automatically select cell A2 for you. Click on cell A1 and enter the first number in the set of numbers that you are investigating.

How to find a range in excel