Select below the row where you want the split, or the column to the right of where you want the split. On the View tab, in the Window group, click Split. To remove the split panes, click Split again.

To split your sheet into a left and right pane, execute the following steps. 1. First, select a cell in row 1. 2. On the View tab, in the Window group, click Split. Tip: you can also use the shortcut Alt + W + S to quickly enable or disable split screen in Excel.

Select the cell or cells with data to be split >> open the data menu and select the split text to column option >> finally choose a separator to split the cell’s data into fragments.