How do you arrange your worksheets or create copies of your worksheets so you can view different parts of the same worksheet in Excel 2007? You can create copies of your original window or Excel 2007 spreadsheet, and these copies can then be tiled so you can view different parts of your original worksheet at the same time. These copies are temporary and will only keep the original after you close all the copies. First select the worksheet you'd like to generate temporary copies of and on the Ribbon, click on the View Tab, to the Windows group and click New Window, click New Window again and again for as many copies as you desire.

Purchase the training video and you can see this in action for yourself!