How to split a Microsoft Excel spreadsheet

1149705 pts.
Tags:
Microsoft Excel
Hello experts, So I have an interesting question: I would actually like to split a Microsoft Excel spreadsheet that I'm working on. Meaning on the top half on the spreadsheet, I would have 5 columns with data. The bottom half would have 10 columns. Is that remotely possible? How can I do it?
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

This may help depending on what version you are on

To split a worksheet into two (upper and lower) horizontal panes, you simply position the cell pointer at the place in the worksheet where you want to split the worksheet and then click the Split button on the Ribbon’s View tab (or press Alt+WS).

The key to the panes created with the Split button is the cell in the worksheet where you position the pointer before selecting this command button:

To split the window into two horizontal panes, position the cell pointer in column A of the row where you want to split the worksheet.

To split the window into two vertical panes, position the cell pointer in row 1 of the column where you want to split the worksheet.

To split the window into four panes — two horizontal and two vertical — position the cell pointer along the top and left edge of cell.

After you split the worksheet window, Excel displays a split bar (a thin, light gray bar) along the row or column where the window split occurs. If you position the mouse or touch pointer anywhere on the split bar, the pointer changes from a white-cross to a split pointer shape (with black arrowheads pointing in opposite directions from parallel separated lines).

You can increase or decrease the size of the current window panes by dragging the split bar up or down or left or right with the split pointer. You can make the panes in a workbook window disappear by double-clicking anywhere on the split bar (you can also do this by selecting View→Split again).

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: