What Excel merges a cell shortcut key

what Excel merges a cell shortcut key

Excel merge cell shortcuts need to be set in the following ways:

1, open Excel, select Tools-click "Custom". A "Custom" form appears. Ignore this form and there are no items to choose from.

2, right click on the "merged cells" icon. Found no, and the normal right to hit different!

3, select the "Always use Text only" option. At this time is usually used to merge the button into a "merge and center (m)", this (m) is the shortcut you want, now click to close, then select several cells, and then press the combination of key: Alt+m, you can merge center.

4, is now set up to complete. The shortcut keys for Excel merged cells are alt+m.

A, click menu: Tools---Customize and then select the Merge and center button right click to select "Always use text" to exit the customization, press ALT+M is the combination and center of the shortcut, you can also enter the name box you want the shortcut Czech (&a).

b, set the merged cell shortcuts and split are alt+m, but can not be used directly, you need to set up. You can also set the other keys as the shortcut keys for merging cells.

C, you can customize one: right-click any of the toolbar, select Custom (C) ..., select the Commands tab, category format, select the Merge Cells button in the command to drag it to the appropriate location of the toolbar, and then close the Customize window to use.

D, Excel has a Super shortcut key F4, you can repeat the previous move. For example: Select cells A1 to B1, merge cells, right hand with the mouse to select C2 to D3, the left hand press the F4 key, the right hand then select, left hand F4.