Welcome toExcel2007.Tips.Net
Helpful Links
Family Tips
Gardening Tips
Organizing Tips
WordTips
Newest Tips
Using Conditional Formatting to Shade Rows
Making Sure Duplicate Names Aren't Entered
Applying a Conditional Format to a Full Row
Subscribe
Viewing Multiple Places in the Same Worksheet
Summary: Do you want to look at different places in the same worksheet at the same time? It's easy to do if you simply open new windows in Excel.Excel makes it easy to view different places in the same worksheet. The way you do this is to open additional windows for the worksheet. Display the View tab of the ruler and click New Window in the Window group. Excel opens additional windows that contain the exact same worksheet. You can then click Arrange All in the Window group of the Ribbon to arrange the windows any way desired.
When you open additional windows in this manner, the windows are independent of each other, meaning that you can scroll them independently. If you make a change in one window, the same change is made in all the windows. (This makes sense, since they all display the same data.)
Once the windows are situated the way you want them, you could save the arrangement as a view (Custom Views in the Workbook Views group of the Ribbon). That way you could quickly recall the appearance of your windows any time you desire.
Related Tips:
More Power! For some people, the prospect of creating Word macros can be scary. WordTips: The Macros can help you conquer your fears and you'll discover you're much more confident and productive as you make Word do exactly what you want. This is an invaluable source for learning macros. You are introduced to the topic in bite-sized chunks, pulled from past issues of WordTips. Learn at your own pace, exactly the way you want. Check out WordTips: The Macros today!