Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?

Lesson 7: Cell Basics

/en/excel2013/saving-and-sharing-workbooks/content/

Introduction

Whenever you work with Excel, you'll enter information—or content—into cells. Cells are the basic building blocks of a worksheet. You'll need to learn the basics of cells and cell content to calculate, analyze, and organize data in Excel.


Optional: Download our practice workbook.

Understanding cells

Every worksheet is made up of thousands of rectangles, which are called cells. A cell is the intersection of a row and a column. Columns are identified by letters (A, B, C), while rows are identified by numbers (1, 2, 3).

Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?
A cell

Each cell has its own name—or cell address—based on its column and row. In this example, the selected cell intersects column C and row 5, so the cell address is C5. The cell address will also appear in the Name box. Note that a cell's column and row headings are highlighted when the cell is selected.

Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?
Cell C5

You can also select multiple cells at the same time. A group of cells is known as a cell range. Rather than a single cell address, you will refer to a cell range using the cell addresses of the first and last cells in the cell range, separated by a colon. For example, a cell range that included cells A1, A2, A3, A4, and A5 would be written as A1:A5.

In the images below, two different cell ranges are selected:

  • Cell range A1:A8

    Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?
    Cell range A1:A8

  • Cell range A1:B8

    Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?
    Cell range A1:B8

If the columns in your spreadsheet are labeled with numbers instead of letters, you'll need to change the default reference style for Excel. Review our Extra on What are Reference Styles? to learn how.

To select a cell:

To input or edit cell content, you'll first need to select the cell.

  1. Click a cell to select it.
  2. A border
    Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?
    will appear around the selected cell, and the column heading and row heading will be highlighted. The cell will remain selected until you click another cell in the worksheet.

    Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?
    Selecting a single cell

You can also select cells using the arrow keys on your keyboard.

To select a cell range:

Sometimes you may want to select a larger group of cells, or a cell range.

  1. Click, hold, and drag the mouse until all of the adjoining cells you want to select are highlighted.
  2. Release the mouse to select the desired cell range. The cells will remain selected until you click another cell in the worksheet.

    Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?
    Selecting a cell range

Cell content

Any information you enter into a spreadsheet will be stored in a cell. Each cell can contain different types of content, including text, formatting, formulas, and functions.

  • Text
    Cells can contain text, such as letters, numbers, and dates.

    Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?
    Cell text

  • Formatting attributes
    Cells can contain formatting attributes that change the way letters, numbers, and dates are displayed. For example, percentages can appear as 0.15 or 15%. You can even change a cell's background color.

    Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?
    Cell formatting

  • Formulas and functions
    Cells can contain formulas and functions that calculate cell values. In our example, SUM(B2:B8) adds the value of each cell in cell range B2:B8 and displays the total in cell B9.

    Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?
    Cell formulas

To insert content:

  1. Click a cell to select it.

    Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?
    Selecting cell A1

  2. Type content into the selected cell, then press Enter on your keyboard. The content will appear in the cell and the formula bar. You can also input and edit cell content in the formula bar.

    Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?
    Inserting cell content

To delete cell content:

  1. Select the cell with content you want to delete.

    Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?
    Selecting a cell

  2. Press the Delete or Backspace key on your keyboard. The cell's contents will be deleted.

    Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?
    Deleting cell content

You can use the Delete key on your keyboard to delete content from multiple cells at once. The Backspace key will only delete one cell at a time.

To delete cells:

There is an important difference between deleting the content of a cell and deleting the cell itself. If you delete the entire cell, the cells below it will shift up and replace the deleted cells.

  1. Select the cell(s) you want to delete.

    Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?
    Selecting a cell to delete

  2. Select the Delete command from the Home tab on the Ribbon.

    Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?
    Clicking the Delete command

  3. The cells below will shift up.

    Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?
    Cells shifted to replace the deleted cell

To copy and paste cell content:

