Copy the Spreadsheet

OK, that takes care of the eggs. Let’s name the spreadsheet and move on.

 

1. Rename the Spreadsheet

Double click the Sheet1 tab.

Type: Eggs

2. Copy the Spreadsheet

Right mouse click the “Eggs” label.

Select Move or Copy.

 

3. Check Create a copy.
Click
OK to close the Move or Copy window.

4. What Do You See? There should be a new sheet called Eggs (2).

 

Memo to Self: This method copied everything: labels, data, and formulas.

Saves time, doesn’t it?

Exam 77-420 Microsoft Excel 2013
1. Create and Manage Worksheets and Workbooks
1.1 Create Worksheets and Workbooks: Copy and Move Worksheets

pic2


graphic1
graphic2
graphic3