i want to know do i make my text fit into 1 block if it is a long sentance
needing two or three lines . pressing enter in the fromula bar doen't work.
i want to know do i make my text fit into 1 block if it is a long sentance
needing two or three lines . pressing enter in the fromula bar doen't work.
Format>Cells>Alignment tab, check Wrap text
--
Kind regards,
Niek Otten
"Siwelile" <[email protected]> wrote in message
news:[email protected]...
>i want to know do i make my text fit into 1 block if it is a long sentance
> needing two or three lines . pressing enter in the fromula bar doen't
> work.
You can force text to wrap by inserting the vertical bar symbol "|" (above the backslash on most US keyboards.) You may have to adjust the cell height to see the second line.
---Glenn
Sorry, I guess my age is showing, I was thinking 1-2-3. Use Alt-Enter to force the line wrap within a cell in Excel...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks