#SHORTCUT KEYS FOR MERGING CELLS IN EXCEL FULL#

This is not a default shortcut key but some third party add-ins use this for performing a full calculation of 'all' the cells in just the 'active' workbook.įull Recalculation. Moves to the previous open workbook or window. Selects the next empty cell on the left inside the used range of the active worksheet. Calculates All the worksheets in All the open workbooks.ĭisplays the drop-down menu for the smart tag indicator that is showing in the active cell.ĭisplays the Create Names from Selection dialog box. Toggles between the Visual Basic Editor window and the Excel window.įull Calculation. Toggles between maximising and restoring the size of the active workbook or window.Ĭreates an Embedded Chart (on the active worksheet) using the highlighted range as the data source. Minimises the size of the active workbook or window. Moves to the next open workbook or window.

Restores the size of the active workbook or window. Displays the Save As dialog box when its a new workbook.ĭisplays the Print Options on the File tab.Ĭloses the active workbook or window (saving first). Inserts a new worksheet (before the active sheet) into the active workbook. Calculates the Active / Selected worksheets in the Active workbook.ĭisplays the Shortcut menu for the selected item. You will see the text 'Add to Selection' appear in the status bar.

This allows you to select non contiguous blocks of cells using the keyboard arrow keys. Toggles between switching Add Mode on or off. If the worksheet has been split then each separate pane is included. If a task pane is displayed this is included. Switches between the following items: worksheet, ribbon and status bar zoom. Selects the next empty cell on the right inside the used range of the active worksheet.ĭisplays the Find and Replace dialog box with the Find tab active. Toggles the display of the ribbon shortcut keys, otherwise known as Access Keys.Ĭreates a chart (on a separate chart sheet) using the highlighted range as the data source.ĭisplays the Insert Function dialog box (can be used from the formula bar). Replaces the highlighted part of a formula with its result to help debug when using the formula bar. (only cells containing formulas that have changed since the last calculation will be updated). You will see the text 'Extend Selection' appear in the status bar. Toggles whether to extend a selection with the arrow keys.

Moves to the next item (worksheet, ribbon, task pane). When you are editing a cell this toggles between relative, absolute and mixed cell references. When you are not editing a cell this repeats the last command or action. This dialog box is only displayed if the active workbook contains at least one named range. If this option is not checked the cursor will move to the Formula Bar.ĭisplays the Paste Name dialog box.

(Advanced, Editing options - allow editing directly in cells). This is only available when the following option is ticked. This is a complete list of all the shortcut keys in Excel.Īllows you to edit the active cell directly, putting the cursor at the end.

Shortcut keys for merging cells in excel