View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
JLatham JLatham is offline
external usenet poster
 
Posts: 2,203
Default HOW TO MAKE A NUMBER OF CELLS INTO 1 BIG ONE AT THE BOTTEM

Barry, if you're not familiar with the procedu
type your sentence into a cell then select that cell and more to its right
until you have enough/the ones you want selected. The use the Format option
for cells to set horizontal alignment to "Center Across Selection".

A second option is to enter your sentence into a cell and set the cell's
"Text Wrap" option to 'false' (clear the checkbox next to "Text Wrap") and
simply make sure there are no entries in any cells to the right of it that
stop the display of the text.

"Fred Smith" wrote:

Use Center Across Selection in the Format dialogue box.

Regards,
Fred

"barry" wrote in message
...
I need to put a long sentence at the bottem across a number of cells, how
to
do it?


.