overflow data

  • Thread starter Thread starter Barbara
  • Start date Start date
B

Barbara

When i input data into a cell, can i fix it so it doesn't
overflow the adjacent but empty cell? Thanks.
 
You could enter a space character in the adjacent cell, so it appears
empty, but will stop the overflow.
 
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
 
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


.
Click to expand...
 
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


.
Click to expand...
 
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
 
Back
Top