Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 27th 05, 02:47 PM
lmark
 
Posts: n/a
Default 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   Report Post  
Old January 27th 05, 02:50 PM
Bernard Liengme
 
Posts: n/a
Default

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   Report Post  
Old January 27th 05, 02:53 PM
Peo Sjoblom
 
Posts: n/a
Default

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   Report Post  
Old January 27th 05, 03:15 PM
Bernard Liengme
 
Posts: n/a
Default

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   Report Post  
Old January 27th 05, 04:21 PM
cdb
 
Posts: n/a
Default

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   Report Post  
Old January 27th 05, 05:50 PM
Gord Dibben
 
Posts: n/a
Default

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   Report Post  
Old January 27th 05, 05:55 PM
Bernard Liengme
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to make empty cells as zero in excel add-ins for SQL Server an Microlong Excel Worksheet Functions 0 January 12th 05 06:31 AM
Layout/Formatting problems of Data Queries in Excel? Andrew Harding Excel Discussion (Misc queries) 0 December 23rd 04 03:51 AM
Refreshing Access data in Excel Jimmy G Excel Discussion (Misc queries) 0 December 21st 04 03:53 PM
linking cells in Excel 2003. How to not truncate to 255 characters. GarryFerg Excel Discussion (Misc queries) 5 December 8th 04 03:33 PM
stop excel from shifting cells up when a query returns no data DrLostinExcel Excel Worksheet Functions 2 November 9th 04 05:44 PM


All times are GMT +1. The time now is 06:53 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017