Simply highlight all the cells to be merged, then click the Merge & Center icon. On the other hand, Format Cell or CTRL+1 provides option to merge & center a range of data. Though options like Merge & Center, keyboard Shortcuts execute merge & center only on one cell data at a time, these two methods are user-friendly in case of concise dataset. The “M” keyboard key is the shortcut to merge cells in Excel without a centered alignment. A quick and common way to merge cells is to use the Merge & Center command in the Home tab. Merge & Center is a handy tool to get an overview of any dataset.Press the “C” keyboard key, is the shortcut to merge cells in Excel after selecting them.Press the “A” key to merge cells within a separate individual row.We can make use of any of these keyboard shortcuts to merge cells in Excel:.Then press the “M” (keyboard shortcut) which enables the Excel “Merge & Center” option.įigure 6. Press the “ALT+H” keyboard keys to select the “Home” tab on the Excel ribbon this will enable the” Home” tab menu of Excel.We start by selecting those cells which we seek to merge and center via shortcut and then press the “ALT” keyboard key which toggles the keyboard commands on an Excel ribbon įigure 5.
I guess being new to the forums gives some type of advantage for being helpful as the two best solutions both came from noobs. mreed772: F4 is true brilliance as it can function as a shortcut key for multiple features.
We will now demonstrate how to use the keyboard shortcut to merge cells in Excel with the following simple steps Re: 'merge and center' keyboard shortcut. Note that the text becomes centered in worksheet example above screenshot. The merge and center function in excel will combine the selected data in one large cell