Tip: Working with two worksheets in the same workbook

Category: IT Quick Tips

Sometimes you have a workbook with many worksheets that feed into a summary sheet.

It would be useful to see both the summary sheet and one of the other worksheets at the same time. Excel 2007 Excel 2010 and Excel 2013 make this a very simple exercise.

1. With the workbook open on the screen

2. Click on the View Tab

3. Select New Window from the Window Group

two copies of same

Related Posts Plugin for WordPress, Blogger...

Leave a Reply

Your email address will not be published. Required fields are marked *

CommentLuv badge
 
Textbox Section
 

Contact us

Would you like to talk through your IT Training needs? Just send through your details and we'll get back to you.