Introduction

Whenever you occupational with Excel, you'll get in information—or content—into cells. Cells are the basic building blocks of a worksheet. You'll need to discover the basics of cells and cell content to calculate, analyze, and also organize data in Excel.

You are watching: The intersection of a row and a column in excel is known as a?

Optional: Download our practice workbook.

Watch the video below to learn much more about the basics that working v cells.


Understanding cells

Every worksheet is made up of thousands of rectangles, i beg your pardon are called cells. A cabinet is the intersection of a row and a column—in various other words, whereby a row and column meet.

Columns are determined by letters (A, B, C), while rows are determined by numbers (1, 2, 3). Each cell has actually its very own name—or cell address—based ~ above its column and row. In the example below, the selected cabinet intersects column C and row 5, for this reason the cell resolve is C5.


*

Note that the cell attend to also shows up in the Name box in the top-left corner, and also that a cell's column and row headings room highlighted when the cell is selected.

You can likewise select multiple cells in ~ the exact same time. A team of cells is known as a cell range. Rather than a solitary cell address, girlfriend will describe a cell range using the cell addresses the the first and last cell in the cabinet range, be separate by a colon. Because that example, a cell range that contained cells A1, A2, A3, A4, and A5 would certainly be composed as A1:A5. Take a look at the various cell arrays below:

Cell range A1:A8

*

Cell selection A1:F1
*

*

If the columns in your spreadsheet space labeled with numbers instead of letters, you'll need to change the default reference style because that Excel. Evaluation our Extra top top What are reference Styles? to discover how.

To choose a cell:

To input or edit cell content, you'll first need come select the cell.

Click a cell to pick it. In ours example, we'll choose cell D9.A border will show up around the selected cell, and the column heading and also row heading will be highlighted. The cabinet will continue to be selected until you click one more cell in the worksheet.
*

You can additionally select cells using the arrow keys on your keyboard.

To select a cabinet range:

Sometimes you might want to pick a larger team of cells, or a cell range.

Click and also drag the computer mouse until every one of the adjoining cells you want to pick are highlighted. In our example, we'll select the cell variety B5:C18.Release the computer mouse to select the wanted cell range. The cell will stay selected until friend click one more cell in the worksheet.
*

Cell content

Any details you go into into a spreadsheet will certainly be save in a cell. Every cell can contain different species of content, including text, formatting, formulas, and functions.

Text: Cells have the right to contain text, such together letters, numbers, and dates.
Formatting attributes: Cells can contain formatting attributes that change the way letters, numbers, and dates space displayed. Because that example, percentages can show up as 0.15 or 15%. You deserve to even change a cell's text or background color.
Formulas and also functions: Cells have the right to contain formulas and also functions the calculate cell values. In our example, SUM(B2:B8) adds the value of each cell in the cell variety B2:B8 and also displays the complete in cabinet B9.
Type something right into the selected cell, then press Enter on her keyboard. The contents will show up in the cell and the formula bar. Girlfriend can additionally input and edit cell content in the formula bar.
To delete (or clear) cabinet content:Select the cell(s) with content you desire to delete. In our example, we'll select the cell variety A10:H10.

You can also use the Delete key on your key-board to delete contents from multiple cells in ~ once. The Backspace an essential will just delete contents from one cabinet at a time.

To delete cells:

There is vital difference between deleting the contents of a cell and deleting the cabinet itself. If friend delete the whole cell, the cells below it will certainly shift to fill in the gaps and replace the turned off cells.

Select the cell(s) you want to delete. In our example, we'll pick A10:H10.

*

Select the Delete command indigenous the Home tab top top the Ribbon.
To copy and also paste cell content:

Excel permits you to copy contents that is currently entered into your spreadsheet and also paste that content to other cells, which can save you time and effort.

Select the cell(s) you desire to copy. In our example, we'll select F9.
Select the cell(s) where you desire to paste the content. In ours example, we'll select F12:F17. The replicated cell(s) will have actually a dashed box around them.
To access more paste options:

You deserve to also access additional dough options, which are especially convenient once working through cells the contain formulas or formatting. Simply click the drop-down arrowhead on the paste command to see these options.


Instead of choosing commands indigenous the Ribbon, you can accessibility commands quickly by right-clicking. Simply choose the cell(s) you desire to format, then right-click the mouse. A drop-down menu will certainly appear, whereby you'll uncover several commands that are likewise located on the Ribbon.


To cut and paste cabinet content:

Unlike copying and pasting, i beg your pardon duplicates cell content, cutting allows you come move content in between cells.

Select the cell(s) you want to cut. In ours example, we'll choose G5:G6.Right-click the mouse and also select the Cut command. Alternatively, you can use the command ~ above the Home tab, or push Ctrl+X on your keyboard.
Select the cells wherein you want to paste the content. In our example, we'll pick F10:F11. The cut cells will certainly now have a dashed box around them. Right-click the mouse and select the Paste command. Alternatively, you can use the command on the Home tab, or press Ctrl+V on your keyboard.
To drag and drop cells:

Instead that cutting, copying, and also pasting, you deserve to drag and drop cells to move their contents.

Select the cell(s) you desire to move. In our example, we'll select H4:H12.Hover the computer mouse over the border of the selected cell(s) till the mouse alters to a pointer with 4 arrows.
To use the to fill handle:

If you're copying cell contents to nearby cells in the exact same row or column, the fill handle is a good alternative to the copy and paste commands.

Select the cell(s) comprise the contents you want to use, then hover the mouse over the lower-right edge of the cabinet so the fill handle appears.
Click and also drag the fill handle until all of the cells you want to fill are selected. In ours example, we'll select G13:G17.
To proceed a collection with the fill handle:

The fill take care of can likewise be provided to continue a series. At any time the content of a heat or column complies with a sequential order, favor numbers (1, 2, 3) or days (Monday, Tuesday, Wednesday), the to fill handle can guess what have to come next in the series. In many cases, friend will need to select multiple cells before using the fill handle to aid Excel identify the series order. Let's take it a look in ~ an example:

Select the cell range that has the collection you desire to continue. In our example, we'll select E4:G4.Click and also drag the fill manage to continue the series.
Release the mouse. If Excel taken the series, it will be continued in the selected cells. In ours example, Excel added Part 4, Part 5, and Part 6 come H4:J4.

You can additionally double-click the to fill handle instead of clicking and dragging. This can be valuable with bigger spreadsheets, where clicking and dragging might be awkward.

Watch the video below to see an example of double-clicking the fill handle.


Challenge!

Select cabinet D6 and form hlee.

See more: How Would You Describe The Color Red To A Blind Person ? Could You Describe 'Red' To A Blind Person

Clear the contents in heat 14.Delete pillar G.Using either cut and also paste or drag and also drop, relocate the components of row 18 to row 14.Use the fill handle to put an X in cells F9:F17.When you're finished, your workbook have to look choose this: