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)

You can customize your toolbar with Paste Value (and other) buttons by going
to Tools~Customize~Commands tab~Edit Category...There you will find a paste
formatting and paste values button.

On the 2nd question, I'm assuming you mean that there is only 1 copy of
Excel in your taskbar. If you go to Tools~Options~View Tab then select
Windows in Taskbar to display multiple workbooks in the taskbar.

HTH

"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)

Yes, thank you.

I have already added those buttons to the toolbar and certainly I can use them. But again, what I REALLY want is fthe
system to just default to "match destination formatting", or "copy values only" UNLESS I specifically pick something else.

And as to the 2nd question: No, I didn't mean there is only one copy of Excel in the taskbar. I meant that at the Windows
XP level, there are multiple icons for Excel, each icon representing a different open file. However each of those open files
is open in the same Excel window as the others. I'd like to know how (if it's possible that is) for each open file to exist
within it's own private Excel workspacee.

Thanks, again
PhilZ

E-Coder wrote:

You can customize your toolbar with Paste Value (and other) buttons by going
to Tools~Customize~Commands tab~Edit Category...There you will find a paste
formatting and paste values button.

On the 2nd question, I'm assuming you mean that there is only 1 copy of
Excel in your taskbar. If you go to Tools~Options~View Tab then select
Windows in Taskbar to display multiple workbooks in the taskbar.

HTH

"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)

Only if you run multiple instances of Excel.

One for each workbook.

None too efficient and rarely necessary.

If you want to do this, go to ToolsOptionsGeneral and place a checkmark in
"Ignore other applications".

Then when opening a workbook, do so from a folder, not from FileOpen.


Gord Dibben MS Excel MVP


On Fri, 23 Feb 2007 20:14:14 GMT, (PZ) wrote:

I'd like to know how (if it's possible that is) for each open file to exist
within it's own private Excel workspacee.

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)