Microsoft Excel shortcuts

Enter edit mode in the active cell without touching the mouse.

Close the current workbook without exiting Excel.

Open an existing workbook in Excel.

Navigate to the Home tab in the Excel ribbon using the keyboard.

Delete the content of the selected cell(s) without affecting formatting or comments.

Open the Insert tab in the ribbon to add tables, charts, pictures, and other elements.

Switch to the Page Layout tab in the Excel ribbon.

Switch focus to the Data tab in the Excel ribbon.

Switch to the View tab in the Excel ribbon using the keyboard.

Opens the context menu for the selected item, equivalent to a right-click.

Opens the context menu for the selected item, equivalent to a right-click.

Delete the selected column in an Excel worksheet.

Press Alt + M to navigate directly to the Formula tab in the Excel ribbon.

Hide the currently selected rows in an Excel worksheet.

Press Alt+Q to jump to the 'Tell me' or 'Search' field on the ribbon in Office apps, then type your search term.

Open the File menu in the active application to access file-related options like New, Open, Save, and Print.

Press Alt + H to open the Home tab in the ribbon, then use additional keys to format text, numbers, or access the Find tool.

Open the Insert tab in the ribbon to access PivotTables, charts, add-ins, Sparklines, pictures, shapes, and more.

Opens the Formulas tab in Excel, allowing you to insert functions, trace precedents/dependents, and customize calculations.

Opens the Review tab in the ribbon, providing access to spelling check, notes, threaded comments, and sheet protection.

Open the View tab in the ribbon to preview page breaks and layouts, and toggle gridlines and headings on or off.

Press Alt to move focus to the ribbon and display key tips for ribbon tabs and commands.

Press F10 to activate the ribbon, then use arrow keys to move between tabs.

Press Tab to move the focus to commands on the ribbon or add-in pane in Microsoft Excel.

Move the focus to commands on the ribbon or add-in pane.

Use the arrow keys to move focus between items on the ribbon in Microsoft Excel.

Displays a tooltip for the currently focused ribbon element in Microsoft Excel.

Press Space to activate the currently selected button or control in a dialog, menu, or ribbon.

Press Enter to activate the currently selected button or command in a dialog box, ribbon, or other interface.

Opens a dropdown list or menu for the currently selected command in Excel.

Opens the dropdown menu or list associated with the currently selected button in the Ribbon or dialog.

Toggle the ribbon between expanded and collapsed states to show or hide command tabs and groups.

When a main menu is open or selected, press ← to move to its submenu.

Move the focus from one group of controls to the previous group in a dialog or form.

Move focus from one group of controls to the next group to the right.

Move the active cell up by one row in the worksheet.

Moves the active cell one column to the right within the current worksheet.

Ctrl+Arrow moves the active cell to the edge of the current data region (the last non-empty cell in that direction).

Press End then Arrow key to enter End mode and jump to the next nonblank cell in the same column or row. If cells are blank, moves to the last cell in the row or column. End mode turns off after the move.

Move the active cell to the last cell on the worksheet, which is the intersection of the lowest used row and the rightmost used column.

Move the active cell to the top-left cell (A1) of the worksheet.

Scroll the worksheet view down by one screenful.

Switch to the next worksheet in the current workbook.

Zoom in on the worksheet to get a closer view of cell content.

Zoom out of the current worksheet or document.

Insert a new threaded comment or open and reply to an existing one in supported apps like Microsoft Word or Outlook.

Open the Delete dialog box to remove selected cells.

Cycle through hiding objects, displaying objects, and showing placeholders for objects.

Show or hide outline symbols (grouping indicators) in the current worksheet or document.

Open the Insert Hyperlink dialog box to add or edit a hyperlink in the selected cell.

Selects all cells in the active worksheet.

Selects the current sheet and the next sheet in the workbook, creating a group selection.

Selects the current sheet and the previous sheet in a workbook, creating a group of two sheets.

Extends the current cell selection from the active cell to the first cell (A1) of the worksheet.

When a menu or submenu is open, press Home to select the first command.

Toggle the formula bar between expanded and collapsed states to view or edit long formulas.

Move the selected table to a new location in the worksheet.

Navigates to the topmost cell in the currently selected column.

Moves the active cell to the last cell in the current column that contains data or formatting.

Open the Go To dialog box to quickly navigate to a specific cell, range, or named reference.

Enter edit mode in the active cell without touching the mouse.

Save the current workbook with its current file name and location.

Copies the selected content to the clipboard.

Pastes the content from the clipboard at the cursor location.

Reverses the last action performed in Excel, such as typing, formatting, or deletion.

Delete the content of the selected cell(s) without affecting formatting or comments.

Open the fill color palette to apply background color to selected cells.

Removes the selected content and copies it to the clipboard.

Toggle bold formatting on selected text or cell content.

Center the text or value in the selected cell(s) horizontally.

Opens the context menu for the selected item, equivalent to a right-click.

Opens the context menu for the selected item, equivalent to a right-click.

Apply or customize cell borders in Excel.

Delete the selected column in an Excel worksheet.

Hide the currently selected rows in an Excel worksheet.

Hide the currently selected columns in an Excel worksheet.

Press Alt + H to open the Home tab in the ribbon, then use additional keys to format text, numbers, or access the Find tool.

Opens the Formulas tab in Excel, allowing you to insert functions, trace precedents/dependents, and customize calculations.

Opens the Review tab in the ribbon, providing access to spelling check, notes, threaded comments, and sheet protection.

Open the Format Cells dialog box with the Font tab selected to change font settings.

Open the Format Cells dialog box and navigate to the Font tab to change font settings.

Insert a new note or open and edit an existing cell note in Excel.

Insert a new threaded comment or open and reply to an existing one in supported apps like Microsoft Word or Outlook.

Open the Delete dialog box to remove selected cells.

Inserts the current time into a document or text field.

Insert the current date into a document, spreadsheet, or text field.

Opens the Paste Special dialog box, allowing you to choose how to paste copied content (e.g., values, formats, formulas).

Toggle italic formatting on selected text.

Toggle bold formatting on selected text or remove existing bold formatting.

Underline selected text or remove underline from selected text.

Toggle strikethrough on selected text in supported applications.

Applies the Currency number format with two decimal places and encloses negative numbers in parentheses.

Apply the Scientific number format with two decimal places to the selected cell(s).

Apply the time format displaying hour, minute, and AM/PM designation to the selected cell or content.

Open the Insert Hyperlink dialog box to add or edit a hyperlink in the selected cell.

Opens the Spelling dialog to check spelling in the active worksheet or selected range.

Selects all cells in the active worksheet.

Extends the current cell selection by one cell in the direction of the arrow key.

Extends the selection from the active cell to the last nonblank cell in the same column or row. If the next cell is blank, extends to the next nonblank cell.

Press F8 to turn extend mode on, then use arrow keys to extend the selection. Press F8 again to turn off.

Insert a line break within a cell to create multi-line text.

Enter the same data into multiple selected cells at once. After typing the value, press Ctrl+Enter to fill all selected cells with that entry.

Repeats the last command or action performed in Excel, if possible.

Toggle the formula bar between expanded and collapsed states to view or edit long formulas.

After typing a function name in a formula, press Ctrl+Shift+A to automatically insert the argument names and parentheses.

Automatically recognize patterns in adjacent columns and fill the current column based on the detected pattern.

Press F4 to toggle a selected cell reference or range in a formula between absolute ($A$1), mixed (A$1 or $A1), and relative (A1) references.

Copies the value from the cell directly above the active cell into the current cell or the formula bar.

Extends the selection from the current cell to the last used cell in the same row.

Extends the selection from the current cell to the first cell in the same row.

Close the current workbook without exiting Excel.

Toggle the ribbon between expanded and collapsed states to show or hide command tabs and groups.

