| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
|
#5
|
|||
|
|||
|
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 |
|
#6
|
|||
|
|||
|
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. |
|
#7
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to make empty cells as zero in excel add-ins for SQL Server an | Excel Worksheet Functions | |||
| Layout/Formatting problems of Data Queries in Excel? | Excel Discussion (Misc queries) | |||
| Refreshing Access data in Excel | Excel Discussion (Misc queries) | |||
| linking cells in Excel 2003. How to not truncate to 255 characters. | Excel Discussion (Misc queries) | |||
| stop excel from shifting cells up when a query returns no data | Excel Worksheet Functions | |||
Hybrid Mode
