EXCEL WORKFLOW

How to View Excel Sheets in Separate Windows on Mac

Compare sheets without confusing a second view with a second file.

How do I see two sheets from one workbook?

In Excel for Mac, open the workbook and choose View → New Window. Select a different worksheet in the new window. You now have two views of the same workbook, not an independent copy. Use Arrange All to see them together.

Choose the view that matches the comparison.

  • Two areas of one sheet: use Excel’s Split command to scroll separate panes inside one window.
  • Two sheets in one workbook: use New Window, then select a different sheet in each view.
  • Two different files: open both workbooks and arrange their windows.

Microsoft documents these routes in its Excel for Mac viewing guide. Ribbon labels can vary by version. Split panes and worksheet tabs remain inside Excel; they are not separate Mac windows.

Set up a budget check.

  1. Open the workbook containing your summary and transaction sheets.
  2. Create a second window and select the transaction sheet there.
  3. Use Arrange All and choose an arrangement that leaves both sets of columns readable. Restrict the arrangement to the active workbook if that option is available and you want only its views.
  4. Check the workbook name, sheet tab and selected cell before editing.

This is useful when tracing a total back to its inputs. If you instead need to preserve an original before editing, create an actual file copy through your normal file workflow. An extra window does not protect the original from changes.

Keep width when side-by-side becomes cramped.

A wide spreadsheet can become harder to read when squeezed into half a display. Keep each view larger and switch when you need to check another sheet, or move a reference to another display. Choose based on readable columns, not on fitting the largest possible number of windows onscreen.

StillSwitch can select eligible Excel windows alongside a PDF, browser or notes window. It does not select a worksheet tab or move the active cell. After switching, confirm the sheet and cell before pasting values or formulas. For sustained visual comparison, Excel’s own arrangement controls may be the better fit.

Finish with the right file.

Before closing a view, check which workbook it belongs to and follow Excel’s save prompts. Do not assume that two similarly named windows represent two saved files. For a source document outside Excel, the PDF comparison guide covers a different workflow; for fixed pairs of apps, see Split View.

Written by the maker of StillSwitch. Reviewed on . Controls can vary by app, keyboard layout and macOS version.

Download for Mac Setup, trial & requirements

14 days free. No card. Apple Silicon and macOS 15 or later.