View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
PZ PZ is offline
external usenet poster
 
Posts: 5
Default Setting Up Default Behavior

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)