Exam 77-882: Microsoft Excel 2010 Core

4. Managing Worksheets and Workbooks

 4.1. Create and format worksheets: Move or Copy Sheet

Home -> Cells -> Format->Move or Copy Sheet

Worksheets: Move

Move or Copy are on the same page. Here are the steps.

 

2. Try This: Move a Worksheet

Click on the Sparklines 2 tab.

Go to Home -> Cells -> Format.

Click on Move or Copy Sheet.

 

What Do You See? A little window will prompt you to Move selected sheet. In the example on this page the Sparklines 2 sheet will be placed before the Sales Subtotal by Rep sheet.

 

What Else Do You see? You could use this method to Move or Copy a sheet to a different Excel workbook.

 

Memo to Self: You can also Move the sheet by left-clicking and holding the tab. The cursor will follow your mouse as you move across the tabs. When you let go of the mouse, the page will be placed there.