Excel 2007 For Dummies
Book image
Explore Book Buy On Amazon

In Excel 2007, you can split the worksheet window into separate panes and scroll the worksheet in each pane so that you can easily compare data from two separate worksheet locations. You can make the panes in a workbook window disappear by double-clicking anywhere on the split bar that divides the window.

To split a worksheet into two (upper and lower) horizontal panes, you can drag the split bar — located right above the scroll arrow at the very top of the vertical scroll bar — down until the window divides as you want it. Use the following steps:

  1. Click the vertical split bar and hold down the mouse button.

    The mouse pointer changes to a double-headed arrow with a split in its middle (like the one used to display hidden rows).

    The vertical split bar won't appear if you've frozen rows of the worksheet.

  2. Drag downward until you reach the row at which you want the worksheet window divided.

    A gray dividing line appears in the worksheet window as you drag down, indicating where the window will be split.

  3. Release the mouse button.

    Excel divides the window into horizontal panes at the pointer’s location and adds a vertical scroll bar to the new pane.

    A worksheet in a horizontally split window after scrolling up in the lower pane.
    A worksheet in a horizontally split window after scrolling up in the lower pane.

You can also split the worksheet window into two vertical (left and right) panes by following these steps:

  1. Click the split bar located at the right edge of the horizontal scroll bar.

    The horizontal split bar won't appear if you have frozen columns in the worksheet.

    Don’t confuse the tab split bar to the left of the horizontal scroll bar with the horizontal split bar at its right. You drag the tab split bar to increase or decrease the number of sheet tabs displayed at the bottom of the workbook window; you use the horizontal split bar to divide the workbook window into two vertical panes.

  2. Drag to the left until you reach the column at which you want the worksheet window divided.

  3. Release the mouse button.

    Excel splits the window at that column and adds a second horizontal scroll bar to the new pane.

Instead of dragging split bars, you can divide a worksheet window by clicking the Split button on the View tab. Excel uses the position of the cell cursor to determine where to split the window into panes. The program splits the window vertically at the left edge of the pointer and horizontally along the top edge. After you split the window into panes, you can move the cell cursor into a particular pane by clicking one of its cells. Click the Split button again to quickly remove the panes.

A worksheet window split into four panes after placing the cell cursor in cell B10.
A worksheet window split into four panes after placing the cell cursor in cell B10.

About This Article

This article is from the book:

About the book author:

Greg Harvey has authored tons of computer books, the most recent being Excel Workbook For Dummies and Roxio Easy Media Creator 8 For Dummies, and the most popular being Excel 2003 For Dummies and Excel 2003 All-In-One Desk Reference For Dummies. He started out training business users on how to use IBM personal computers and their attendant computer software in the rough and tumble days of DOS, WordStar, and Lotus 1-2-3 in the mid-80s of the last century. After working for a number of independent training firms, Greg went on to teach semester-long courses in spreadsheet and database management software at Golden Gate University in San Francisco.
His love of teaching has translated into an equal love of writing. For Dummies books are, of course, his all-time favorites to write because they enable him to write to his favorite audience: the beginner. They also enable him to use humor (a key element to success in the training room) and, most delightful of all, to express an opinion or two about the subject matter at hand.
Greg received his doctorate degree in Humanities in Philosophy and Religion with a concentration in Asian Studies and Comparative Religion last May. Everyone is glad that Greg was finally able to get out of school before he retired.

This article can be found in the category: