Whenever you work-related with Excel, you'll enter information—or content—into cells. Cells room the straightforward building block of a worksheet. You'll need to find out the basics the cells and also cell content to calculate, analyze, and also organize data in Excel.
You are watching: The intersection of a row and a column is called
Optional: Download our practice workbook.
Watch the video clip below to learn more about the basics the working v cells.
Every worksheet is consisted of of countless rectangles, which are referred to as cells. A cabinet is the intersection that a row and a column—in other words, whereby a row and also column meet.
Columns are figured out by letters (A, B, C), when rows are established by numbers (1, 2, 3). Each cell has its very own name—or cell address—based on its column and also row. In the instance below, the selected cell intersects column C and also row 5, so the cell deal with is C5.
Note the the cell deal with also shows up in the Name box in the top-left corner, and also that a cell's column and row headings are highlighted when the cabinet is selected.
You can additionally select multiple cells at the same time. A group of cells is known as a cell range. Rather than a solitary cell address, friend will describe a cell variety using the cabinet addresses the the first and last cells in the cell range, be separated by a colon. Because that example, a cell selection that contained cells A1, A2, A3, A4, and also A5 would certainly be written as A1:A5. Take a look at the different cell ranges below:Cell variety A1:A8
If the columns in your spreadsheet room labeled with numbers rather of letters, you'll require to readjust the default reference style because that Excel. Review our Extra on What are referral Styles? to learn how.To choose a cell:
To intake or modify cell content, you'll very first need come select the cell.Click a cell to choose it. In ours example, we'll pick cell D9.A border will appear around the selected cell, and the column heading and row heading will be highlighted. The cabinet will stay selected until you click another cell in the worksheet.
You can likewise select cells making use of the arrow keys on her keyboard.To pick 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 want to pick are highlighted. In our example, we'll pick the cell variety B5:C18.Release the computer mouse to select the wanted cell range. The cell will continue to be selected until you click one more cell in the worksheet.
Any information you get in into a spreadsheet will certainly be save on computer in a cell. Each cell can contain different species of content, consisting of text, formatting, formulas, and functions.Text: Cells can contain text, such as letters, numbers, and dates.
Formatting attributes: Cells can contain formatting attributes that adjust the way letters, numbers, and also dates space displayed. Because that example, percentages can show up as 0.15 or 15%. You can even change a cell's text or background color.
Formulas and also functions: Cells can contain formulas and also functions that calculate cell values. In our example, SUM(B2:B8) adds the worth of every cell in the cell variety B2:B8 and displays the full in cell B9.
Type something right into the selected cell, then press Enter on her keyboard. The contents will appear in the cell and the formula bar. You can additionally input and edit cell contents in the formula bar.
To delete (or clear) cell content:Select the cell(s) through content you want to delete. In our example, we'll pick the cell range A10:H10.
You can also use the Delete crucial on your key-board to delete contents from multiple cells at once. The Backspace an essential will just delete contents from one cabinet at a time.To delete cells:
There is crucial difference in between deleting the contents of a cell and also deleting the cabinet itself. If friend delete the entire cell, the cells below it will shift to to fill in the gaps and replace the deleted cells.Select the cell(s) you desire to delete. In ours example, we'll select A10:H10.
To copy and also paste cell content:
Excel enables you to copy contents that is already 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 choose F9.
Select the cell(s) where you desire to paste the content. In our example, we'll choose F12:F17. The duplicated cell(s) will have a dashed box approximately them.
To access more paste options:
You can also access additional paste options, i beg your pardon are specifically convenient when working v cells the contain formulas or formatting. Just click the drop-down arrow on the paste command to check out these options.
Instead of choosing commands indigenous the Ribbon, girlfriend can access commands easily by right-clicking. Simply select the cell(s) you want to format, climate right-click the mouse. A drop-down menu will appear, where you'll uncover several commands the are additionally located ~ above the Ribbon.
To cut and also paste cell content:
Unlike copying and also pasting, i m sorry duplicates cell content, cutting enables you to move content between cells.Select the cell(s) you want to cut. In ours example, we'll select G5:G6.Right-click the mouse and select the Cut command. Alternatively, you can use the command ~ above the Home tab, or press Ctrl+X on her keyboard.
Select the cells whereby you desire to paste the content. In our example, we'll choose F10:F11. The rptcouncil.netced cells will now have actually a dashed box around them. Right-click the mouse and also select the Paste command. Alternatively, you deserve to use the command ~ above the Home tab, or press Ctrl+V on her keyboard.
To drag and also drop cells:
Instead the cutting, copying, and also pasting, you can drag and also drop cell to move their contents.Select the cell(s) you want to move. In our example, we'll choose H4:H12.Hover the computer mouse over the border of the selected cell(s) till the mouse changes to a pointer with 4 arrows.
To use the fill handle:
If you're copy cell content to adjacent cells in the exact same row or column, the fill handle is a good alternative come the copy and also paste commands.Select the cell(s) include the contents you desire to use, then float the mouse over the lower-right edge of the cabinet so the fill handle appears.
Click and drag the fill handle until every one of the cells you desire to fill are selected. In our example, we'll pick G13:G17.
To proceed a series with the to fill handle:
The fill handle can additionally be offered to continue a series. Whenever the content of a row or column follows a sequential order, favor numbers (1, 2, 3) or days (Monday, Tuesday, Wednesday), the fill handle have the right to guess what have to come next in the series. In many cases, girlfriend will need to select multiple cells before using the fill take care of to assist Excel identify the collection order. Let's take a look at an example:Select the cell range that consists of the series you want to continue. In our example, we'll select E4:G4.Click and also drag the fill handle to continue the series.
Release the mouse. If Excel understood the series, it will be ongoing in the selected cells. In our example, Excel added Part 4, Part 5, and Part 6 to H4:J4.
You can likewise double-click the fill handle rather of clicking and also dragging. This can be valuable with bigger spreadsheets, where clicking and dragging might be awkward.
Watch the video clip below come see an instance of double-clicking the fill handle.
Challenge!Select cell D6 and type hlee.
See more: Songs From Sons Of Anarchy Season 7 — Music, Sons Of Anarchy Season 7 Soundtrack
Clear the contents in row 14.Delete tower G.Using either cut and paste or drag and drop, relocate the components of row 18 to heat 14.Use the fill handle to put an X in cells F9:F17.When you're finished, your workbook should look favor this: