Excel 2007 - Split a Window


Uploaded by spreadsheetrepublic on 24.01.2012

Transcript:
Hi, My name is Mark Smitton from spreadsheethowto.com and this is my Excel 2007 guide on how to Split a Window.
You can use the Ribbon method or the Mouse method.
The Ribbon Method
To place a split in your active window you need to select a cell that is immediately below
and to the right of where you want to place your window split.
On the Excel 2007 Ribbon select the View Tab.
On the View Tab click on the Split Button, which can be found in the Window Section.
The window will now split at your location.
You should also have scroll bars that allow you to move each window pane independently.
The Mouse Method
There are two Split Bars in the Excel 2007 window.
One is at the top of the vertical scroll bar.
The other is located to the right of the horizontal scroll bar.
Click and hold down the left mouse button on the relevent scroll bar.
Drag the mouse cursor to where you want to split the window.
A dark grey bar will highlight where the split will be inserted as you drag your mouse.
Release the left mouse button when the dark grey bar is in the correct position.
The window will now split at your location. You should also have scroll bars that allow you to move each window pane independently.
If you need more free information on this and related topics check out my site at www.spreadsheethowto.com.
You can also download some of my more in- depth guides and spreadsheet templates at www.spreadsheetrepublic.com.
Goodbye for now.