How do I center data across multiple cells in excel without mergi.
 

How do I center data across multiple cells in excel without merging the cells
together

You don't

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"lmark" wrote in message
...
How do I center data across multiple cells in excel without merging the
cells
together

Select the cells in questions and do formatcellsalignment and check center
across selections

Regards,

Peo Sjoblom

"lmark" wrote:

How do I center data across multiple cells in excel without merging the cells
together

I find that this does a merge which the OP did not want.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Peo Sjoblom" wrote in message
...
Select the cells in questions and do formatcellsalignment and check
center
across selections

Regards,

Peo Sjoblom

"lmark" wrote:

How do I center data across multiple cells in excel without merging the
cells
together

It may look like it's merged the cells, but each cell is still treated as an
indiviual cell, so this method should work.

"Bernard Liengme" wrote:

I find that this does a merge which the OP did not want.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Peo Sjoblom" wrote in message
...
Select the cells in questions and do formatcellsalignment and check
center
across selections

Regards,

Peo Sjoblom

"lmark" wrote:

How do I center data across multiple cells in excel without merging the
cells
together

Bernard

Center across selection wipes the gridlines, but the individual cells are
preserved, unlike a true merge.


Gord

On Thu, 27 Jan 2005 11:15:37 -0400, "Bernard Liengme"
wrote:

I find that this does a merge which the OP did not want.

Thanks for clearing that up.
B

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Bernard

Center across selection wipes the gridlines, but the individual cells are
preserved, unlike a true merge.


Gord

On Thu, 27 Jan 2005 11:15:37 -0400, "Bernard Liengme"
wrote:

I find that this does a merge which the OP did not want.