Shortcut Key for Merge

[melnikok]

I need to merge a ton of different cells. I was wondering if anyone know of a key stroke so I don't have to bring down the format menu everytime. I using the alt-M right now when the menu is open but clicking the menu and then alt-m and then enter is getting old. Any help will be appreciated.

[Andy Pope]

Do the merge and then repeat using F4

Other wise you could use a simple macro and assign it a keystroke combination

Please Login or Register  to view this content.

[melnikok]

Of all the complicated things I can do in Excel, sometimes I forget the easy stuff. The F4 works great. I have serveral cells to merge and 100's of spreadsheets, all with different names, to work in. This has decreased my time in each spreadsheet. Thanks!