web analytics


Microsoft Excel 2013

This article is about splitting worksheets in Microsoft Excel 2013. Although zooming in and out on the worksheet can help you get your bearings, it can’t bring together to separate sections so that you can compare their data on the screen. To manage this split the worksheet area in two separate panes and then scroll the work it did each panes so that they display the parts you want to compare.

Splitting the window is easy. To split a worksheet independent 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.


The key to creating the pane you want with the split button is positioning the pointer in the correct cell before you clicked this command button.

To split the window into horizontal pane, position the cell pointer in column any of the role where you want to split the worksheet. To split the window into two vertical panes, position the cell pointer in a row one of the column where you want to split the worksheet. To spot the window into four panes, two horizontal and to vertical, position the cell pointers somewhere in the centre of the worksheet Excel splits the page along the top and left ads of the cell after you split the worksheet window, Excel displays a grey bar along the row or column with the windows flip occurs.

If you position the mouse or touch the pointer anywhere on the split bar, the pointer changes from a white cross to a split pointer shape.

You can decrease or increase the size of the current window panes by dragging the split bar up and down or left or right with the split pointer.


You can make the panes in the workbook window disappear by double clicking anywhere on the split bar. You can do the same thing by selecting view and split again.

Leave a Reply