Separate Excel Sheets On Different Screens. Create a new folder for the workbook that you want to split, because the split excel files will be stayed at the same folder as this master workbook. A divider will appear which you.
For example, if we select cell a5, the split will look. Drag this second excel window to the screen where you want it displayed. To split the screen horizontally, select a cell from column a in any row (except for the a1 cell).