I am using EXCEL 2007.

In previous verions, I can remember selecting a range on a worksheet, then
selecting multiple worksheets, the pasting--this would result in the past to
all the selected or grouped worksheets.

This does not work in EXCEL 2007?

How can I do a past, data and/or formulats, a cell and/or a range, to
multiplpe workseets in the same workbook?

Thank you.

Did you remember to copy the cell contents first? I just tried it on my XL2007 and it worked fine. I selected the cells, hit Ctrl+C to copy it into the Clipboard, selected multiple sheets, hit Ctrl+V to paste the Clipboard contents and every selected sheet got a copy of the originally selected cells.

Rick


"mooring" wrote in message ...
I am using EXCEL 2007.

In previous verions, I can remember selecting a range on a worksheet, then
selecting multiple worksheets, the pasting--this would result in the past to
all the selected or grouped worksheets.

This does not work in EXCEL 2007?

How can I do a past, data and/or formulats, a cell and/or a range, to
multiplpe workseets in the same workbook?

Thank you.

Yes I did.

I have tried this with both formulas and data (integers).

If I use data (numbers) and open the clipboard on the left and select past
from the clipboard, it does seem to work as expected. However, if I copy
formulas and past from the clipboard on the left, it pastes numbers in all
the sheets.

When I simply copy a cell or range of cells, then group the sheets, then
past normally, the past only goes to the worksheet that is active.

This is Excel 2007

thanks for your help.



"Rick Rothstein (MVP - VB)" wrote:

Did you remember to copy the cell contents first? I just tried it on my XL2007 and it worked fine. I selected the cells, hit Ctrl+C to copy it into the Clipboard, selected multiple sheets, hit Ctrl+V to paste the Clipboard contents and every selected sheet got a copy of the originally selected cells.

Rick


"mooring" wrote in message ...
I am using EXCEL 2007.

In previous verions, I can remember selecting a range on a worksheet, then
selecting multiple worksheets, the pasting--this would result in the past to
all the selected or grouped worksheets.

This does not work in EXCEL 2007?

How can I do a past, data and/or formulats, a cell and/or a range, to
multiplpe workseets in the same workbook?

Thank you.

Hi
As Rick says, this works the same in XL2007 as earlier versions.
I get no problem selecting a mixture of Text, Numbers and formulae, then
grouping a range of sheets and pasting.
It makes no difference if I use the icons for Copy and Paste, or using
Control+C to copy and Control+V to Paste.

--

Regards
Roger Govier

"mooring" wrote in message
...
Yes I did.

I have tried this with both formulas and data (integers).

If I use data (numbers) and open the clipboard on the left and select past
from the clipboard, it does seem to work as expected. However, if I copy
formulas and past from the clipboard on the left, it pastes numbers in all
the sheets.

When I simply copy a cell or range of cells, then group the sheets, then
past normally, the past only goes to the worksheet that is active.

This is Excel 2007

thanks for your help.



"Rick Rothstein (MVP - VB)" wrote:

Did you remember to copy the cell contents first? I just tried it on my
XL2007 and it worked fine. I selected the cells, hit Ctrl+C to copy it
into the Clipboard, selected multiple sheets, hit Ctrl+V to paste the
Clipboard contents and every selected sheet got a copy of the originally
selected cells.

Rick


"mooring" wrote in message
...
I am using EXCEL 2007.

In previous verions, I can remember selecting a range on a worksheet,
then
selecting multiple worksheets, the pasting--this would result in the
past to
all the selected or grouped worksheets.

This does not work in EXCEL 2007?

How can I do a past, data and/or formulats, a cell and/or a range, to
multiplpe workseets in the same workbook?

Thank you.

Thanks for your reply.

Mine definately is not performing as you both suggest and observe. Is there
an Excel setting I may have corrupted?

I will try this again on a fresh reboot. (This is running under Vista).




"Roger Govier" wrote:

Hi
As Rick says, this works the same in XL2007 as earlier versions.
I get no problem selecting a mixture of Text, Numbers and formulae, then
grouping a range of sheets and pasting.
It makes no difference if I use the icons for Copy and Paste, or using
Control+C to copy and Control+V to Paste.

--

Regards
Roger Govier

"mooring" wrote in message
...
Yes I did.

I have tried this with both formulas and data (integers).

If I use data (numbers) and open the clipboard on the left and select past
from the clipboard, it does seem to work as expected. However, if I copy
formulas and past from the clipboard on the left, it pastes numbers in all
the sheets.

