Prev: Converting excel 2007 to tab delimeter text file
Next: make camera object refer to dynamic range
From: barry on 26 Mar 2010 19:24
I need to put a long sentence at the bottem across a number of cells, how to
do it?
From: Fred Smith on 26 Mar 2010 19:58
Use Center Across Selection in the Format dialogue box.

Regards,
Fred

"barry" <barry(a)discussions.microsoft.com> wrote in message
news:0783DA99-AC9C-46F2-9963-F2E11D673AC3(a)microsoft.com...
>I need to put a long sentence at the bottem across a number of cells, how
>to
> do it?

From: JLatham on 26 Mar 2010 22:51
Barry, if you're not familiar with the procedure:
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" <barry(a)discussions.microsoft.com> wrote in message
> news:0783DA99-AC9C-46F2-9963-F2E11D673AC3(a)microsoft.com...
> >I need to put a long sentence at the bottem across a number of cells, how
> >to
> > do it?
>
> .
>
 | 
Pages: 1
Prev: Converting excel 2007 to tab delimeter text file
Next: make camera object refer to dynamic range