View Excel Multiple Worksheets
- 3
- Add a Comment
One of the functional features of Excel is that it allows you to work with multiple worksheets. However, this can also be frustrating, especially if you want to view data that is stored on more than one worksheet. You can continue to flip back and forth between them, or you can use the steps described below and learn how to view multiple worksheets at once.
- Open the workbook containing the appropriate worksheet.
- Select the tab of the worksheet containing the data you want to view.
- From the Window menu, click the New Window option.
- Repeat these steps for each worksheet you want to view.
- From the Windows menu, click the Arrange option.
- The Arrange Windows dialog box will appear. Select one of the viewing options.
- Click the Windows of Active Workbook option.
- Click OK.
3 Comments
Jackie Fresta
May 29th, 2007
at 5:33am
Hi - is there a way to control the order that worksheets are refreshed when an excel file is opened? That is, I have multiple sheets of raw data that need to be refreshed before other pivot table sheets are refreshed. How do I control that order?
thanks for any help!
Rich Sholtis
July 14th, 2007
at 3:32pm
Hello… I have a quesiton that I haven’t found the answer too. First, I have been keeping records about money made, I have many jobs and I want to keep a individual record of each one in a “TOTAL BOX” if you will. Can you tell me (if there is a way) when I add a new payment next to the companies name, that same name will in my “TOTAL BOX” will be recognize by that cell and make additional changes to that row? If there isn’t, can you tell me a new/other way of making everything work.
Thank you very much,
Rich Sholtis
kamini
October 15th, 2007
at 9:55am
plese send the worksheet of 2007