Now stop recording from the developer tab or status bar.If you want your shortcut to merge and center to work on every workbook then choose Personel Macro Workbook. If you want this macro to run on the current file then choose This Workbook in 'Store macro in:' section.if you want to involve SHIFT KEY, press SHIFT+J. I will use this as my shortcut of Merging cells.
DEVELOPER TAB EXCEL SHORTCUT FREE
There are some keys that are free in excel, Like CTRL+j. If you define any shortcut that is already defined then this will override the previous one.
To merge and center two or more cells follow these steps: Sequential Merge and Center shortcut in excel (ALT>H>M>C) The traditional way is lengthy and there is no simple shortcut to merge and center, like CTRL+C for copying. So when you work dashboards, you get the need for Merge and Center cells.
This is used to combine multiple cells into a single cell and create the main headers for reports in Microsoft Excel. This is a great way to create a label that spans multiple criteria. Merge & Center combine and center the contents of the selected cells in a new, larger cell.