facebook google plus twitter
Webucator's Free Introduction to Microsoft Excel 2013 Tutorial

Lesson: Editing Worksheets

Welcome to our free Introduction to Microsoft Excel 2013 tutorial. This tutorial is based on Webucator's Introduction to Microsoft Excel 2013 Training course.

In this lesson, you will learn about editing worksheets.

Lesson Goals

  • Locate information in your worksheet using Find.
  • Use Find and Replace to quickly replace data with other data.
  • Use the Cut, Copy, Paste, and Format Painter commands to edit worksheets.

Find

Use the Find command to find instances of words or numbers within a worksheet. To use the Find command:

  1. On the HOME tab, in the Editing group, click the Find & Select command and then select Find:Find Under the Find and Select Command
  2. Type the word or number you wish to find in the Find and Replace dialog box and press Enter:Find and Replace Dialog Box
  3. Press Enter repeatedly to circle through the instances of the word or number you are searching for.
  4. Click Close to close the Find and Replace dialog box:Find and Replace Dialog Box

Find and Replace

Use the Replace command to find instances of words or numbers within a worksheet and replace them with other words or numbers. To use the Replace command:

  1. On the HOME tab, in the Editing group, click the Find & Select command and then select Replace:Select Replace Under Find and Select Command
  2. In the Find and Replace dialog box that appears, enter both the word or number you wish to find and the word or number you wish to replace it with.
  3. Click:
    1. Replace to replace the highlighted selection.
    2. Replace All to replace all search results with the new text.
    3. Find Next to leave the highlighted selection as is and highlight the next search result.
    4. Find All to see a list of the instances of the word or number in your worksheet.
    5. Close to discontinue the search. Find and Replace Search Box

Using Find and Replace

Duration: 5 to 10 minutes.

In this exercise you will find and replace text in a worksheet.

  1. Continue working in the workbook from the last exercise or open Dave's Lemonade Stand - Using Find and Replace.xlsx from your Excel2013.1/Exercises folder.
  2. Use Find and Replace to change the word "Payroll" to "Employees".

Solution:

  1. Open or go to the specified file.
  2. From the Editing group on the HOME tab, select Find & Select and select Replace:Replace Command Under Find and Select
  3. In the dialog box, enter:
    1. Find what: "Payroll"
    2. Replace with: "Employees"
  4. Click Replace All:Find and Replace Dialog Box
  5. Click OK.

Using the Clipboard

The Clipboard group, located on the HOME tab, contains four commands:

  1. Cut. Use the Cut command to cut a selection from your document. The cut selection is saved on the Clipboard for use elsewhere - either in the current workbook or another one (or even in a separate application like Microsoft Word).
  2. Copy. Use the Copy command to copy a selection to the Clipboard for use elsewhere - either in the current workbook or another one (or even in a separate application like Microsoft Word).
  3. Paste. Use the Paste command to paste a selection from the Clipboard to the location in your workbook where you want it.
  4. Format Painter. Use the Format Painter to copy the format from one section of your workbook and apply it to another section of your workbook.
    1. Single-click the Format Painter command to copy the format for a single paste.
    2. Double-click the Format Painter command to make it "sticky" so you can apply the format to multiple selections.

Clipboard

Using the Clipboard

Duration: 5 to 10 minutes.

In this exercise, you will use the clipboard to cut, copy, paste and format cells.

  1. Open Clipboard exercise.xlsx from your Excel2013.1/Exercises folder.
  2. Use the clipboard to:
    1. Copy cell A1 to cell C1.
    2. Cut cell A2 and paste it in cell C2.
    3. Copy the format of cell A3 to cell C3.

Solution:

  1. Select cell A1 and on the HOME tab, in the Clipboard group, click Copy:Copy to Clipboard
  2. Select cell C1 and on the HOME tab, in the Clipboard group, click Paste:Paste Data
  3. Select cell A2 and on the HOME tab, in the Clipboard group, click Cut:Cut Data to Clipboard
  4. Select cell C2 and on the HOME tab, in the Clipboard group, click Paste:Paste Data
  5. Select cell A3 and on the HOME tab, in the Clipboard group, click Format Painter:Select Format Painter
  6. Select cell C3:Format Cell

Managing Comments

You can add comments to worksheets and manage them in Excel using the Comments group of the REVIEW tab of the Ribbon.

Adding Comments

To add a comment in Excel:

  1. Click where you want to add the comment.
  2. From the REVIEW tab, in the Comments group, select New Comment. New Comment in Comments Group of Review Tab
  3. Type your comment. Typed Comment
  4. You will notice that Excel alerts you to the fact that there is an inserted comment with a triangular icon. New Comment Triangular Icon

Working with Comments

To work with comments in Excel, use the options on the REVIEW tab, in the Comments group:

  1. To move through the comments, select the Previous and Next options. Previous and Next Options
  2. To delete a comment that is selected, select Delete. Delete Comment
  3. To show or hide the text of a comment, select Show/Hide Comment. Show or Hide Comment
  4. To show the text of all comments, select Show All Comments. Show All Comments