Home > Alt Key Microsoft Excel Shortcuts

ALT Key Shortcuts for Excel

Please click on a header to see the shortcuts

Alt + Function

Alt + F1 Creates a chart (on a chart sheet) using the highlighted range

Alt + F2 Displays the (File > Save As) dialog box

Alt + F4 Closes all the workbooks (saving first) and exits Excel (File > Exit)

Alt + F8 Displays the (Tools > Macro > Macros) dialog box

Alt + F11 Toggles between the Visual Basic Editor window and and the Excel window

Alt + Ctrl + Function

Alt + Ctrl + F9 Calculates All cells on All worksheets in All workbooks

Alt + Shift + Function

Alt + Shift + F1 Inserts a new worksheet (before the active sheet) into the active workbook (Insert > Worksheet)

Alt + Shift + F2 Displays the (File > Save As) dialog box

Alt + Shift + F4 Closes all the workbooks (saving first) and exits Excel (File > Exit)

Alt + Shift + F10 Displays the drop-down menu for the corresponding smart tag

Alt + Shift + F11 Activates the Microsoft Script Editor window

ALT + Other

Alt + = Enters the SUM() function (AutoSum) to sum the adjacent block of cells

Alt + 0128 Enters the euro symbol (€) (using Number keypad)

Alt + 0162 Enters the cent symbol (¢) (using Number keypad)

Alt + 0163 Enters the pound sign symbol (£) (using Number keypad)

Alt + Enter Enters a new line (or carriage return) into a cell

Alt + Down Arrow Displays the Pick From List drop-down list Esc Cancels the cell entry and restores the original contents

Alt + ; Selects the visible cells in the current selection

Alt + ' Displays the Style dialog box

Alt + Tab Moves to the next application open on your computer

Alt + Page Down Moves you one screen of columns to the right

Alt + Page Up Moves you one screen of columns to the left

Alt + Ctrl + Left Arrow Moves to the left between non adjacent cells in a selection

Alt + Ctrl + Right Arrow Moves to the right between non adjacent cells in a selection

Alt Toggles the activation of the old Menu Bar

Alt + Shift + Left Arrow Displays the (Data > Group and Outline > UnGroup) dialog box

Alt + Shift + Right Arrow Displays the (Data > Group and Outline > Group) dialog box

Alt + Spacebar Activates the Control Box in the top left hand corner