You can re-size the Excel window to be less than full-screen, that's OK and mostly how I have it.
Zoom refers to the 'magnification' you can set within Excel, using the top-panel Ribbon View>Zoom and choosing a zoom% there.

Simplest way for you to copy code between workbooks is to use copy-and-paste

zeddy