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.