"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: Position the mouse pointed over the split box above the vertical scroll bar. Click and drag the your mouse pointer down to where you want to split the screen. To split the screen vertically: Position the mouse pointed over the split box to the right of the horizontal scroll bar. 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)