Wednesday, September 13, 2017

Excel : Split Worksheet Into Panes With Split Button

1. Select the row you want to insert the split pane above it firstly.


Tip: If you want to insert vertical split pane, you can select a column you want to insert the split pane left to it.

2. Then click View > Split, and you can see the split pane is inserted into the worksheet.


Tip: If you want to insert a cross split pane into a worksheet, select a cell that you want to insert horizontal split pane above and the vertical split pane left to, then click View > Split. 


Note: If you want to clear the split panes, just double click the pane you want to delete, then it will be removed.