Close the current workbook without exiting Excel.

Open an existing workbook in Excel.

Save the current workbook with its current file name and location.

Open the Insert tab in the ribbon to add tables, charts, pictures, and other elements.

Switch to the View tab in the Excel ribbon using the keyboard.

Opens the context menu for the selected item, equivalent to a right-click.

Opens the context menu for the selected item, equivalent to a right-click.

Open the File menu in the active application to access file-related options like New, Open, Save, and Print.

Open the View tab in the ribbon to preview page breaks and layouts, and toggle gridlines and headings on or off.

Inserts the current time into a document or text field.

Cycle through hiding objects, displaying objects, and showing placeholders for objects.

Show or hide outline symbols (grouping indicators) in the current worksheet or document.

Apply the time format displaying hour, minute, and AM/PM designation to the selected cell or content.

Press Ctrl+Esc to close a dialog box or cancel an ongoing process like a paste operation.

Open an existing workbook in Excel.

Opens the context menu for the selected item, equivalent to a right-click.

Open an existing workbook in Excel.

Navigate to the Home tab in the Excel ribbon using the keyboard.

Save the current workbook with its current file name and location.

Copies the selected content to the clipboard.

Pastes the content from the clipboard at the cursor location.

Reverses the last action performed in Excel, such as typing, formatting, or deletion.

Delete the content of the selected cell(s) without affecting formatting or comments.

Open the fill color palette to apply background color to selected cells.

Removes the selected content and copies it to the clipboard.

Open the Insert tab in the ribbon to add tables, charts, pictures, and other elements.

Toggle bold formatting on selected text or cell content.

Center the text or value in the selected cell(s) horizontally.

Switch to the Page Layout tab in the Excel ribbon.

Switch focus to the Data tab in the Excel ribbon.

Switch to the View tab in the Excel ribbon using the keyboard.

Apply or customize cell borders in Excel.

Delete the selected column in an Excel worksheet.

Press Alt + M to navigate directly to the Formula tab in the Excel ribbon.

Hide the currently selected rows in an Excel worksheet.

Hide the currently selected columns in an Excel worksheet.

Press Alt+Q to jump to the 'Tell me' or 'Search' field on the ribbon in Office apps, then type your search term.

Open the File menu in the active application to access file-related options like New, Open, Save, and Print.

Open the Insert tab in the ribbon to access PivotTables, charts, add-ins, Sparklines, pictures, shapes, and more.

Opens the Formulas tab in Excel, allowing you to insert functions, trace precedents/dependents, and customize calculations.

Opens the Review tab in the ribbon, providing access to spelling check, notes, threaded comments, and sheet protection.

Open the View tab in the ribbon to preview page breaks and layouts, and toggle gridlines and headings on or off.

Press Alt to move focus to the ribbon and display key tips for ribbon tabs and commands.

Zoom out of the current worksheet or document.

Insert a new threaded comment or open and reply to an existing one in supported apps like Microsoft Word or Outlook.

Inserts the current time into a document or text field.

Insert the current date into a document, spreadsheet, or text field.

Toggle italic formatting on selected text.

Toggle bold formatting on selected text or remove existing bold formatting.

Underline selected text or remove underline from selected text.

Applies the Currency number format with two decimal places and encloses negative numbers in parentheses.

Apply the Percentage number format to selected cells, displaying values as percentages with zero decimal places.

Apply the Scientific number format with two decimal places to the selected cell(s).

Applies the Number format with two decimal places, thousands separator, and minus sign for negative values.

Open the Workbook Statistics dialog box to view details about the current workbook, such as the number of sheets, cells, formulas, and more.

Selects all cells in the active worksheet, including the entire data range and empty cells.

Completes the current cell entry and moves the selection to the cell directly above.

Selects the entire column of the active cell in an Excel worksheet.

Selects the entire contiguous data region (range of cells surrounded by empty rows and columns) around the active cell.

Repeats the last command or action performed in Excel, if possible.

