Community archive

Ask something
Discussion Locked

Excel: Reformat Cell

0 helpful
2 replies

by wilcoxj

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
If one enters text in an Excel 2000 cell and the length of text is greater than the width of the cell, Is there a way to automatically reformat the cell to drop the remainder of the text to subsequent lower cells. Quatro Pro does it with a command called reformat.

2 replies

by malcolm r

Format->Cells->Alignment->Wrap Text

This will increase the row height and wrap the text in the cell so it fits the column width.

Malcolm

This discussion is closed to new replies.