When I simply copy a cell or range of cells, then group the sheets, then
past normally, the past only goes to the worksheet that is active.

This is Excel 2007

thanks for your help.



"Rick Rothstein (MVP - VB)" wrote:

Did you remember to copy the cell contents first? I just tried it on my
XL2007 and it worked fine. I selected the cells, hit Ctrl+C to copy it
into the Clipboard, selected multiple sheets, hit Ctrl+V to paste the
Clipboard contents and every selected sheet got a copy of the originally
selected cells.

Rick


"mooring" wrote in message
...
I am using EXCEL 2007.

In previous verions, I can remember selecting a range on a worksheet,
then
selecting multiple worksheets, the pasting--this would result in the
past to
all the selected or grouped worksheets.

This does not work in EXCEL 2007?

How can I do a past, data and/or formulats, a cell and/or a range, to
multiplpe workseets in the same workbook?

Thank you.

Thanks again for the replies.

Could I get both of you to try the following simple test and report back
your results.

Open a blank workbook (should have three worksheets)
Enter data in 5 cells in column A
Enter data in 5 cells in column B
Enter a formula in 5 cells in column C based on the values in Colum A and B
(=A1*B2)
Copy all the data (should be 5 rows and 3 columns) with Ctrl C
Group Sheet 1 to Sheet three with click shift click
Paste with Cntrl V on Sheet 1

In my test, there is nothing pasted to Sheet 2 or Sheet 3.

If I select any group of worksheets, EXCLUDING the copy from worksheet, it
will paste across multiple worksheets.

Why would you want to past on top of what you just copied from. I have many
models that I create the first page and have multiple parallel worksheets.
When I cot to edit this model, I work on one worksheet. Then it seems simple
to me to just copy from that worksheet, and past to all parallel worksheets,
including the copy from worksheet.

Do I have a warped sense of reality here?

Thanks again.

I am using Excel XP and get exactly the same results you describe in 2007.
When you go to copy just group the worksheets you wish to copy to.
Why would you try to overwrite the contents you just copied?

"mooring" wrote:

Thanks again for the replies.

Could I get both of you to try the following simple test and report back
your results.

Open a blank workbook (should have three worksheets)
Enter data in 5 cells in column A
Enter data in 5 cells in column B
Enter a formula in 5 cells in column C based on the values in Colum A and B
(=A1*B2)
Copy all the data (should be 5 rows and 3 columns) with Ctrl C
Group Sheet 1 to Sheet three with click shift click
Paste with Cntrl V on Sheet 1

In my test, there is nothing pasted to Sheet 2 or Sheet 3.

If I select any group of worksheets, EXCLUDING the copy from worksheet, it
will paste across multiple worksheets.

Why would you want to past on top of what you just copied from. I have many
models that I create the first page and have multiple parallel worksheets.
When I cot to edit this model, I work on one worksheet. Then it seems simple
to me to just copy from that worksheet, and past to all parallel worksheets,
including the copy from worksheet.

Do I have a warped sense of reality here?

Thanks again.

When I perform the test you indicated, I get the same results you posted. As
for including the worksheet in the group to copy to... it would never have
occurred to me to even try that. I'm not sure why doing so stops the rest of
the copies from happening; but I did note this interesting observation...
put the same data on Sheet3 instead of Sheet1, copy it, select all the
sheets and then paste it down... Sheet1 will receive a copy of the data but
not Sheet2.

Rick


"mooring" wrote in message
...
Thanks again for the replies.

Could I get both of you to try the following simple test and report back
your results.

Open a blank workbook (should have three worksheets)
Enter data in 5 cells in column A
Enter data in 5 cells in column B
Enter a formula in 5 cells in column C based on the values in Colum A and
B
(=A1*B2)
Copy all the data (should be 5 rows and 3 columns) with Ctrl C
Group Sheet 1 to Sheet three with click shift click
Paste with Cntrl V on Sheet 1

In my test, there is nothing pasted to Sheet 2 or Sheet 3.

If I select any group of worksheets, EXCLUDING the copy from worksheet, it
will paste across multiple worksheets.

Why would you want to past on top of what you just copied from. I have
many
models that I create the first page and have multiple parallel worksheets.
When I cot to edit this model, I work on one worksheet. Then it seems
simple
to me to just copy from that worksheet, and past to all parallel
worksheets,
including the copy from worksheet.

Do I have a warped sense of reality here?

Thanks again.