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. How to merge and center cells by shortcut keys in Excel?
0 Comments
Leave a Reply. |