Webucator's Free Introduction to Microsoft Excel Tutorial
Lesson: Editing Worksheets
Welcome to our free Introduction to Microsoft Excel tutorial. This tutorial is based on Webucator's Introduction to Microsoft Excel 2019 Training course.
In this lesson, you will learn how to edit Excel worksheets.
Lesson Goals
- Learn to locate information in your worksheet using Find.
- Learn to use Find and Replace to quickly replace data with other data.
- Learn to use the Cut, Copy, Paste and Format Painter commands to edit worksheets.
- Learn to manage comments.
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:
- On the Home tab, in the Editing group, click the Find & Select
command and then select Replace:
- 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.
- Click:
-
Replace to replace the highlighted selection.
-
Replace All to replace all search results with the new text.
-
Find Next to leave the highlighted selection as is and highlight the next search result.
-
Find All to see a list of the instances of the word or number in your worksheet.
-
Close to discontinue the search.
Using Find and Replace
Duration: 5 to 10 minutes.
In this exercise you will find and replace text in a worksheet.
- Continue working in the workbook from the last exercise or open Dave's Lemonade Stand - Using Find and Replace.xlsx from your Excel2019.1/Exercises folder.
- Use Find and Replace to change the word "Payroll" to "Employees".
Using the Clipboard
The Clipboard group, located on the Home tab, contains four commands:
-
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).
-
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).
-
Paste. Use the Paste command to paste a selection from the Clipboard to the location in your workbook where you want it.
-
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.
- Single-click the Format Painter command to copy the format for a single paste.
- Double-click the Format Painter command to make it "sticky" so you can apply the format to multiple selections.
Using the Clipboard
Duration: 5 to 10 minutes.
In this exercise, you will use the clipboard to cut, copy, paste and format cells.
- Open Clipboard exercise.xlsx from your Excel2019.1/Exercises folder.
- Use the clipboard to:
- Copy cell A1 to cell C1.
- Cut cell A2 and paste it in cell C2.
- Copy the format of cell A3 to cell C3.
Using Format Painter
Duration: 5 to 10 minutes.
In this exercise, you will use Format Painter.
- Open Clipboard Format Painter exercise.xlsx from your Excel2019.1/Exercises folder if it is not already open.
- Use Format Painter to:
- Copy the text color of cell A4 to cell C4.
- Copy the background color of cell A5 to cell C5.