Creating written summary in excel 2002

[hkg003]

Hello, I am creating a financial summary on a worksheet and I want to be able to write up a summary about each category. Is there a way that I could write text on my worksheet and create a parameter where my text could go to the next line such as a word document?

I hope I made myself clear.


Thanks

 

[hkaplan2]

Use a text box.

Or if you write into a cell, press Alt+Enter to create a hard line break. Or use Format Cells | Alignment Tab | Wrap Text feature.

 

[hkg003]

Is there a way to create multiple text boxes for multiple worksheets at once?

 

[theozz]

How abou using
ComboBox1 or ListBox1 ?

 

[hkg003]

Thanks for your help!

 

[hkg003]

I have embedded a combo box on one of my worksheet, is there a way to do this for multiple worksheets at a time? For example, I have 20 people I am creating a spreadsheet for containing their audit results. I would like for each person to edit into the combo boxes I have created.

Therefore, I would like to create these boxes all at once, then the next question is, how do you activate the combo box and edit, change fonts, etc?

I apologize for the questions as I am a newbie at this!


Thanks

 

[hkg003]

bump

 

[hkg003]

Anything?

 

[Paella1]

I'm afraid I can't understand what you are trying to achieve. Are you able to put up some sort of example?

 

[hkg003]

I have pasted a text box in my worksheet, but I have many vendors that i am keeping track of and I want to provide a written summary to find opportunities to improve on our current budget analysis. Therefore, I have created charts on 20 vendors, now I want to attach text boxes under my charts to provide a summary on our spendings. I have merged cells to create somewhat of a writing tablet, but I was wondering if there is a way to copy all of my text boxes to all 20 of my spreadsheets at the same time?