Lesson 4: Managing an Excel Worksheet

In this lesson, you will learn how to use the Undo and Redo buttons. You will also learn the use of Cut, Copy and Paste commands.

Objectives

  • Discuss the meaning of spreadsheet and the history
  • Describe MS Excel, including the window and the elements

Section 4.1 - Using the Undo and Redo Buttons

As you are entering a recent data type on the worksheet, you may find that you have to cancelor correct a mistake. The Undo function allows you to reverse the command or action. While the Redo function allows you to restore a previous action.

  1. To display the Undo and Redo buttons on the Quick Access Toolbar, click the drop down arrow and check the Undo and Redo commands.
  2. Click the Undo button to reverse a command and the Redo button to restore a previous action.

Watch video tutorial

Section 4.2 - Using Cut, Copy and Paste Commands

You can cut, copy and paste values, texts, formats, formulas worksheets and graphic objects in your worksheet or workbook. You can also within Excel or between Excel and another Windows application. The cut or copied content will be temporarily stored in a "Clipboard".

There are two ways on how to cut, copy and paste contents; (A) By using the Clipboard Group, (B) By using Context Menu.

By using the Clipboard Group

  1. Step 1. Select or highlight the cell or range of cells you want to copy or cut.
  2. Step 2. Click the Home tab, got to the Clipboard group and click the Copy or Cut button.
  3. Step 3. Go to the cell where you want to place your cut or copied data.
  4. Step 4. On the Clipboard group, click the Paste button.

By using the Context Menu

  1. Step 1. Select the cell or range of cells you want to copy or cut.
  2. Step 2. Right click the mouse to show the Mini toolbar and Context menu.
  3. Step 3. Click Cut or Copy command from the menu.
  4. Step 4. Click on the cell where you want the data to be placed and right click the mouse.
  5. Step 5. On the Context menu, click Paste command.