"How To Excel" Mini-Tutorials
by TheExcelAddict.com
"Helping Average Spreadsheet Users Become Local Spreadsheet Experts"

View Two Parts Of A Worksheet Simultaneously


If you need to view or work with different parts of your worksheet at the same time, you can, by using Excel's split screen feature. Splitting the screen allows you to split a worksheet into two separate panes, either vertically or horizontally, that can be scrolled separately.

First, locate the two split boxes. One is the small box immediately above the vertical scroll bar arrow and the other is immediately to the right of the horizontal scroll bar arrow. When you position the mouse pointed over the split box, the pointer will change to a two-headed arrow.

To split the screen horizontally:

  1. Position the mouse pointed over the split box above the vertical scroll bar.
  2. Click and drag the your mouse pointer down to where you want to split the screen.
To split the screen vertically:
  1. Position the mouse pointed over the split box to the right of the horizontal scroll bar.
  2. Click and drag the your mouse pointer left to where you want to split the screen.
To remove the split, double-click anywhere on the split.


Why not print (CTRL+P) this tip and share it with your friends and associates?

Get more time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict". Subscribe at the www.TheExcelAddict.com/Newsletter.htm.
You'll be amazed how much time you'll save just by learning a few of these tips.

Copyright 2003 All Rights Reserved by Francis Hayes (The Excel Addict)

If you came to this page from my Excel Mini-Tutorials page, click here to close this window,
otherwise click here and you'll find lots more time-saving Excel tutorials like this one.