Excel allows you to copy content that is already entered into your spreadsheet and paste that content to other cells, which can save you time and effort.

  1. Select the cell(s) you want to copy.

    Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?
    Selecting a cell to copy

  2. Click the Copy command on the Home tab, or press Ctrl+C on your keyboard.

    Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?
    Clicking the Copy command

  3. Select the cell(s) where you want to paste the content. The copied cells will now have a dashed box around them.

    Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?
    Pasting cells

  4. Click the Paste command on the Home tab, or press Ctrl+V on your keyboard.

    Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?
    Clicking the Paste command

  5. The content will be pasted into the selected cells.

    Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?
    The pasted cell content

To cut and paste cell content:

Unlike copying and pasting, which duplicates cell content, cutting allows you to move content between cells.

  1. Select the cell(s) you want to cut.

    Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?
    Selecting a cell range to cut

  2. Click the Cut command on the Home tab, or press Ctrl+X on your keyboard.

    Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?
    Clicking the Cut command

  3. Select the cells where you want to paste the content. The cut cells will now have a dashed box around them.

    Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?
    Pasting cells

  4. Click the Paste command on the Home tab, or press Ctrl+V on your keyboard.

    Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?
    Clicking the Paste command

  5. The cut content will be removed from the original cells and pasted into the selected cells.

    Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?
    The cut and pasted cells

To access more paste options:

You can also access additional paste options, which are especially convenient when working with cells that contain formulas or formatting.

  • To access more paste options, click the drop-down arrow on the Paste command.

Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?
Additional Paste options

Rather than choose commands from the Ribbon, you can access commands quickly 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 find several commands that are also located on the Ribbon.

Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?
Right-clicking to access formatting options

To drag and drop cells:

Rather than cutting, copying, and pasting, you can drag and drop cells to move their contents.

  1. Select the cell(s) you want to move.
  2. Hover the mouse over the border of the selected cell(s) until the cursor changes from a white cross
    Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?
    to a black cross with four arrows
    Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?
    .

    Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?
    Hovering over the cell border

  3. Click, hold, and drag the cells to the desired location.

    Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?
    Dragging the selected cells

  4. Release the mouse, and the cells will be dropped in the selected location.

    Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?
    The dropped cells

To use the fill handle:

There may be times when you need to copy the content of one cell to several other cells in your worksheet. You could copy and paste the content into each cell, but this method would be time consuming. Instead, you can use the fill handle to quickly copy and paste content to adjacent cells in the same row or column.

  1. Select the cell(s) containing the content you want to use. The fill handle will appear as a small square in the bottom-right corner of the selected cell(s).

    Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?
    Locating the fill handle

  2. Click, hold, and drag the fill handle until all of the cells you want to fill are selected.

    Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?
    Dragging the fill handle

  3. Release the mouse to fill the selected cells.

    Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?
    The filled cells

To continue a series with the fill handle:

The fill handle can also be used to continue a series. Whenever the content of a row or column follows a sequential order, like numbers (1, 2, 3) or days (Monday, Tuesday, Wednesday), the fill handle can guess what should come next in the series. In many cases, you may need to select multiple cells before using the fill handle to help Excel determine the series order. In our example below, the fill handle is used to extend a series of dates in a column.

Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?
Using the fill handle to extend a series

Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?
The extended series

You can also double-click the fill handle instead of clicking and dragging. This can be useful with larger spreadsheets, where clicking and dragging may be awkward.

Watch the video below to see an example of double-clicking the fill handle.

To use Flash Fill:

A new feature in Excel 2013, Flash Fill can enter data automatically into your worksheet, saving you time and effort. Just like the fill handle, Flash Fill can guess what type of information you're entering into your worksheet. In the example below, we'll use Flash Fill to create a list of first names using a list of existing email addresses.

  1. Enter the desired information into your worksheet. A Flash Fill preview will appear below the selected cell whenever Flash Fill is available.

    Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?
    Previewing Flash Fill data

  2. Press Enter. The Flash Fill data will be added to the worksheet.

    Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?
    The entered Flash Fill data

To modify or undo Flash Fill, click the Flash Fill button next to recently added Flash Fill data.

Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?
Clicking the Flash Fill button

Find and Replace

When working with a lot of data in Excel, it can be difficult and time consuming to locate specific information. You can easily search your workbook using the Find feature, which also allows you to modify content using the Replace feature.

To find content:

In our example, we'll use the Find command to locate a specific name in a long list of employees.

  1. From the Home tab, click the Find and Select command, then select Find... from the drop-down menu.

    Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?
    Clicking the Find command

  2. The Find and Replace dialog box will appear. Enter the content you want to find. In our example, we'll type the employee's name.
  3. Click Find Next. If the content is found, the cell containing that content will be selected.

    Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?
    Clicking Find Next

  4. Click Find Next to find further instances or Find All to see every instance of the search term.

    Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?
    Clicking Find All

  5. When you are finished, click Close to exit the Find and Replace dialog box.

    Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?
    Closing the Find and Replace dialog box

You can also access the Find command by pressing Ctrl+F on your keyboard.

Click Options to see advanced search criteria in the Find and Replace dialog box.

Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?
Clicking Options

To replace cell content:

At times, you may discover that you've repeatedly made a mistake throughout your workbook (such as misspelling someone's name), or that you need to exchange a particular word or phrase for another. You can use Excel's Find and Replace feature to make quick revisions. In our example, we'll use Find and Replace to correct a list of email addresses.

  1. From the Home tab, click the Find and Select command, then select Replace... from the drop-down menu.

    Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?
    Clicking the Replace command

  2. The Find and Replace dialog box will appear. Type the text you want to find in the Find what: field.
  3. Type the text you want to replace it with in the Replace with: field, then click Find Next.

    Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?
    Clicking Find Next

  4. If the content is found, the cell containing that content will be selected.
  5. Review the text to make sure you want to replace it.
  6. If you want to replace it, select one of the replace options:
    • Replace will replace individual instances.
    • Replace All will replace every instance of the text throughout the workbook. In our example, we'll choose this option to save time.

    Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?
    Replacing the highlighted text

  7. A dialog box will appear, confirming the number of replacements made. Click OK to continue.

    Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?
    Clicking OK

  8. The selected cell content will be replaced.

    Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?
    The replaced content

  9. When you are finished, click Close to exit the Find and Replace dialog box.

    Do you have selected a cell with the formula Which of the following can you use to copy the formula to an adjacent cell?
    Closing the Find and Replace dialog box

Challenge!

  1. Open an existing Excel 2013 workbook. If you want, you can use our practice workbook.
  2. Select cell D3. Notice how the cell address appears in the Name box and its content appears in both the cell and the Formula bar.
  3. Select a cell, and try inserting text and numbers.
  4. Delete a cell, and note how the cells below shift up to fill in its place.
  5. Cut cells and paste them into a different location. If you are using the example, cut cells D4:D6 and paste them to E4:E6.
  6. Try dragging and dropping some cells to other parts of the worksheet.
  7. Use the fill handle to fill in data to adjoining cells both vertically and horizontally. If you are using the example, use the fill handle to continue the series of dates across row 3.
  8. Use the Find feature to locate content in your workbook. If you are using the example, type the name Lewis into the Find what: field.

/en/excel2013/modifying-columns-rows-and-cells/content/

Input your formula in one cell, and press Ctrl + Enter instead of Enter. That's it! The formula will get copied to all of the selected cells, and Excel will adjust relative cell references accordingly.

What is use to quickly copy and paste content to adjacent cells in the same row or column?

To use the fill handle: Instead, you can use the fill handle to quickly copy and paste content to adjacent cells in the same row or column. Select the cell(s) containing the content you want to use. The fill handle will appear as a small square in the bottom-right corner of the selected cell(s).

Which of the technique is used to copy a function or formula easily to the next cell?

You can quickly copy formulas into adjacent cells by using the fill handle. When you drag the handle to other cells, Excel will show different results for each cell.

How do you use the value of a cell with a formula in another cell?

Use cell references in a formula.
Click the cell in which you want to enter the formula..
In the formula bar. , type = (equal sign)..
Do one of the following, select the cell that contains the value you want or type its cell reference. ... .
Press Enter..