Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Oct 2004
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Merge & Center (2003)

    Does anyone know a good example of when to use merge & center versus when to use centering across a selection?

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Merge & Center (2003)

    Hi & welcome to the Lounge

    I would only use the merge option when the same task can not be completed with centering across a selection. This is because of a drawback with merged cells - you can not cut or copy rows or columns that intersect with merged cells.

  3. #3
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Merge & Center (2003)

    It annoys me that the default is now to Merge and Center instead of Center Across Selection, for the reasons Tony55 notes and because it messes up selecting columns, so I attach this macro to the Merge and Center Button.

    Sub CenterAcrossSelection()
    ' emulates Excel 5 center-across-cells toggle
    If ThisWorkbook.ProtectStructure Or _
    Worksheets(ActiveSheet.Name).ProtectContents = True Or _
    TypeName(Selection) <> "Range" Then
    Beep
    Else
    With Selection
    If .HorizontalAlignment = xlCenterAcrossSelection Then
    .HorizontalAlignment = xlGeneral
    Else
    .HorizontalAlignment = xlCenterAcrossSelection
    End If
    .MergeCells = False
    End With
    End If
    End Sub

    (It's edited from my actual version, but fixing any errors should be easy.)
    -John ... I float in liquid gardens
    UTC -7ąDS

  4. #4
    5 Star Lounger
    Join Date
    Apr 2001
    Location
    Arriving Somewhere but not Here
    Posts
    698
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Merge & Center (2003)

    When merged cells are selected the selection border is placed around all the cells whereas if the cells are just centered across the selection border is around just the first cell. In the latter case cell contents can get partially obscured by the selection border. That is to say things can look tidier if cells are merged.

    However, for all the reasons already given I've avoided 'merge and center' like the plague and, like John, I have replaced the default with my own custom code to 'center across' . I think I've only ever used the merge option once and that was for the cosmetic reasons outlined above. I used a sheet as a simple form for users to populate with personal details before using the rest of the workbook because it was quick and dirty, I ought to have done the job properly and created a VBA form to capture the details.

    stuck

Posting Permissions

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