Text in excel 2002

Hello,
I am wanting to group all of my worksheets together and copy a paragraph from my word document and paste it to all of the worksheets at the same time to prevent me from opening every worksheet and copying and pasting one at a time.

Can someone come up with a faster solution?

I have pasted text boxes which are embedded in all of my worksheets, but cant seem to copy and paste in it.

Thanks for your time

hi,

If you want the paragraph to be contained within one cell, then hold down ctrl and click on each tab at the bottom of your wrkbook, this will treat each worksheet as one, then copy the text and enter it into the cell in any of the worksheets, this will paste the text into the cell in every worksheet, but make sure that the same cell is clear in every worksheet.

then to unlock the sheets right mouse click and select ungroup sheets.

thanks reg

Hello Reggie,
I ave tried that and for some reason, when I group the worksheets together, I go to the text box embedded in my worksheets and it has a "O" with a "/" through it. I cannot acces the textbox that I have created from the design tool box. How do I enter text that contains several paragraphs to a text box in my worksheet?


Thanks

bump, still looking for a solution, thanks

Ok I will try to clarify and I apologize as I am stuck on this thing and I am a newbie, so it is even more frustrating to describe what I am trying to do.

I have approx 20 different spreadsheets but all of them require a write up summary from me. I am reviewing each vendors budget and I am providing feedback for each worksheet.

What I have done so far is created "text boxes" from the excel design tools and embedded them in each of the worksheet, thinking that will provide a place for me to write my summary on each excel spreadsheet.

My problem is that I didnt know how to edit directly on the excel spreadsheet, so I created text boxes to write in, but now when I am typing in these text boxes, the sentences keep going and going and it will not allow me to go to the next line or start a new paragraph. It just stays on one line, if that makes sense.

So I tried to write out what I needed on MS Word doc and pasting it in the text box on my worksheet, using the paste special feature. This is working fine, but taking too long to complete my summaries.

Is there a faster way that I could edit in excel? I tried merging the cells, but I was hoping for a more user friendly process where I could have other people type their summary in it also.

I hope this is a clearer explanation.

Thanks for your help!