Creating Shortcut key to merge cells

Last update on November 6, 2009 05:17 AM by jak58
Published by jak58

Creating Shortcut key to merge cells




Issue



If there a shortcut to be pressed on the keyboard to merge cells in excel? I was trying to find a code or any macro which will allow me to do this! Thanks for your help!

Solution


To do this, you will have to make a macro with your own shortcut key with codes..

I will advise you using these codes: 

sub macroMergeCells()
Selection.MergeCells = True
End sub

Note


Thanks to Excelguru for this tip on the forum.
Best answers for « Creating Shortcut key to merge cells » in :
Short cut to merge cells Show
Download Shortcut Key Explorer Show On any Windows user wants to create shortcut keys corresponding to their activities. But by dint of creating keystroke on eventually become confused and completely forget the shortcuts to be set by itself. Shortcut Key Explorer is a program to...
Dual monitor shortcut key Show
Creating an Hotmail shortcut on your desktop ShowCreating an Hotmail shortcut on your desktop Accessing your mailbox on Hotmail is time consuming; you can either add Hotmail.com to your Favorites or access it via instant messaging applications. The quickest method to access your mailbox...
Creating a shortcut to Control Panel option ShowCreating a shortcut to Control Panel option Below is a simple tips for creating a shortcut to Control Panel on your Desktop. Go to Menu Start and select/open Control Panel. Then select the option you want to create shortcut on...
Know your new Vista shortcut keys ShowKnow your new Vista shortcut keys Windows Vista has some new shortcut keys which are very useful if you want to access its new features more quickly especially when you are using Windows Vista on a laptop. Shortcut Keys
Download Clavier + ShowKeyboard + is a tool which allows you to associate all the touches of the keyboard with an action, including Windows key. The created shortcuts can be associated with a program or a particular text. To take a concrete example, create shortcut keys to...
Download CD-Eject Show
Download MultiStart Show
Partition - Partitioning a hard drive ShowWhat is a partition? The partitioning of a hard drive occurs after the drive has been physically formatted but before it is logically formatted. It involves creating areas on the disk where data will not be mixed. It can be used, for example, to...
Creating a local area network ShowWhy set up a local area network? When you have several computers, it can be convenient to connect them to each other to create a local area network (LAN). Setting up such a network costs very little, contrary to what people may think. Here are a...
Creating a LAN ShowWhy set up a LAN? If you have several computers, it may be worthwhile to connect them in order to create a local area network (LAN). Setting up such a network is much less expensive than what you might think. Here are a few ways you might benefit...
They need your help