Scroll bars in Cell

[Stephen Closson]

Hi all,

It seems like you can only size a cell so that it is 409.50 pixels. I have
large ammount of text that I would like to put into a cell, and be able to
scroll through that text. It would keep the size of the cell minimum, and
allow the user to easily see what are the contents of the cell.

Is this possible in Excel 2000? Is there a similar way to do this?

Thanks for your help,
Stephen

 

[Frank Kabel]

Hi Stephen
This is not possible for a cell (that is attach scrollbars to it)

 

[Dave Peterson]

Maybe you could put in a TextBox from the Control Toolbox Toolbar.

After you place the textbox, click on the design mode icon on that same control
toolbox toolbar.

Right click on the textbox and choose properties:
Modify these:
EnterKeyBehavior to True (enter key moves to new line within the textbox)
MultiLine to True
Scollbars to 2-fmScrollbarsVertical
WordWrap to True

(Wordwrap = false and have a scrollbar at the bottom, too???)

Then toggle your way out of Designmode and test it out.