Press F9 to recalculate all worksheets in all open workbooks.

Forces a full recalculation of all worksheets in every open workbook, ignoring the 'changed since last calculation' flag.

Automatically recognize patterns in adjacent columns and fill the current column based on the detected pattern.

Inserts a chart as an object in the current worksheet using the selected data range.

Open the New Name dialog to define a named range or constant for use in formulas.

Refreshes the data in the active worksheet, updating external data connections and recalculating formulas.

Refreshes all data connections and queries in the current workbook.

Press Ctrl+Esc to close a dialog box or cancel an ongoing process like a paste operation.

Copies the selected content to the clipboard.

Pastes the content from the clipboard at the cursor location.

Reverses the last action performed in Excel, such as typing, formatting, or deletion.

Removes the selected content and copies it to the clipboard.

Copies the formula from the cell directly above the active cell into the current cell or the formula bar.

Opens the Paste Special dialog box, allowing you to choose how to paste copied content (e.g., values, formats, formulas).

Opens the context menu for the selected item, equivalent to a right-click.

Press Alt+Q to jump to the 'Tell me' or 'Search' field on the ribbon in Office apps, then type your search term.

Open the File menu in the active application to access file-related options like New, Open, Save, and Print.

Press Alt + H to open the Home tab in the ribbon, then use additional keys to format text, numbers, or access the Find tool.

Open the Insert tab in the ribbon to access PivotTables, charts, add-ins, Sparklines, pictures, shapes, and more.

Opens the Formulas tab in Excel, allowing you to insert functions, trace precedents/dependents, and customize calculations.

Opens the Review tab in the ribbon, providing access to spelling check, notes, threaded comments, and sheet protection.

Open the View tab in the ribbon to preview page breaks and layouts, and toggle gridlines and headings on or off.

Press Alt to move focus to the ribbon and display key tips for ribbon tabs and commands.

Press F10 to activate the ribbon, then use arrow keys to move between tabs.

Press Tab to move the focus to commands on the ribbon or add-in pane in Microsoft Excel.

Move the focus to commands on the ribbon or add-in pane.

Use the arrow keys to move focus between items on the ribbon in Microsoft Excel.

Displays a tooltip for the currently focused ribbon element in Microsoft Excel.

Press Space to activate the currently selected button or control in a dialog, menu, or ribbon.

Press Enter to activate the currently selected button or command in a dialog box, ribbon, or other interface.

Opens a dropdown list or menu for the currently selected command in Excel.

Opens the dropdown menu or list associated with the currently selected button in the Ribbon or dialog.

Toggle the ribbon between expanded and collapsed states to show or hide command tabs and groups.

When a main menu is open or selected, press ← to move to its submenu.

Switch to the next worksheet in the current workbook.

Insert a new threaded comment or open and reply to an existing one in supported apps like Microsoft Word or Outlook.

Cycle through hiding objects, displaying objects, and showing placeholders for objects.

Adds an outline border around the currently selected cells in Excel or similar spreadsheet applications.

Show or hide outline symbols (grouping indicators) in the current worksheet or document.

Open the Workbook Statistics dialog box to view details about the current workbook, such as the number of sheets, cells, formulas, and more.

When a menu or submenu is open, press Home to select the first command.

Repeats the last command or action performed in Excel, if possible.

Inserts a chart as an object in the current worksheet using the selected data range.

Inserts a chart of the selected data range into a new Chart sheet.

Open the Macro dialog to create, run, edit, or delete macros.

Open the Microsoft Visual Basic for Applications (VBA) editor to write and edit macros.

Open the Power Query Editor to transform and clean data.

Move the selected table to a new location in the worksheet.

Press F10 to activate the ribbon, then use arrow keys to move between tabs.

Switch to the next worksheet in the current workbook.

Displays a tooltip for the currently focused ribbon element in Microsoft Excel.

Zoom in on the worksheet to get a closer view of cell content.

Press Space to activate the currently selected button or control in a dialog, menu, or ribbon.

