Whenever you occupational with Excel, you'll enter information—or content—into cells. Cells room the an easy building blocks of a worksheet. You'll need to learn the basics of cells and cell content come calculate, analyze, and also organize data in Excel.
You are watching: What is it called when a row and column intersect in a spreadsheet?
Optional: Download our practice workbook.
Watch the video clip below come learn more about the basics that working v cells.
Every worksheet is comprised of hundreds of rectangles, i m sorry are referred to as cells. A cabinet is the intersection that a row and also a column—in various other words, wherein a row and also column meet.
Columns are determined by letters (A, B, C), when rows are identified by numbers (1, 2, 3). Each cell has actually its very own name—or cell address—based on its column and also row. In the example below, the selected cell intersects column C and row 5, therefore the cell attend to is C5.
Note the the cell resolve also shows up in the Name box in the top-left corner, and also that a cell's column and also row headings space highlighted when the cell is selected.
You can additionally select multiple cells in ~ the very same time. A team of cell is known as a cell range. Fairly than a solitary cell address, you will refer to a cell selection using the cell addresses of the first and last cells in the cabinet range, separated by a colon. Because that example, a cell selection that included cells A1, A2, A3, A4, and A5 would be composed as A1:A5. Take it a look at the various cell varieties below:Cell selection A1:A8
If the columns in your spreadsheet room labeled with numbers instead of letters, you'll require to change the default reference style for Excel. Evaluation our Extra top top What are reference Styles? to discover how.To pick a cell:
To entry or modify cell content, you'll an initial need come select the cell.Click a cell to choose it. In our example, we'll pick cell D9.A border will appear around the selected cell, and also the column heading and row heading will be highlighted. The cabinet will stay selected till you click an additional cell in the worksheet.
You can also select cells utilizing the arrow keys on her keyboard.To choose 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 all of the adjoining cells you want to select are highlighted. In our example, we'll choose the cell variety B5:C18.Release the computer mouse to select the desired cell range. The cells will stay selected until you click an additional cell in the worksheet.
Any information you go into into a spreadsheet will certainly be save on computer in a cell. Every cell deserve to contain different varieties of content, consisting of text, formatting, formulas, and also functions.Text: Cells have the right to contain text, such together letters, numbers, and dates.
Formatting attributes: Cells can contain formatting attributes that adjust the way letters, numbers, and also dates room displayed. Because that example, percentages can appear as 0.15 or 15%. You have the right to even adjust a cell's text or background color.
Formulas and also functions: Cells have the right to contain formulas and functions that calculate cabinet values. In our example, SUM(B2:B8) adds the worth of each cell in the cell variety B2:B8 and also displays the total in cell B9.
Type something into the selected cell, then press Enter on her keyboard. The contents will show up in the cell and also the formula bar. Friend can also input and edit cell contents in the formula bar.
To delete (or clear) cell content:Select the cell(s) with content you desire to delete. In our example, we'll pick the cell variety A10:H10.
You can also use the Delete vital on your keyboard to delete contents from multiple cells in ~ once. The Backspace an essential will only delete contents from one cabinet at a time.To delete cells:
There is an essential difference between deleting the contents of a cell and also deleting the cell itself. If you delete the whole cell, the cells below it will certainly shift to to fill in the gaps and replace the deleted cells.Select the cell(s) you want to delete. In our example, we'll pick A10:H10.
To copy and also paste cabinet content:
Excel enables you come copy contents that is already entered right into your spreadsheet and also paste that content to other cells, which can save you time and also effort.Select the cell(s) you want to copy. In ours example, we'll select F9.
Select the cell(s) where you want to paste the content. In our example, we'll choose F12:F17. The replicated cell(s) will have a dashed box about them.
To access more paste options:
You have the right to also accessibility additional paste options, i beg your pardon are especially convenient once working through cells the contain recipe or formatting. Simply click the drop-down arrow on the dough command to view these options.
Instead of picking commands from the Ribbon, friend can accessibility commands easily by right-clicking. Simply select the cell(s) you want to format, then right-click the mouse. A drop-down menu will appear, where you'll uncover several commands the are likewise located on the Ribbon.
To cut and paste cabinet content:
Unlike copying and also pasting, i m sorry duplicates cabinet content, cutting enables you come move content between cells.Select the cell(s) you desire to cut. In ours example, we'll choose G5:G6.Right-click the mouse and also select the Cut command. Alternatively, you have the right to use the command top top the Home tab, or push Ctrl+X on your keyboard.
Select the cells whereby you want to paste the content. In ours example, we'll pick F10:F11. The reduced cells will now have a dashed box around them. Right-click the mouse and also select the Paste command. Alternatively, you have the right to use the command on the Home tab, or push Ctrl+V on your keyboard.
To drag and also drop cells:
Instead that cutting, copying, and also pasting, you deserve to drag and also drop cells to move their contents.Select the cell(s) you desire to move. In ours example, we'll choose H4:H12.Hover the computer mouse over the border of the selected cell(s) until the mouse alters to a pointer with four arrows.
To use the fill handle:
If you're copy cell contents to nearby cells in the exact same row or column, the fill handle is a great alternative to the copy and also paste commands.Select the cell(s) include the content you want to use, then float the mouse over the lower-right edge of the cell so the fill handle appears.
Click and also drag the fill handle until every one of the cell you want to fill space selected. In our example, we'll choose G13:G17.
To continue a series with the to fill handle:
The fill manage can also be used to continue a series. Anytime the content of a row or column adheres to a sequential order, favor numbers (1, 2, 3) or days (Monday, Tuesday, Wednesday), the to fill handle deserve to guess what should come next in the series. In many cases, you will require to choose multiple cells before using the fill take care of to aid Excel identify the collection order. Let's take it a look in ~ an example:Select the cell range that consists of the series you want to continue. In ours example, we'll select E4:G4.Click and also drag the fill handle to proceed the series.
Release the mouse. If Excel understood the series, it will be continued in the selected cells. In our example, Excel added Part 4, Part 5, and also Part 6 to H4:J4.
You can likewise double-click the to fill handle rather of clicking and dragging. This deserve to be beneficial with larger spreadsheets, wherein clicking and dragging might be awkward.
Watch the video below come see an instance of double-clicking the to fill handle.
Challenge!Select cabinet D6 and form hlee.
See more: Who Plays Angie In Diary Of A Wimpy Kid Movie, Angie Steadman
Clear the contents in row 14.Delete pillar G.Using one of two people 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 cell F9:F17.When you're finished, your workbook must look prefer this: