Click View > Sheets . In the Sheets list, highlight the sheets you want to open in separate windows. See Also Sheets CommandSheets Dialog Box