Press Enter to activate the currently selected button or command in a dialog box, ribbon, or other interface.

Opens a dropdown list or menu for the currently selected command in Excel.

Opens the dropdown menu or list associated with the currently selected button in the Ribbon or dialog.

Move the focus from one group of controls to the previous group in a dialog or form.

Move focus from one group of controls to the next group to the right.

Open the Format Cells dialog box to change cell formatting options like number, alignment, font, border, and fill.

Open the Format Cells dialog box with the Font tab selected to change font settings.

Open the Format Cells dialog box and navigate to the Font tab to change font settings.

Opens the Insert dialog box to add blank cells, rows, or columns in Excel.

Open the Delete dialog box to remove selected cells.

Opens the Paste Special dialog box, allowing you to choose how to paste copied content (e.g., values, formats, formulas).

Open the Insert Hyperlink dialog box to add or edit a hyperlink in the selected cell.

Open the Workbook Statistics dialog box to view details about the current workbook, such as the number of sheets, cells, formulas, and more.

Open the Paste Name dialog box and paste a defined name into a formula.

Press Ctrl+Esc to close a dialog box or cancel an ongoing process like a paste operation.

Open the Go To dialog box to quickly navigate to a specific cell, range, or named reference.

Move the active cell up by one row in the worksheet.

Moves the active cell one column to the right within the current worksheet.

Ctrl+Arrow moves the active cell to the edge of the current data region (the last non-empty cell in that direction).

Press End then Arrow key to enter End mode and jump to the next nonblank cell in the same column or row. If cells are blank, moves to the last cell in the row or column. End mode turns off after the move.

Move the active cell to the last cell on the worksheet, which is the intersection of the lowest used row and the rightmost used column.

Extends the current selection from the active cell to the last used cell (lower-right corner) of the worksheet.

Move the active cell to the top-left cell (A1) of the worksheet.

Scroll the worksheet view down by one screenful.

Open the Format Cells dialog box to change cell formatting options like number, alignment, font, border, and fill.

Insert a new note or open and edit an existing cell note in Excel.

Opens the Insert dialog box to add blank cells, rows, or columns in Excel.

Insert the current date into a document, spreadsheet, or text field.

Switch between displaying cell values and formulas in the active worksheet.

Copies the formula from the cell directly above the active cell into the current cell or the formula bar.

Cycle through hiding objects, displaying objects, and showing placeholders for objects.

Removes the outline border from the currently selected cells in a spreadsheet or table.

Show or hide outline symbols (grouping indicators) in the current worksheet or document.

Applies the Currency number format with two decimal places and encloses negative numbers in parentheses.

Apply the Percentage number format to selected cells, displaying values as percentages with zero decimal places.

Applies the date format displaying day, month, and year to the selected cell in Excel.

Apply the time format displaying hour, minute, and AM/PM designation to the selected cell or content.

Applies the Number format with two decimal places, thousands separator, and minus sign for negative values.

Opens the Spelling dialog to check spelling in the active worksheet or selected range.

Open the Quick Analysis tool for selected cells containing data.

Open the Workbook Statistics dialog box to view details about the current workbook, such as the number of sheets, cells, formulas, and more.

Selects all cells in the active worksheet, including the entire data range and empty cells.

Extends the current cell selection by one cell in the direction of the arrow key.

Extends the selection from the active cell to the last nonblank cell in the same column or row. If the next cell is blank, extends to the next nonblank cell.

Press F8 to turn extend mode on, then use arrow keys to extend the selection. Press F8 again to turn off.

Press Shift+F8 to add a non-adjacent cell or range to an existing selection using arrow keys.

Insert a line break within a cell to create multi-line text.

Enter the same data into multiple selected cells at once. After typing the value, press Ctrl+Enter to fill all selected cells with that entry.

Completes the current cell entry and moves the selection to the cell directly above.

Selects the entire column of the active cell in an Excel worksheet.

Selects the entire row of the active cell in an Excel worksheet.

Extends the current cell selection from the active cell to the first cell (A1) of the worksheet.

Selects the entire contiguous data region (range of cells surrounded by empty rows and columns) around the active cell.

Turn on or off tooltips that appear when checking formulas directly in cells.

Press F9 to recalculate all worksheets in all open workbooks.

Recalculates all formulas in the active worksheet.

Forces a full recalculation of all worksheets in every open workbook, ignoring the 'changed since last calculation' flag.

Forces a complete recalculation of all formulas in all open workbooks, including those that depend on other cells.

Opens the menu or message for the Error Checking button on a cell with a potential error.

After typing a function name in a formula, press Ctrl+Shift+A to automatically insert the argument names and parentheses.

Quickly insert the SUM formula to add up a range of cells.

Automatically recognize patterns in adjacent columns and fill the current column based on the detected pattern.

Press F4 to toggle a selected cell reference or range in a formula between absolute ($A$1), mixed (A$1 or $A1), and relative (A1) references.

Opens the Insert Function dialog to search and select a function.

Copies the value from the cell directly above the active cell into the current cell or the formula bar.

Inserts a chart as an object in the current worksheet using the selected data range.

Inserts a chart of the selected data range into a new Chart sheet.

Open the New Name dialog to define a named range or constant for use in formulas.

Open the Paste Name dialog box and paste a defined name into a formula.

Open the Microsoft Visual Basic for Applications (VBA) editor to write and edit macros.

Open the Power Query Editor to transform and clean data.

Refreshes the data in the active worksheet, updating external data connections and recalculating formulas.

Refreshes all data connections and queries in the current workbook.

Deletes the selected table in Excel.

Rename the active table in Excel.

Extends the selection from the active cell to the last used cell in the same column.

Extends the selection from the current cell to the first cell in the same column.

Extends the selection from the current cell to the last used cell in the same row.

Extends the selection from the current cell to the first cell in the same row.

Navigates to the topmost cell in the currently selected column.

Moves the active cell to the last cell in the current column that contains data or formatting.

Open the Go To dialog box to quickly navigate to a specific cell, range, or named reference.

Press End then Arrow key to enter End mode and jump to the next nonblank cell in the same column or row. If cells are blank, moves to the last cell in the row or column. End mode turns off after the move.

Extends the current selection from the active cell to the last used cell (lower-right corner) of the worksheet.

Insert a new note or open and edit an existing cell note in Excel.

Opens the Insert dialog box to add blank cells, rows, or columns in Excel.

Switch between displaying cell values and formulas in the active worksheet.

Copies the formula from the cell directly above the active cell into the current cell or the formula bar.

Removes the outline border from the currently selected cells in a spreadsheet or table.

Show or hide outline symbols (grouping indicators) in the current worksheet or document.

Applies the date format displaying day, month, and year to the selected cell in Excel.

Opens the Spelling dialog to check spelling in the active worksheet or selected range.

Open the Quick Analysis tool for selected cells containing data.

Open the Workbook Statistics dialog box to view details about the current workbook, such as the number of sheets, cells, formulas, and more.

Selects all cells in the active worksheet.

Selects all cells in the active worksheet, including the entire data range and empty cells.

Selects the current sheet and the next sheet in the workbook, creating a group selection.

Selects the current sheet and the previous sheet in a workbook, creating a group of two sheets.

Extends the current cell selection by one cell in the direction of the arrow key.

Extends the selection from the active cell to the last nonblank cell in the same column or row. If the next cell is blank, extends to the next nonblank cell.

Press F8 to turn extend mode on, then use arrow keys to extend the selection. Press F8 again to turn off.

Press Shift+F8 to add a non-adjacent cell or range to an existing selection using arrow keys.

Enter the same data into multiple selected cells at once. After typing the value, press Ctrl+Enter to fill all selected cells with that entry.

Completes the current cell entry and moves the selection to the cell directly above.

Selects the entire column of the active cell in an Excel worksheet.

