Thanks stacks for the 2nd subject re multiple windows PZ and the answer Gord;
I use a lot of spreadsheets and need them all open to save clicking in and
out. This was a real problem but has only started occurring in the last
month or so. Any one know why it has only just started doing this?

"PZ" wrote:

I'm kind of new to doing anything in Excel except for very basic columns and rows, and doing simple math. I've just been
asked to work a bunch of sheets that someone else in my office does while she's away.

I wonder if there's a way to set any of the following as DEFAULT behaviors rather than having to make a selection every time
I do a cut / copy and paste:

1) Set the paste to ALWAYS "match destination formatting"? I know I can do the paste and then select that option
after the fact, but I'd like it to behave like that all the time

2) Same idea, gets the same result, but with a different option: Instead of "match destination formatting", I can
use "copy values only". But same question: can I make that the somewhere?

Slightly different subject:

1) When I open a new worksheet / workbook and there's already one open, the new one gets put in the same window space
(not sure what it's really called ... "excel desktop"?). Is there a way to have the system open an entirely new "excel
desktop"?

Thanks in advance ... I really appreciate it.

Phil Z (the reply to address IS good, just trying to keep the spam down)