You can open multiple workbook windows in Excel 2010 and arrange them into windows of varying displays so that you can view different parts of a worksheet from each workbook on the screen at one time. Follow these steps to arrange workbook windows in Excel 2010: Open the workbooks that you want to
arrange. You'll want to open at least two workbooks and select the worksheet in each workbook that you want to display. Click the Arrange All button in the Window group on the View tab. The Arrange Windows dialog box appears. Select the desired Arrange setting in the Arrange Windows dialog box. Make one of the following selections:
Click OK. The workbooks are arranged on-screen based on your selection in the previous step. After you arrange windows, activate the one you want to use (if it's not already selected) by clicking it. In the case of the cascade arrangement, you need to click the worksheet window's title bar, or you can access the worksheet from the Windows taskbar. If you close one of the windows you've arranged, Excel doesn't automatically resize the other open windows to fill in the gap. To fix this, click the Arrange All command again on the View tab, select the desired arrangement, and click OK. About This ArticleThis article is from the book:
About the book author:Greg Harvey, PhD, is president of Mind Over Media, Inc. He is the author of all editions of Excel For Dummies, Excel All-in-One For Dummies, Excel Workbook For Dummies, and Windows For Dummies Quick Reference. He's also an experienced educator. This article can be found in the category:
focusNode Didn't know it? Knew it? Embed Code - If you would like this activity on your web page, copy the script below and paste it into
your web page.
How do I arrange windows side by side in Excel?View two worksheets in the same workbook side by side. On the View tab, in the Window group, click New Window.. On the View tab, in the Window group, click View Side by Side .. In each workbook window, click the sheet that you want to compare.. To scroll both worksheets at the same time, click Synchronous Scrolling.. What is arrange windows in Excel?Arrange Windows
You can stack your open Excel windows in a few different ways to maximize the on-screen data. Click the View tab. Click the Arrange All button. Select an arrangement option. Tiled: Windows are arranged as equally sized, tiled squares.
Can you look at two Excel tabs side by side?On the View tab, in the Window group, click View Side by Side . In the workbook window, click the worksheets that you want to compare. To scroll both worksheets at the same time, click Synchronous Scrolling in the Window group on the View tab.
How do I open Excel on two screens?To do this, open Excel and open your first file as normal. Then, instead of opening the second file from within Excel, go to the Start menu and open Excel from there again. This will create a second copy of Excel which you can display on the secondary screen. You can open the second document from there.
|