Whenever you job-related with Excel, you'll get in information—or content—into cells. Cells are the basic building block of a worksheet. You'll need to learn the basics the cells and also cell content come calculate, analyze, and organize data in Excel.
You are watching: The intersection of a row and a column is called a
Optional: Download our practice workbook.
Watch the video below come learn more about the basics that working with cells.
Every worksheet is made up of countless rectangles, i m sorry are referred to as cells. A cabinet is the intersection of a row and a column—in other words, where a row and also column meet.
Columns are identified by letters (A, B, C), if rows are figured out by numbers (1, 2, 3). Each cell has actually its own name—or cell address—based top top its column and row. In the example below, the selected cabinet intersects column C and row 5, therefore the cell resolve is C5.
Note that the cell resolve also shows up in the Name box in the top-left corner, and that a cell's column and also row headings room highlighted when the cabinet is selected.
You can also select multiple cells at the very same time. A group of cell is recognized as a cell range. Rather than a solitary cell address, you will describe a cell selection using the cabinet addresses that the first and last cell in the cabinet range, be separate by a colon. For example, a cell range that had cells A1, A2, A3, A4, and A5 would be created as A1:A5. Take a look in ~ the different cell arrays below:Cell range A1:A8
If the columns in her spreadsheet room labeled v numbers instead of letters, you'll need to change the default reference style for Excel. Evaluation our Extra on What are recommendation Styles? to discover how.To select a cell:
To intake or modify cell content, you'll very first need come select the cell.Click a cell to choose it. In our example, we'll select cell D9.A border will show up around the selected cell, and also the column heading and also row heading will be highlighted. The cell will remain selected till you click one more cell in the worksheet.
You can also select cells making use of the arrow keys on her keyboard.To choose a cell range:
Sometimes you might want to choose a larger team of cells, or a cell range.Click and also drag the mouse until all of the adjoining cells you desire to select are highlighted. In our example, we'll pick the cell range B5:C18.Release the computer mouse to select the preferred cell range. The cell will stay selected until friend click an additional cell in the worksheet.
Any info you enter into a spreadsheet will be stored in a cell. Every cell have the right to contain different varieties of content, including text, formatting, formulas, and also functions.Text: Cells deserve to contain text, such together letters, numbers, and dates.
Formatting attributes: Cells deserve to contain formatting attributes that change the means letters, numbers, and dates are displayed. Because that example, percentages can appear as 0.15 or 15%. You deserve to even change a cell's text or background color.
Formulas and functions: Cells have the right to contain formulas and functions the calculate cell values. In our example, SUM(B2:B8) adds the value of each cell in the cell variety B2:B8 and displays the total in cabinet B9.
Type something right into the selected cell, then press Enter on her keyboard. The content will show up in the cell and the formula bar. You can additionally input and also edit cell contents in the formula bar.
To delete (or clear) cabinet content:Select the cell(s) with content you want to delete. In ours example, we'll pick the cell selection A10:H10.
You can likewise use the Delete vital on your key-board to delete contents from multiple cells at once. The Backspace vital will just delete contents from one cabinet at a time.To delete cells:
There is an important difference in between deleting the contents of a cell and also deleting the cell itself. If you delete the whole cell, the cells listed 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 select A10:H10.
To copy and paste cell content:
Excel enables you to copy content that is already entered into your spreadsheet and paste that content to other cells, which can save girlfriend time and effort.Select the cell(s) you want to copy. In ours example, we'll pick F9.
Select the cell(s) where you desire to paste the content. In our example, we'll pick F12:F17. The replicated cell(s) will have a dashed box about them.
To access much more paste options:
You have the right to also access additional paste options, i m sorry are specifically convenient as soon as working with cells that contain recipe or formatting. Just click the drop-down arrow on the paste command to watch these options.
Instead of selecting commands indigenous the Ribbon, girlfriend can access commands easily by right-clicking. Simply pick the cell(s) you want to format, then right-click the mouse. A drop-down menu will certainly appear, wherein you'll discover several commands that are likewise located top top the Ribbon.
To cut and paste cabinet content:
Unlike copying and also pasting, i beg your pardon duplicates cabinet content, cutting permits you come move content in between cells.Select the cell(s) you want to cut. In our 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 on the Home tab, or push Ctrl+X on her keyboard.
Select the cells where you desire to paste the content. In our example, we'll select F10:F11. The reduced cells will 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 push Ctrl+V on her keyboard.
To drag and drop cells:
Instead the cutting, copying, and also pasting, you have the right to drag and drop cell to move their contents.Select the cell(s) you desire to move. In ours example, we'll choose H4:H12.Hover the mouse over the border of the selected cell(s) until the mouse transforms to a pointer with four arrows.
To usage the to fill handle:
If you're copy cell contents to adjacent cells in the very same row or column, the fill handle is a good alternative to the copy and also paste commands.Select the cell(s) containing the contents you desire 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 desire to fill are selected. In our example, we'll choose G13:G17.
To continue a series with the fill handle:
The fill take care of can additionally be provided to continue a series. Whenever the content of a row or column complies with a sequential order, prefer numbers (1, 2, 3) or days (Monday, Tuesday, Wednesday), the to fill handle can guess what have to come following in the series. In most cases, girlfriend will require to choose multiple cells before using the fill take care of to help Excel recognize the collection order. Let's take a look in ~ an example:Select the cell selection that has the series you want to continue. In ours example, we'll select E4:G4.Click and drag the fill manage to continue the series.
Release the mouse. If Excel interpreted the series, it will certainly be continued in the selected cells. In our 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 beneficial with bigger spreadsheets, whereby clicking and also dragging might be awkward.
Watch the video clip below come see an example of double-clicking the fill handle.
Challenge!Select cabinet D6 and type hlee.
See more: Are All Quadrilaterals Are Rectangles True Or False , Are All Squares Rectangles, True Or False
Clear the contents in row 14.Delete column G.Using one of two people cut and paste or drag and drop, move the components of row 18 to heat 14.Use the fill handle to put an X in cells F9:F17.When you're finished, her workbook need to look favor this: