ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   HOW TO MAKE A NUMBER OF CELLS INTO 1 BIG ONE AT THE BOTTEM (https://www.excelbanter.com/excel-discussion-misc-queries/260041-how-make-number-cells-into-1-big-one-bottem.html)

barry

HOW TO MAKE A NUMBER OF CELLS INTO 1 BIG ONE AT THE BOTTEM
 
I need to put a long sentence at the bottem across a number of cells, how to
do it?

Fred Smith[_4_]

HOW TO MAKE A NUMBER OF CELLS INTO 1 BIG ONE AT THE BOTTEM
 
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?



JLatham

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?


.



All times are GMT +1. The time now is 06:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com