g Text Version
Beauty & Self
Books & Music
Food & Wine
Health & Fitness
Hobbies & Crafts
Home & Garden
News & Politics
Religion & Spirituality
Travel & Culture
TV & Movies

Bored? Games!
Take a Quiz
Rate My Photo

Kidney Disease
Today in History
Distance Learning

All times in EST

Full Schedule
g Desktop Publishing / Ebooks Site

BellaOnline's Desktop Publishing / Ebooks Editor


Excel - Arranging Multiple Worksheets

Guest Author - Chris Curtis

There are many reasons why you might want to view more than one worksheet on your desktop at the same time. Often we perform analyses on data that has an effect on results in another worksheet. Being able to view those effects at the same time you make the change can make the analysis more efficient. Some examples might be:

• View the chart sheet and data sheet to observe the effect of changes in the underlying data on the chart
• View an Loan Amortization Repayment grid and the Loan Terms input sheet to see the effects of changes in the loan terms on the repayment terms
• View the Cash Flow sheet with the income statement to see what effect changes in profit margins have on the company’s cash flow

With Excel you can easily view more than one worksheet at a time, but I would recommend that you limit the number to four. Otherwise, the work area for each worksheet is too small to be effective. The technique to view more than one worksheet is thus:

1. For best results close all other open workbooks
2. Activate one of the worksheets you would like to display
3. Click on Window | New Window
You will get a second incident of the same file
Continue to select a worksheet and use Window | New Window until you have all the worksheet you want to arrange. For example, if you want to display 4 worksheets open 3 new windows; your original window represents the 4th display.
4. Click on Window | Arrange to open the arrange Windows dialog box
5. Select the arrange you desire (Tiled; Horizontal; Vertical; Cascade)
6. New to Excel XP – If you have other open Workbooks, click on Windows to Active Workbook to eliminate the other files from the arrangement.
7. Click on OK

Each display in the arrangement is a separate window pane but all changes made in the pane effect the original file. Choose a different worksheet tab to be displayed in each of the panes. Position each of the worksheet areas where you can view the data being affected. Now, as you make changes to one pane, you can observe the effects on the dependent data in the other panes.

I prefer to limit my analysis to 2 worksheet panes, if I can and arrange the panes vertically. This allows me to see the data clearly side by side.

Try this on in a workbook where you have multiple worksheets with data linkage between the worksheet.

Are you trying to build on your MS Office Skills? Look here for information about your host's online classes at Universal Class

High Quality, Low Cost Online Courses

Be sure to also visit our sister site PC Advice at Bella. You will find a myriad of links and articles about Internet Issues, Personal Computing and Desktop Management.

Please contact your host with any questions. Please also feel free to make any suggestions or contribute a “Unique Technique” Suggestions should be accompanied by your name and title so that I may give the contributor credit.

Add Excel+%2D+Arranging+Multiple+Worksheets+ to Twitter Add Excel+%2D+Arranging+Multiple+Worksheets+ to Facebook Add Excel+%2D+Arranging+Multiple+Worksheets+ to MySpace Add Excel+%2D+Arranging+Multiple+Worksheets+ to Del.icio.us Digg Excel+%2D+Arranging+Multiple+Worksheets+ Add Excel+%2D+Arranging+Multiple+Worksheets+ to Yahoo My Web Add Excel+%2D+Arranging+Multiple+Worksheets+ to Google Bookmarks Add Excel+%2D+Arranging+Multiple+Worksheets+ to Stumbleupon Add Excel+%2D+Arranging+Multiple+Worksheets+ to Reddit

Using Named Ranges (Excel)
5 Unique Techniques for Excel
Converting a List of Names to Multiple Columns in Excel
Editor's Picks Articles
Top Ten Articles
Previous Features
Site Map

For FREE email updates, subscribe to the Desktop Publishing / Ebooks Newsletter

Past Issues

Printer Friendly
tell friend
Tell a Friend
Email Editor

Content copyright © 2015 by Chris Curtis. All rights reserved.
This content was written by Chris Curtis. If you wish to use this content in any manner, you need written permission. Contact Laura Nunn for details.


g features
Becoming a Fiction Editor

Making a Background Transparent Using Photoshop

Merging Letters in Word 2007

Archives | Site Map


Past Issues

Less than Monthly

BellaOnline on Facebook

| About BellaOnline | Privacy Policy | Advertising | Become an Editor |
Website copyright © 2015 Minerva WebWorks LLC. All rights reserved.

BellaOnline Editor