How to Split the Worksheet Window in Microsoft Excel
- Click where you want to split the window.
- On the View tab, in the Window group, select Split .
- You can now scroll through each window separately to easily view and compare data.
Contents
How do I split Excel into two windows?
Split a sheet into panes
- 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.
Can you split Excel into two screens?
Excel itself won’t let you split it across two screens as a default – it will always display itself all on one screen or the other. However, you can run two instances of Excel to get this to work.Then, instead of opening the second file from within Excel, go to the Start menu and open Excel from there again.
How do I split Excel windows vertically?
To split a worksheet:
- Select the cell where you want to split the worksheet.
- Click the View tab on the Ribbon, then select the Split command.
- The workbook will be split into different panes.
- After creating a split, you can click and drag the vertical and horizontal dividers to change the size of each section.
How do I split an Excel spreadsheet into separate files?
Split a workbook to separate Excel Files with Move or Copy feature
- Select the sheets in the Sheet tab bar, right click, and select Move or Copy from the context menu.
- In the Move or Copy dialog, select (new book) from the To book drop down list, check the Create a copy option, and click the OK button.
How do I open 2 Excel Windows in 2019?
View two worksheets in the same workbook side by side
- On the View tab, in the Window group, click New Window.
- On the View tab, in the Window group, click View Side by Side .
- In each workbook window, click the sheet that you want to compare.
- To scroll both worksheets at the same time, click Synchronous Scrolling.
Why can’t I have 2 Excel windows open at the same time?
By default, Excel will use an already running instance to open other files. Simply open up Excel, then open your file. Then open up a second copy of Excel and open the second file. Now you can move the two Excel instances independently to your other monitor.
How do I open two Excel files in separate windows 2016?
Open Multiple Workbooks in the Same Window
- If the Excel Application is already opened, we can use the Open command from the File Menu and select multiple Excel Workbooks to Open in the Same Window.
- If the Excel Application is already opened, we can drag the workbooks and drop in already opened Excel Application Window.
To split a worksheet into four separately scrollable quadrants, first click to select the cell below and to the right of where you want the split to appear. Then click the “View” tab in the Ribbon. Then click the “Split” button in the “Window” button group to split the current worksheet into four separate panes.
How do I split excel horizontally?
Windows can be split both horizontally as well as vertically. This can be done by selecting (Window > Split). The split will occur at the top left corner of the active cell. You can only use the split screen to view two parts of the same worksheet.
How do I open two separate Excel 2010 files?
- Open your first Excel file and place it on the screen you want.
- Open a new Excel file from the Excel icon.
- The new file will open on top of the one you have already opened. Drag it to the other screen.
- Drag the icon for the second Excel file INTO the new (blank) Excel document.
How do I open multiple Excel files in Windows 10?
Opening Multiple Workbooks at Once
- Choose Open from the File menu.
- Instead of double-clicking on a file name, start to create a “selection set.” If you are selecting sequential files, click on the first file in the sequence, then hold the Shift key as you click on the last.
How do I split an Excel spreadsheet into multiple files based on columns?
1). Select Specific column option in the Split based on section, and choose the column value which you want to split the data based on in the drop-down list. (If your data has headers and you want to insert them into each new split worksheet, please check My data has headers option.)
How do you open multiple Excel files in one Excel?
Press Alt + F8 to open the Macro dialog. Under Macro name, select MergeExcelFiles and click Run. The standard explorer window will open, you select one or more workbooks you want to combine, and click Open. To select multiple files, hold down the Ctrl key while clicking the file names.
How do I open two Excel spreadsheets in a single tab window?
If you want to view workbooks on two screens, you’ll have to start two separate instances of Excel. Start Excel, then Shift+click the Excel icon on the Windows taskbar to open a second instance, and drag the new window to the other screen (if it is maximized, un-maximize the window first).
Can I only open one Excel spreadsheet at a time?
The first click of your double-click is effectively interpreted by Windows as a command to select only that one workbook. The solution is to change how you are starting Excel. Instead of double-clicking on one of the workbooks in the selection set, right-click on one of the files and choose Open.
What is the shortcut for split screen in Excel?
There is no dedicated shortcut in Excel to split the screen, but you can use Alt + W + S in Windows to toggle a split screen on and off. Move the active cell to row 1 to split vertically into 2 panes. And move the active cell to column A to split horizontally into 2 panes.