Whenever you job-related with Excel, you'll enter information—or content—into cells. Cells are the simple building blocks of a worksheet. You'll need to learn the basics of cells and also cell content to calculate, analyze, and also organize data in Excel.
You are watching: A group of selected cells is referred to as a
Optional: Download our practice workbook.
Watch the video clip below to learn much more about the basics that working v cells.
Every worksheet is made up of countless rectangles, i m sorry are referred to as cells. A cabinet is the intersection the a row and a column—in other words, where a row and column meet.
Columns are established by letters (A, B, C), when rows are figured out by numbers (1, 2, 3). Each cell has its very 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 deal with also appears in the Name box in the top-left corner, and that a cell's column and row headings space highlighted when the cell is selected.
You can additionally select multiple cells in ~ the very same time. A team of cells is known as a cell range. Fairly than a single cell address, you will refer to a cell variety using the cell addresses of the first and last cells in the cabinet range, separated by a colon. Because that example, a cell range that contained cells A1, A2, A3, A4, and also A5 would certainly be created as A1:A5. Take it a look in ~ the different cell ranges below:Cell selection A1:A8
If the columns in her spreadsheet space labeled v numbers rather of letters, you'll need to change the default reference style for Excel. Evaluation our Extra on What are referral Styles? to find out how.To choose a cell:
To input or edit cell content, you'll first need to select the cell.Click a cell to pick it. In ours 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 remain selected till you click an additional cell in the worksheet.
You can likewise select cells using the arrow keys on your keyboard.To pick a cell range:
Sometimes you might want to select a larger group of cells, or a cell range.Click and drag the computer mouse until every one of the adjoining cells you desire to select are highlighted. In our example, we'll choose the cell selection B5:C18.Release the computer mouse to select the preferred cell range. The cells will remain selected until girlfriend click one more cell in the worksheet.
Any details you go into into a spreadsheet will be save in a cell. Every cell deserve to contain different varieties of content, including text, formatting, formulas, and functions.Text: Cells deserve to contain text, such as letters, numbers, and dates.
Formatting attributes: Cells have the right to contain formatting attributes that adjust the method letters, numbers, and also dates room displayed. For example, percentages can appear as 0.15 or 15%. You have the right to even readjust a cell's text or background color.
Formulas and functions: Cells have the right to contain formulas and functions the calculate cell values. In ours example, SUM(B2:B8) adds the value of every cell in the cell range B2:B8 and also displays the total in cabinet B9.
Type something into the selected cell, then push Enter on her keyboard. The content will appear in the cell and the formula bar. Girlfriend can additionally input and also edit cell content in the formula bar.
To delete (or clear) cell content:Select the cell(s) with content you want 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 content from multiple cells at once. The Backspace vital will only delete content from one cabinet at a time.To delete cells:
There is an important difference in between deleting the content of a cell and also deleting the cell itself. If girlfriend delete the whole cell, the cells below it will shift 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 paste cell content:
Excel enables you come copy content that is currently entered right into your spreadsheet and also paste that contents to various other cells, which deserve to save friend time and 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 ours example, we'll select F12:F17. The duplicated cell(s) will have actually a dashed box roughly them.
To access an ext paste options:
You can also accessibility additional dough options, which are especially convenient once working through cells that contain recipe or formatting. Just click the drop-down arrowhead on the dough command to watch these options.
Instead of selecting commands native the Ribbon, girlfriend can accessibility commands conveniently by right-clicking. Simply select the cell(s) you want to format, climate right-click the mouse. A drop-down menu will certainly appear, whereby you'll discover several commands that are likewise located on the Ribbon.
To cut and paste cell content:
Unlike copying and also pasting, which duplicates cabinet content, cutting allows you to move content between cells.Select the cell(s) you want to cut. In our example, we'll select G5:G6.Right-click the mouse and select the Cut command. Alternatively, you can use the command on the Home tab, or press Ctrl+X on your keyboard.
Select the cells wherein you want to paste the content. In our example, we'll select F10:F11. The cut cells will now have actually a dashed box around them. Right-click the mouse and select the Paste command. Alternatively, you can use the command ~ above the Home tab, or push Ctrl+V on your keyboard.
To drag and also drop cells:
Instead of cutting, copying, and also pasting, you can drag and drop cell to move their contents.Select the cell(s) you want to move. In our example, we'll choose H4:H12.Hover the mouse over the border of the selected cell(s) until the mouse changes to a pointer with 4 arrows.
To use the to fill handle:
If you're copy cell content to nearby cells in the same row or column, the fill handle is a an excellent alternative to the copy and also paste commands.Select the cell(s) include the contents you want to use, then float the computer mouse over the lower-right corner of the cell so the fill handle appears.
Click and also drag the fill handle until all of the cells you want to fill space selected. In our example, we'll pick G13:G17.
To proceed a series with the to fill handle:
The fill manage can likewise be offered to continue a series. Whenever the contents of a heat or column complies with a sequential order, prefer numbers (1, 2, 3) or days (Monday, Tuesday, Wednesday), the to fill handle can guess what need to come following in the series. In many cases, you will require to select multiple cells prior to using the fill manage to assist Excel recognize the collection order. Let's take a look in ~ an example:Select the cell variety that includes the collection you want to continue. In ours example, we'll select E4:G4.Click and also drag the fill take care of to proceed the series.
Release the mouse. If Excel taken the series, it will be ongoing in the selected cells. In our example, Excel included Part 4, Part 5, and Part 6 to H4:J4.
You can also double-click the fill handle rather of clicking and also dragging. This have the right to be advantageous with larger spreadsheets, where clicking and dragging might be awkward.
Watch the video clip below come see an instance of double-clicking the to fill handle.
Challenge!Select cell D6 and type hlee.
See more: What Is The Post Office Closed On Cesar Chavez Day ? Is Post Office Open On Cesar Chavez Day
Clear the contents in row 14.Delete pillar G.Using one of two people cut and paste or drag and drop, move the contents of heat 18 to heat 14.Use the fill handle to put an X in cell F9:F17.When you're finished, her workbook have to look favor this: