Whenever you occupational with Excel, you'll enter information—or content—into cells. Cells space the basic building blocks of a worksheet. You'll require to find out the basics of cells and cell content come calculate, analyze, and organize data in Excel.
You are watching: In a worksheet, the intersection of a row and a column is called a
Optional: Download our practice workbook.
Watch the video below to learn an ext about the basics of working v cells.
Every worksheet is comprised of hundreds of rectangles, i m sorry are referred to as cells. A cell is the intersection that a row and a column—in various other words, wherein a row and also column meet.
Columns are determined by letters (A, B, C), when rows are determined by numbers (1, 2, 3). Each cell has actually its own name—or cell address—based on its column and row. In the example below, the selected cell intersects column C and row 5, therefore the cell deal with 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 cabinet is selected.
You can likewise select multiple cells in ~ the exact same time. A team of cells is recognized as a cell range. Quite than a solitary cell address, girlfriend will refer to a cell range using the cabinet addresses of the first and last cells in the cell range, be separate by a colon. For example, a cell range that consisted of cells A1, A2, A3, A4, and also A5 would certainly be written as A1:A5. Take a look in ~ the different cell arrays below:Cell variety A1:A8
If the columns in her spreadsheet room labeled with numbers instead of letters, you'll need to adjust the default reference style because that Excel. Evaluation our Extra top top What are referral Styles? to learn how.To select a cell:
To intake or modify cell content, you'll first need come select the cell.Click a cell to select it. In our example, we'll pick cell D9.A border will appear around the selected cell, and also the column heading and also row heading will certainly be highlighted. The cabinet will continue to be selected till you click an additional cell in the worksheet.
You can also select cells making use of the arrow keys on your keyboard.To select a cell range:
Sometimes you might want to choose a larger team of cells, or a cell range.Click and drag the computer mouse until all of the adjoining cells you desire to select are highlighted. In ours example, we'll pick the cell range B5:C18.Release the mouse to select the wanted cell range. The cell will remain selected until girlfriend click one more cell in the worksheet.
Any information you get in into a spreadsheet will certainly be save in a cell. Every cell have the right to contain different species of content, consisting of text, formatting, formulas, and also functions.Text: Cells can contain text, such as letters, numbers, and also dates.
Formatting attributes: Cells can contain formatting attributes that readjust the means letters, numbers, and dates space displayed. For example, percentages can appear as 0.15 or 15%. You can even adjust a cell's text or background color.
Formulas and also functions: Cells can contain formulas and also functions the calculate cabinet values. In ours example, SUM(B2:B8) adds the value of each cell in the cell selection B2:B8 and displays the full in cell B9.
Type something right into the selected cell, then press Enter on your keyboard. The content will appear in the cell and the formula bar. Friend can additionally input and edit cell content in the formula bar.
To delete (or clear) cabinet content:Select the cell(s) with content you want to delete. In our example, we'll pick the cell range A10:H10.
You can also use the Delete vital on your keyboard to delete content from multiple cells in ~ once. The Backspace crucial will just delete contents from one cell at a time.To delete cells:
There is vital difference between deleting the contents of a cell and deleting the cell itself. If girlfriend delete the whole cell, the cells listed below it will 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 select A10:H10.
To copy and paste cell content:
Excel allows you to copy content that is currently entered into your spreadsheet and also paste that content to various other cells, which can save girlfriend time and also effort.Select the cell(s) you want to copy. In ours example, we'll choose F9.
Select the cell(s) where you want to paste the content. In our example, we'll select F12:F17. The replicated cell(s) will have a dashed box about them.
To access an ext paste options:
You have the right to also accessibility additional dough options, i beg your pardon are particularly convenient as soon as working v cells that contain formulas or formatting. Just click the drop-down arrowhead on the dough command to watch these options.
Instead of picking commands from the Ribbon, girlfriend can accessibility commands conveniently by right-clicking. Simply select the cell(s) you desire to format, then right-click the mouse. A drop-down menu will appear, where you'll find several commands that are also located on the Ribbon.
To cut and paste cabinet content:
Unlike copying and also pasting, which duplicates cell content, cutting permits you come move content between cells.Select the cell(s) you want to cut. In our example, we'll pick G5:G6.Right-click the mouse and select the Cut command. Alternatively, you deserve to use the command ~ above the Home tab, or push Ctrl+X on your keyboard.
Select the cells whereby you want to paste the content. In our example, we'll pick F10:F11. The cut cells will certainly now have actually a dashed box around them. Right-click the mouse and also select the Paste command. Alternatively, you have the right to use the command ~ above the Home tab, or push Ctrl+V on your keyboard.
To drag and also drop cells:
Instead the cutting, copying, and pasting, you have the right to drag and also drop cells to relocate their contents.Select the cell(s) you want to move. In our example, we'll select 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 usage the to fill handle:
If you're copy cell contents to surrounding cells in the very same row or column, the fill handle is a great alternative to the copy and also paste commands.Select the cell(s) containing the contents you desire to use, then float the computer mouse over the lower-right edge of the cabinet so the fill handle appears.
Click and drag the fill handle until all of the cell you want to fill space selected. In our example, we'll select G13:G17.
To continue a collection with the fill handle:
The fill handle can also be provided to continue a series. Whenever the contents of a row or column complies with a sequential order, choose numbers (1, 2, 3) or days (Monday, Tuesday, Wednesday), the fill handle can guess what should come next in the series. In many cases, friend will require to pick multiple cells prior to using the fill take care of to help Excel recognize the series order. Let's take it a look at an example:Select the cell range that includes the series you desire 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 construed the series, it will be ongoing in the selected cells. In ours example, Excel added Part 4, Part 5, and Part 6 to H4:J4.
You can additionally double-click the to fill handle rather of clicking and dragging. This deserve to be helpful with larger spreadsheets, whereby clicking and also dragging may be awkward.
Watch the video below to see an instance of double-clicking the fill handle.
Challenge!Select cell D6 and kind hlee.
See more: What Does Kurama Mean In Japanese Meaning For The Name Kurama?
Clear the contents in heat 14.Delete column G.Using one of two people cut and paste or drag and also drop, move the contents of heat 18 to row 14.Use the fill handle to placed an X in cells F9:F17.When you're finished, her workbook must look prefer this: