Excel - Split Panes

Lokolo

Bonjourno.

Ok so I've made my own budget thing but I need some help, I have made a pic of what I want...

http://i2.photobucket.com/albums/y2/Lokolo/excelproblem.jpg

I want my spreadsheet to be split into 2 panes. Is there anyway I can do this?

p.s. paint ftw

Vomityspice

Am I missing something but doesn't Excel already give you that option.

Look in 'Window', and then 'Split'.

i.e. highlight the column/row you want to split ant then choose the menu option (above)

This is on Excel 2003 but I expect it is available on later versions.

Lokolo

Yeh that has worked. I just can't create multiple vertical ones it seems. I didn't originally wanted it splitting into 2 panes and having both panes with the same spreadsheet but nothing I can do about this I guess.

PhilCo_2

An alternative is to do Window - New Window to create a copy(ies) of the file and then arrange them so that the bits you need are visible on the different windows. The new window is just a live copy of the original file so whatever window you enter data in you're still entering it on the original file.

isofa

You can split it once horizontally and once vertically...

Just hover the cursor, just to the left of the horizontal scroll bar, or just to the top of the vertical scroll bar - then click and drag across the split from the "split box"- or use the Window Split command.

All versions of Excel for as far back as I can remember can do this.

You can also freeze the split, from the Window command, which is very useful for keeping column/row data headings on screen, and giving you back the full scroll bars.

But you cannot have more than one horizontal and/or one vertical split, presumably because it'd get far to unwieldy. PhilCo gives an alternative.