Board index » Excel » Two different views

Excel2
Hi,



I am using Excel 2000 and have rows of data, each row representing one

person like this (simplified):



Name Age Notes

xxx 44 blah blah blah...

yyy 27 yada yada

zzz 33 more more...



The problem is the Notes field is sometimes long and makes the row height

higher than the rest of the rows. I want to be able to able to see it as

above and like this (especially when printing):



Name Age Notes

xxx 44 blah blah blah

blah blah

yyy 27 yada yada

zzz 33 more more

more





Is there a way to add a button or something to switch between the two

"views"? Also, I have multiple pages with the same problem. Thank you for

any help or ideas.



Thank you,

Joe


-

Goto FORMAT>CELLS>ALIGNMENT

Turn the WRAP TEXT check box on for the notes column



Is that what you are after?



George





Joe Thompson wrote:

Hi George,



Thank you for the reply. That's what I'm after but I want the users to have

an easy way to do it like a menu item or button. Any ideas?



Thanks again,

Joe



"George" wrote:

Joe,

One option is to create a checkbox on your form (use Control

Toolbox ... View==>Toolbars==>Control Toolbox) and then add the code below

in the sheet. Add checkbox and then right click==>View code.



Any range of cells selected will wrap text/unwrap text.



HTH



Private Sub CheckBox1_Click()

Selection.WrapText = CheckBox1 <=== Add this line

End Sub



"Joe Thompson" wrote: