If you have two or more screens (I have three) you can have separate Excel windows on separate screens. This can make copying and linking much easier.

The keyboard shortcut to open a new window in the current file is Alt W N pressed in sequence not held down.

This allows you to have the same file visible in two separate windows. Each window can have a separate sheet.

The New Window icon is on the View ribbon tab.