+ Reply to Thread
Results 1 to 2 of 2

Merge & Center random cells

  1. #1
    Forum Contributor
    Join Date
    11-20-2009
    Location
    Melbourne
    MS-Off Ver
    Excel 365
    Posts
    288

    Merge & Center random cells

    I have data on for example Rows 1, 3, 9, 14 and 17.
    Is there a simpler way, whereby I can merge and center the data in each row across 4 columns.
    I have many more rows that I need to do this with so I was hoping there was a simple way of selecting the different rows and then Merge and Center quickly.
    Thank you for any advice you may offer. I have attached a sample of what I have before and what I want after.MergeCenter.xlsx

  2. #2
    Registered User
    Join Date
    01-19-2015
    Location
    Poland
    MS-Off Ver
    2013
    Posts
    59

    Re: Merge & Center random cells

    Hi,

    Maybe this will help you.(but it's a solution without merging cells)
    1. Select columns from A to D.
    2. Right-click on the selection, choose "Format cells" from a pop-up menu, and click "Alignment" tab.
    3. Then, in "Text alignment"/Horizontal combobox select "Center Across Selection".

    P.S. I use Excel 2013, but I think this option is also in 2010 version.

    Regards,
    Alex

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel VBA: Merge and Center Cells Based on Date Values in Row Below
    By excelforumkeys in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-27-2014, 11:23 AM
  2. [SOLVED] Merge and Center all cells within a border
    By rfaris in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-06-2013, 06:15 PM
  3. Allow Merge and Center in Formatted Cells
    By Mneubert in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-18-2013, 03:45 PM
  4. Merge and Center Multiple Cells with the same data with a button click
    By caliskier in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-31-2012, 06:01 PM
  5. merge and center cells using macro
    By iscar_marius in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-13-2009, 03:42 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1