View: New Window

Say your Excel workbook has a two or more spreadsheets that you are working on. You can open any spreadsheet in a New Window.

 

Before You Begin:

Open the sample file: Checkbook 2013.

This workbook has two spreadsheets: Checkbook and Salary.

 

1. Try This: View in a New Window

Select a spreadsheet: Salary.

Go to View->Window.

Click on Open in New Window.

 

What Do You See? In this screenshot on this page, the Salary spreadsheet opened in a New Window. The name is displayed as CheckBook 2013: 2, indicating that is a second copy, or view, of the data.

Keep going...

 

Memo to Self: The Salary spreadsheet is still a part of the sample file, CheckBook 2013. When you edit the data in CheckBook 2013:2 it will be saved in the original CheckBook 2013 file that you began with.

 

Exam 77-420 Microsoft Excel 2013
1. Create and Manage Worksheets and Workbooks
1.4 Customize Options and Views for Worksheets and Workbooks: View in New Window

 
View -> Window-> New Window
graphic2
 
graphic1