Results 1 to 3 of 3
  1. #1
    Silver Lounger t8ntlikly's Avatar
    Join Date
    Dec 2001
    Location
    Chandler, AZ
    Posts
    2,162
    Thanks
    46
    Thanked 13 Times in 11 Posts

    Merge and Center (Excel '03)

    I have a two columns of cells that I want to merge and center independently of each other columns D and E, Rows 7:40. I noticed that when I hold down the Ctrl key and highlight those cells, then release the ctrl key and click on the merge and center button it does what I want. However when I hold the shift key and do the same thing, then release the shift key, and click merge and center all of the cells merge together. Is there an easier way to do this, or is that just the way it is.
    Thanks John
    Teamwork is essential; it gives the enemy other people to shoot at. (Murphy's War Laws #39)

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Merge and Center (Excel '03)

    There is a toolbar button called "Merge across" which is what I think you want. It does merge everything selected into 1 cell, but merges each row together.

    You can add it easily to a toolbar:
    View - toolbars -customize
    Commands (tab)
    "Format" (category)
    [About half-way down the commands is "Merge Across"]
    Drag it to a toolbar
    <Close>

    The item will remain on your toolbar even after quitting and restarting. If you highlight a range and select this icon, you will merge across the columns in a row and not merge between rows.

    Steve

  3. #3
    Silver Lounger t8ntlikly's Avatar
    Join Date
    Dec 2001
    Location
    Chandler, AZ
    Posts
    2,162
    Thanks
    46
    Thanked 13 Times in 11 Posts

    Re: Merge and Center (Excel '03)

    Thanks Steve, That is what I wanted.
    Thanks John
    Teamwork is essential; it gives the enemy other people to shoot at. (Murphy's War Laws #39)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •