Shortcut For Align Left In Excel How To Use The

Once we execute the function using short cut keys, it will pop up an alert message which says merging the cells will keep only Upper cell value and discard the other cells value.

If we proceed, the cell will be merged keeping only one value to be seen.

ALT H M C will only Merge and Center, ALT H M A will Merge Across and to unmerge press ALT H M U.

Shortcut For Align Left In Excel How To Use The

Let understand how to use the shortcut keys to merge cells in excel.

In order to make the YEAR the main heading more beautiful, we need to merge the YEAR cell all the way through to the year numbers.

In this case, I want to merge YEAR main heading from the cell B1 to E1.

It will recall the previous action you performed in the previous action.

If you want to unmerge portion of the worksheet select that portion or else if you want to unmerge all the merged cells in the worksheet then select the entire worksheet.

Here we discuss how to use Shortcut keys to Merge Cells in Excel and its limitations along with practical examples and downloadable excel template.

By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy.

Shortcut For Align Left In Excel Mac