Still Before You Begin

A good administrator makes a COPY of the data before manipulating it.

2. Try This: Copy the Spreadsheet
Go to Home -> Cells -> Format.

Click on Move or Copy Sheet.

A new sheet will be inserted.

 

3. Try This: Rename the Worksheet

Click on the Original Data (2) tab.

Go to Home -> Cells -> Format.

Click on Rename Sheet.

The Name in the tab should be highlighted. Type:  Data Tables.

Click ENTER on the keyboard.


Keep going...


Memo to Self: You can achieve the same results by right-clicking the tab, as shown.

 

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

graphic1
graphic2

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