overflow data

[Barbara]

When i input data into a cell, can i fix it so it doesn't
overflow the adjacent but empty cell? Thanks.

 

[Debra Dalgleish]

You could enter a space character in the adjacent cell, so it appears
empty, but will stop the overflow.

 

[Barbara]

thanks, Genius!

-----Original Message-----
You could enter a space character in the adjacent cell, so it appears
empty, but will stop the overflow.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.

 

[Tushar Mehta]

An alternative to Debra's very-easy-to-implement suggestion is to
format the cell for 'wrap text' (Format | Cells... | Alignment tab) and
then reduce the row height (maybe, even set it to the default of
12.75).

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[barbara]

thx. i tried it w/out success.

-----Original Message-----
An alternative to Debra's very-easy-to-implement suggestion is to
format the cell for 'wrap text' (Format | Cells... | Alignment tab) and
then reduce the row height (maybe, even set it to the default of
12.75).

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions


.

 

[barbara]

thx. i tried it w/out success.

-----Original Message-----
An alternative to Debra's very-easy-to-implement suggestion is to
format the cell for 'wrap text' (Format | Cells... | Alignment tab) and
then reduce the row height (maybe, even set it to the default of
12.75).

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions


.

 

[Tushar Mehta]

Must be version-related since I tested that and another suggestion
(Shrink to Fit) in XL 2002 before posting.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions