For Windows PC and Mac - all important keyboard shortcuts and formulas in Excel
Keyboard shortcuts and formulas are indispensable tools for working more efficiently in Microsoft Excel and increasing your productivity. Excel offers a wide range of shortcuts and formulas for a variety of functions, be it for formatting cells, inserting new worksheets, navigating in your worksheets or formulas for performing calculations. In our overview of the shortcuts in Excel , we summarize the most important shortcuts and formulas of the spreadsheet program for you.
Quick navigation to the desired Excel shortcut
15 frequently used shortcuts in Excel
| Description | Excel shortcuts Windows/PC | Excel shortcuts Mac |
| Open document | Ctrl + O | Command + O |
| Save document | Ctrl + S | Command + S |
| Repeat last action | Ctrl + Y | Command + Y |
| Step back | Ctrl + Z | Command + Z |
| Copy | Ctrl + C | Command + C |
| Paste | Ctrl + V | Command + V |
| Cut | Ctrl + X | Command + X |
| Copy cell contents to another cell | Ctrl + Drag selected cell to another cell | Option + Drag selected cell to another cell |
| Move cell contents | Drag selected cell to another cell | Drag selected cell to another cell |
| Add new row/column | Ctrl + + | Command + + |
| Delete row/column | Ctrl + - | Command + - |
| Create table from selected cells | Ctrl + T | Command + T |
| Insert line break in cell | Alt + Enter | Control + Option + Enter |
| Bold formatting | Ctrl + B | Command + B |
| Open context menu | Shift + F10 | Fn + F12 |
General keyboard shortcuts for Excel
Discover general keyboard shortcuts in Excel that make it easier for you to use the program. These shortcuts speed up the work process and allow you to execute commands quickly.
| Description | Excel shortcuts Windows/PC | Excel shortcuts Mac |
| Open document | Ctrl + O | Command + O |
| Save as | F12 | Command + Shift + S |
| New document | Ctrl + N | Command + N |
| Print document | Ctrl + P | Command + P |
| Close current document | Ctrl + W | Command + W |
| Close current document | Alt + F4 | Command + Q |
| Show/hide ribbon | Ctrl + F1 | Command + Option + R |
| Next ribbon control | Tab | Tab |
| Activate/open selected control | Spacebar | Spacebar |
| Options key | Alt + F + T | Command + , (comma) |
| Help key | F1 | Command + / |
Keyboard shortcuts for Excel functions in the menu
The menu in Excel houses a wealth of options, from basic editing functions to advanced formatting and analysis tools. This tutorial will focus on using shortcuts to navigate seamlessly through Excel's various menus.
| Description | Excel Shortcuts Windows/PC | Excel shortcuts Mac |
| Show/hide ribbon | Ctrl + F1 | Command + Option + R |
| Format cells | Ctrl + 1 | Command + 1 |
| Insert function | Shift + F3 | Shift + F3 |
| Quick analysis for selected data | Ctrl + Q | Control + Q |
| Create table | Ctrl + T | Control + T |
| Name Manager | Ctrl + F3 | F3 |
| Macro | Alt + F8 | Option + F8 |
| Microsoft Visual Basic for Applications | Alt + F11 | Option + F11 |
| Go to | Ctrl + G | Fn + F5 |
| Delete | Ctrl + - | Commund + - |
| Insert cells | Ctrl + + | Shift + Command + + |
| Spell check | F7 | Command + ; |
Excel shortcuts for selection options
The use of Excel is characterized by a large number of selection options and functions. Keyboard shortcuts offer an efficient method of accessing various selection options quickly and efficiently.
| Description | Excel shortcuts Windows/PC | Excel shortcuts Mac |
| Selects rows of the current cells | Shift + space bar | Shift + Spacebar |
| Selects columns of the current cells | Ctrl + Spacebar | Control + Spacebar |
| Selects all cells on a sheet | Ctrl + A | Command + A |
| Add adjacent cells to the selection | Shift + Click | Shift + Click |
| Add non-adjacent cells to the selection | Ctrl + Click | Command + click |
| Selects from current position to cell A1 | Ctrl + Shift + Pos1 | Shift + Command + Arrow up |
| Selects from current position to last entry | Ctrl + Shift + End | Shift + Command + down arrow |
| Same selection in next column | Option + Tab | |
| Same selection in previous column | Option + Shift + Tab | |
| Move right between non-adjacent selections | Ctrl + Alt + right arrow key | Control + Option + Right arrow key |
| Move left between non-adjacent selections | Ctrl + Alt + Left arrow key | Control + Option + left arrow key |
| Add to selection | Shift + F8 | Fn + Shift + F8 |
| Cancel selection | Esc | Esc |
| Extends selection in one direction | Shift + arrow key | Shift + arrow key |
| Extends selection to the next filled cell | Ctrl + Shift + Arrow key | Shift + Command + Arrow key |
| Extend selection mode | F8 then arrow keys | Fn + F8 then arrow keys |
| Select current area | Ctrl + A | Command + A |
| Select current field | Ctrl + / | Control + / |
| Select line differences | Ctrl + \ | Control + \ |
| Select column differences | Ctrl + Shift + | | Control + Shift + | |
Keyboard shortcuts for text and typography
The correct formatting of text and the design of typography are also crucial in Excel in order to present tables and worksheets clearly and professionally. In this context, keyboard shortcuts offer a practical method of controlling formatting and typography.
| Description | Excel shortcuts Windows/PC | Excel shortcuts Mac |
| Format all | Ctrl + 1 | Command + 1 |
| Format cells, show "Font" tab | Ctrl + Shift + F | Control + Shift + F |
| Apply/remove "Bold" formatting | Ctrl + B | Command + B |
| Apply/remove "Italic" formatting | Ctrl + I | Command + I |
| Apply/remove "Underline" formatting | Ctrl + U | Command + U |
| Apply/remove "Strikethrough" formatting | Ctrl + 5 | Command + Shift + X |
| Center | Alt + H + A + C | Command + E |
| Align left | Alt + H + A + L | Command + L |
| Align right | Alt + H + A + R | Command + R |
| Indent | Alt + H + 6 | Control + Option + Tab |
| Remove indentation | Alt + H + 5 | Control + Option + Shift + Tab |
| Increase font size by one | Alt + H + F + G | Command + Shift + > |
| Decrease font size by one | Alt + H + F + K | Command + Shift + < |
Shortcuts for formats
The correct formatting of numbers and data in Excel is crucial for presenting information clearly and comprehensibly. Formats such as percentage format, currency format and date format play an important role here. Shortcuts are a useful way to apply these formats quickly and accurately.
| Description | Excel shortcuts Windows/PC | Excel shortcuts Mac |
| Apply general format | Ctrl + Shift + ~ | Control + Shift + ~ |
| Apply currency format | Ctrl + Shift + $ | Control + Shift + $ |
| Apply percentage format | Ctrl + Shift + % | Control + Shift + % |
| Apply scientific format | Ctrl + Shift + ^ | Control + Shift + ^ |
| Apply date format | Ctrl + Shift + # | Control + Shift + # |
| Apply time format | Ctrl + Shift + @ | Control + Shift + @ |
| Apply number format | Ctrl + Shift + ! | Control + Shift + ! |
Keyboard shortcuts for dialog boxes
Dialog boxes play a crucial role in Excel as they allow for detailed settings and customizations. By using dialog boxes, users can select specific options and precisely configure their worksheets.
| Description | Excel shortcuts Windows/PC | Excel shortcuts Mac |
| Show "Insert Special" dialog box | Ctrl + Alt + V | Command + Control + V |
| Open "Insert function" dialog box | Shift + F3 | Fn + Shift + F3 |
| Show "Function arguments" dialog box | Ctrl + A | Control + A |
| Open "Insert" dialog box | Ctrl + Shift | Command + Shift |
| Show "Delete" dialog box | Ctrl + - | Command + - |
| Open "Group" dialog box | Alt + Shift + right arrow key | Command + Shift + K |
| Show "Ungroup" dialog box | Alt + Shift + left arrow key | Command + Shift + J |
| Open "Spelling" dialog box | F7 | Fn + F7 |
| Show "Thesaurus" dialog box | Shift + F7 | Fn + Shift + F7 |
| Open "Macro" dialog box | Alt + F8 | Fn + Option + F8 |
| Show "Change cell style" dialog box | Alt + ' | Command + Shift + L |
| Close dialog box | Esc | Esc |
Shortcuts for formulas
Formulas are at the heart of Excel and enable complex calculations and the automation of data processing. The use of formulas is essential in order to process data precisely and achieve meaningful results.
| Description | Excel Shortcuts Windows/PC | Excel shortcuts Mac |
| Copy formula from cell above | Ctrl + ' | Control + ' |
| Toggle formulas on and off | Ctrl + ` | Control + ` |
| Enter array formula | Ctrl + Shift + Enter | Control + Shift + Return |
| Evaluate part of a formula | F9 | Fn + F9 |
| Expand or collapse the formula bar | Ctrl + Shift + U | Control + Shift + U |
| Insert name in formula | F3 | |
| Display formulas | Ctrl + Shift + ' | Control + ` |
| Accept suggestion for function by autocomplete | Tab | Tab + down arrow key |
Position functions in Excel
Position functions are a key category of functions that allow you to retrieve or manipulate data based on its position in a table.
| Function | Function Description | Formula |
| REFERENCE | Finds unknown information based on known information and outputs the result. | =REFERENCE(search criterion; search vector; [result vector]) =REFERENCE(search criterion; matrix) |
| REFERENCE | Finds unknown information on the basis of known information and outputs the result (searches vertically in the first column). | SVERWEIS(search criterion; matrix; column index; [range_reference]) |
| REFERENCE | Finds unknown information on the basis of known information and outputs the result (searches horizontally in the first row). | WWEIS(search criterion; matrix; row index; [range_reference]) |
| INDEX | Goes to a position in a range based on a given row and column to a position and returns the value. | =INDEX(Matrix; Row; [Column]) =INDEX(Reference; Row; [Column]; [Range]) |
| COMPARE | Searches for a criterion and returns the relative position of the value. | COMPARE(search criterion; search matrix; [comparison type]) |
Basic functions in Excel
Basic functions are essential tools in Excel that are used to perform basic calculations or change data in a simple way.
| Function | Function Description | Formula |
| AND | Returns TRUE if all truth values are TRUE. | =AND(truth value1; [truth value2]; ...) |
| OR | Returns TRUE if at least one truth value is TRUE. | =OR(truth value1; [truth value2]; ...) |
| IF | Performs a truth check. | =WENN(Check; [Then_Value]; [Else_Value]) |
| MAX | Finds the largest value of a value set. | =MAX(number1; [number2]; ...) |
| MIN | Finds the smallest value of a value set. | =MIN(number1; [number2]; ...) |
| MAXA | Finds the largest value of a value set (including text and logical values). | =MAXA(value1; [value2]; ...) |
| MINA | Finds the smallest value of a value set (including text and logical values). | =MINA(value1; [value2]; ...) |
| KGLARGEST | Searches for the k largest number in a range (e.g. the third largest number). the third largest number) and returns it. | =KLARGEST(Matrix; k) |
| KKLEINST | Searches for the k smallest number in a range (e.g. the third smallest number) and returns it. the third smallest number) and returns it. | =KLEINST(Matrix; k) |
| RANGE.MOVE | Displays a reference that is offset from the specified reference | =RANGE.SHIFT(reference; rows; columns; [height]; [width]) |
Date functions in Excel
In Excel, date functions play a crucial role in the analysis and organization of time-related data. These functions can be used to change date values, perform calculations and track time intervals.
| Function | Function Description | Formula |
| DATE | Defines a date. | =DATE(year; month; day) |
| DAY | Converts a number into the day of a month (1 to 31). | =DAY(number) |
| DAYS | Calculates the number of days between two dates: | =DAYS(target date; source date) |
| MONTH | Converts a number into the month of a year (1 to 12). | =MONTH(number) |
| YEAR | Converts a number into a year (1900 to 9999). | =YEAR(number) |
| NOW | Displays the current date and time. | =NOW() |
| TODAY | Displays the current date. | =TODAY() |
| CALENDAR WEEK | Specifies the calendar week of a date (number_type for specifying the of the calendar week according to ISO 8601: 21). | =CALENDARWEEK(consecutive_number; [number_type]) |
| ISOCAL OF THE WEEK | Specifies the calendar week of a date according to ISO 8601. | =ISOCALENDERWEEK(date) |
| EDATUM | Indicates a date that is a number of months before or after the starting date. | =EDATUM(starting date; months) |
Calculation functions in Excel
Calculation functions in Excel form the basis for a wide range of calculatory tasks and data analyses. They enable complex calculations to be performed and data to be processed efficiently. Below you will find some basic calculation functions that you can use in Excel:
| Function | Function Description | Formula |
| SUM | Sums the values of a selected range. | =SUM(number1; [number2]; ...) |
| SUMWENN | Sums values that fulfill a search criterion. | =SUMWENN(range; search criteria; [sum_range]) |
| SUMWENNS | Sums values that fulfill several search criteria. | =SUMWENNS(sum_range; criteria_range1; criteria1; ...) |
| DBSUMME | Sums values that fulfill several search criteria. | =DBSUMME(database; database field; search criteria) |
| PRODUCT | Multiplies all values in a range. | =PRODUCT(number1; [number2]; ...) |
| QUOTIENT | Displays the result of a division (integer part). | =QUOTIENT(numerator; denominator) |
| AVERAGE | Displays the arithmetic mean: | =AVERAGE(number1; [number2]; ...) |
| STABWA | Estimates the standard deviation (for samples). | =STABWA(value1; [value2]; ...) |
| STABWNA | Calculates the standard deviation (for population). | =STABWNA(value1; [value2]; ...) |
| CONVERT | Switches from one measurement system to another. | =CONVERT(number; from_unit_of_measure; to_unit_of_measure) |
Rounding and counting functions in Excel
Rounding and counting functions play an important role in the precise processing of numbers and the recording of data. These functions make it possible to round numerical values in various ways and to count the number of cells with certain criteria.
| Function | Function Description | Formula |
| ROUND UP | Rounds up a value. | =ROUND UP(number; number_digits) |
| ROUND | Rounds up a value. | =RUNDEN(number; number_digits) |
| ROUND DOWN | Rounds a value down. | =ROUND(number; number_digits) |
| COUNT | Counts all cells in a range that contain a number. | =ANZAHL(value1; [value2]; ...) |
| COUNT2 | Counts all cells in a range that contain information. | =ANZAHL2(value1; [value2]; ...) |
| COUNT EMPTY CELLS | Counts all empty cells in a range. | =ANZAHLLEEREZELLEN(range) |
| COUNT IF | Counts cells that fulfill a search criterion. | =CANCLECELLS(range; search criteria) |
| NUMBERS | Counts cells that fulfill several search criteria. | =COUNTIFYCENTS(criteria range1; criteria1; ...) |
| ROW | Returns the row number of a reference cell. | =ROW([reference]) |
| COLUMN | Returns the column number of a reference cell. | = COLUMN([reference]) |
Shortcuts Excel - Keyboard shortcuts & shortcuts
From 4eck Media Germany