Results 1 to 7 of 7

keyboard shortcut to merge cells?

This is a discussion on keyboard shortcut to merge cells? within the Excel Questions forums, part of the Question Forums category; Is there a keyboard shortcut to merge two contiguous cells? I've inherited something that has tiny column after tiny column ...

  1. #1
    Board Regular
    Join Date
    Jul 2004
    Posts
    113

    Default keyboard shortcut to merge cells?

    Is there a keyboard shortcut to merge two contiguous cells? I've inherited something that has tiny column after tiny column of split cells, and the boss wants the cells merged into single cells within each column.

    Rebuilding the whole thing isn't an attractive option because of some other stuff not related to this issue.

    I'm just trying to find a way to highlight the cells and merge them, all on the keyboard, instead of back and forth from keyboard to mouse over and over and over and over. I've looked in the onboard help but found nothing on this.

    Thanks!

  2. #2
    Board Regular schielrn's Avatar
    Join Date
    Apr 2007
    Location
    Cincinnati, Ohio
    Posts
    6,924

    Default

    Excel does not have a keyboard shortcut for merging cells.

    A quick search on google provided me with this link that might be useful for you.

    http://exceltips.vitalnews.com/Pages...rge_Cells.html

    Then you can set the macro to a short cut key.
    Always make a back up copy before trying new code, you never know what you might lose!


    - Posting guidelines, forum rules and terms of use

    -Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes

    "The world suffers a lot. Not because of the violence of bad people, but because of the silence of good people!"

  3. #3
    MrExcel MVP
    Moderator
    Smitty's Avatar
    Join Date
    May 2003
    Location
    Crested Butte, CO
    Posts
    27,104

    Default

    You can just add a shortut to this:

    Code:
    Selection.MergeCells = True
    Although if you give more detail as to the range(s) to be merged someone may be able to whip up a code solution.

    HTH,

    Smitty
    Smitty

    Every once in a while, there's a sudden gust of gravity...

    Check out my new book at the Mr. Excel Bookstore!

    Mr. Excel HTML Maker - Post a shot of your sheet

  4. #4
    Board Regular
    Join Date
    Jul 2004
    Posts
    113

    Default

    I have a boilerplate calendar, created in Excel, that the boss wants me to tweak to meet some specific needs. It was created somewhere else. One thing in it is that each date box has five rows for data and each row is split into two cells. I have to make each row one single cell.

    I've had intermittent luck using the ctrl key to highlight a group of two-cell rows and then clicking the Merge button on the toolbar to convert them to single-cell rows in "bulk". Sometimes that works and other times it just sits there and stares blankly at me. I've been using computers long enough to know there's probably something I'm doing wrong or different those times when it doesn't work, but I can't figure out what.

    But I digress.

    So that's what I'm trying to do, which is why it would be lot easier if there were a keyboard method, instead of back and forth to the mouse (trackball in my case). Ah, it's times like this when I long for the days of command line interface...

    (PS: Congratulations, Smitty, on the MVP!)

  5. #5
    MrExcel MVP
    Moderator
    Smitty's Avatar
    Join Date
    May 2003
    Location
    Crested Butte, CO
    Posts
    27,104

    Default

    This may seem like a silly question, but why not select all, then unmerge?

    Otherwise you can use SHIFT+Arrow to select the offending cells then add a keyboard shortcut to the above...

    Smitty

    (Thanks! )
    Smitty

    Every once in a while, there's a sudden gust of gravity...

    Check out my new book at the Mr. Excel Bookstore!

    Mr. Excel HTML Maker - Post a shot of your sheet

  6. #6
    Board Regular PA HS Teacher's Avatar
    Join Date
    Jul 2004
    Location
    Rochester, NY
    Posts
    2,838

    Default

    You may find the F4 key useful.

    If you peform some any type of formatting, (including merging cells), then select another cell or cells, pressing F4 will apply the same formatting change to those cells.

    Not knowing the layout of your sheet, I would, Peform a Merge on one block of cells.

    Then I'd select the next block of cells. (using the arrow key and shift key to avoid the track ball as Smitty has suggested)

    Then I'd press F4,

    Move to the next blok of cells, press F4 and repeat.

    If this was many thousands of cells, that follow a regular pattern, I'd write a little code.

    The F4 key is great for this kind of stuff.
    Recent Draftee
    www.mrexcel.com/board2/viewtopic.php?t=199272
    Recently came across a Free 1 GB Storage/File Sharing Site www.box.net

  7. #7
    Board Regular
    Join Date
    Jul 2004
    Posts
    113

    Default

    Smitty, the do-a-bunch-at-once technique is the one I was talking about when I said it works sometimes and other times not. I'm sure it has to be a user error, but what, I don't know since it seems pretty capricious.

    Teacher, I tried the F4 thing but it wonked up to calendar formatting, which I think probably has to do with some setting that was inherited with the calendar before I ever got it.

    I tried just copying and inserting a merged 1-from-2 cell 12 times in a square, but that too chingered the formatting, and I spent more time putting that back right than I would have doing the merge line by line.

    I think I may see how long my luck will hold trying it again with the do-a-bunch-at-once technique again.

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com