- #Shortcut key for merge and center in excel 2013 how to
- #Shortcut key for merge and center in excel 2013 code
- #Shortcut key for merge and center in excel 2013 password
You can further bring down the effort from two to one-click by adding the Wrap text option to the Quick Access Toolbar. You will get the final result as shown below.
Since this is something you may need to do quite often, there is easy access to quickly wrap the text with a click on a button.
#Shortcut key for merge and center in excel 2013 password
#Shortcut key for merge and center in excel 2013 code
Then save and close this code window, and go on pressing Alt + F8 to open the Macro dialog box, click Options button to go to the Macro Options dialog box, and then enter a customized shortcut key you would like, see screenshots:Ĥ. Click Insert > Module, and paste the following code in the Module Window. Hold down the ALT + F11 keys to open the Microsoft Visual Basic for Applications window.Ģ. If the above shortcut keys are too long to remember, here, you can create a custom simple shortcut keys for using.ġ. And then, please go on pressing M > C successively to merge and center the selected cells. Then, press H key on the keyboard to choose the Home tab, and you can see the M letter below the Merge & Center feature, see screenshot:ģ. Firstly, select the cells that you want to merge, then press Alt key, the letters will be displayed on the ribbon as below screenshot shown:Ģ. Normally, there is a default shortcut ( Alt > H > M > C sequentially) for merging and centering selected cells, please do as this:ġ. Merge and center cells by adding the Merge &Center function to Quick Access Toolbar Merge and center cells by custom shortcut keys Merge and center cells by normal shortcut keys But if you need to use this feature frequently, here, I will introduce some shortcut keys for solving this job. Normally, you can use the Merge &Center function from the ribbon to merge and center multiple cells together.
#Shortcut key for merge and center in excel 2013 how to
How to merge and center cells by shortcut keys in Excel?