Selects the entire row of the active cell in an Excel worksheet.

Extends the current cell selection from the active cell to the first cell (A1) of the worksheet.

Selects the entire contiguous data region (range of cells surrounded by empty rows and columns) around the active cell.

When a menu or submenu is open, press Home to select the first command.

Turn on or off tooltips that appear when checking formulas directly in cells.

Recalculates all formulas in the active worksheet.

Forces a complete recalculation of all formulas in all open workbooks, including those that depend on other cells.

Opens the menu or message for the Error Checking button on a cell with a potential error.

Quickly insert the SUM formula to add up a range of cells.

Opens the Insert Function dialog to search and select a function.

Inserts a chart of the selected data range into a new Chart sheet.

Refreshes all data connections and queries in the current workbook.

Deletes the selected table in Excel.

Move the selected table to a new location in the worksheet.

Rename the active table in Excel.

Extends the selection from the active cell to the last used cell in the same column.

Extends the selection from the current cell to the first cell in the same column.

Extends the selection from the current cell to the last used cell in the same row.

Extends the selection from the current cell to the first cell in the same row.

Zoom in on the worksheet to get a closer view of cell content.

Open the Format Cells dialog box to change cell formatting options like number, alignment, font, border, and fill.

Open the Format Cells dialog box with the Font tab selected to change font settings.

Open the Format Cells dialog box and navigate to the Font tab to change font settings.

Insert a new note or open and edit an existing cell note in Excel.

Opens the Insert dialog box to add blank cells, rows, or columns in Excel.

Switch between displaying cell values and formulas in the active worksheet.

Toggle italic formatting on selected text.

Toggle bold formatting on selected text or remove existing bold formatting.

Underline selected text or remove underline from selected text.

Toggle strikethrough on selected text in supported applications.

Cycle through hiding objects, displaying objects, and showing placeholders for objects.

Adds an outline border around the currently selected cells in Excel or similar spreadsheet applications.

Removes the outline border from the currently selected cells in a spreadsheet or table.

Apply the General number format to selected cells.

Applies the Currency number format with two decimal places and encloses negative numbers in parentheses.

Apply the Percentage number format to selected cells, displaying values as percentages with zero decimal places.

Apply the Scientific number format with two decimal places to the selected cell(s).

Applies the date format displaying day, month, and year to the selected cell in Excel.

Apply the time format displaying hour, minute, and AM/PM designation to the selected cell or content.

Applies the Number format with two decimal places, thousands separator, and minus sign for negative values.

Open the Quick Analysis tool for selected cells containing data.

Insert a line break within a cell to create multi-line text.

Selects the entire row of the active cell in an Excel worksheet.

Turn on or off tooltips that appear when checking formulas directly in cells.

Toggle the formula bar between expanded and collapsed states to view or edit long formulas.

Press F9 to recalculate all worksheets in all open workbooks.

Recalculates all formulas in the active worksheet.

Forces a full recalculation of all worksheets in every open workbook, ignoring the 'changed since last calculation' flag.

Forces a complete recalculation of all formulas in all open workbooks, including those that depend on other cells.

Opens the menu or message for the Error Checking button on a cell with a potential error.

After typing a function name in a formula, press Ctrl+Shift+A to automatically insert the argument names and parentheses.

Quickly insert the SUM formula to add up a range of cells.

Press F4 to toggle a selected cell reference or range in a formula between absolute ($A$1), mixed (A$1 or $A1), and relative (A1) references.

Opens the Insert Function dialog to search and select a function.

Copies the value from the cell directly above the active cell into the current cell or the formula bar.

Open the New Name dialog to define a named range or constant for use in formulas.

Open the Paste Name dialog box and paste a defined name into a formula.

Open the Power Query Editor to transform and clean data.

Open the Macro dialog to create, run, edit, or delete macros.

Open the Microsoft Visual Basic for Applications (VBA) editor to write and edit macros.

Scroll the worksheet view up by one screenful using the Page Up key.