Shortcuts of File, Ribbon, Drag and Drop, Active Cell, General, General Continued, Selection, Navigation, Extend Selection, Select Special, Cell Edit Mode, Entering data, Formatting, Number Formatting, Borders, Formulas, Grid Operations, Pivot Tables, Dialog Boxes, Workbook and Others. The data in the merged cell moves to the left cell when the cells split. Otherwise do this: Click the merged cell and click Home > Merge & Center. To unmerge cells immediately after merging them, press Ctrl + Z. CTRL + SHIFT + 2: Formats according to a chosen time format. If you change your mind, you can always undo the merge by clicking the merged cell and clicking Merge & Center. ALT + H + W (ALY key followed by the H and W keys) Wrap text with the Format. Good news is that you can use the below keyboard shortcut to quickly wrap text in all the selected cells.
Excel keyboard shortcuts – Microsoft Excel keyboard shortcuts for PC and Mac. The following shortcuts work to format data cells to a specific type in both Windows and macOS: CTRL + SHIFT + 1: Formats the data according to a chosen number format (e.g., moving decimal places). If you’re like me, leaving the keyboard and using a mouse to click even a single button could feel like a waste of time.
