All Excel Formulas and Functions Cheatsheet – Basic to Advance Excel Formulas List PDF Download
Welcome to our new post. In this post, we will provide you with the Excel Formula List. You can find the complete list of basic and advanced Excel Formulas which you can also download in PDF format by the end of this post.
Checkout:
Excel Formulas
In Microsoft Excel, a formula is an expression that operates on values in a range of cells. These formulas return a result, even when it is an error. Excel formulas enable you to perform calculations such as addition, subtraction, multiplication, and division.
Excel has over 475 formulas in its Functions Library, from simple mathematics to very complex statistical, logical, and engineering tasks.
Here is a small list of Excel Functions along with the shortcut keys.
Excel Formula List
| Sr. No. | Excel Function | Shortcut Keys |
|---|---|---|
| 1 | Close a Workbook | Ctrl + W |
| 2 | Repeat Last Command Actions | F4 |
| 3 | Open Options | Alt + F + T |
| 4 | Open Help | F1 |
| 5 | Undo | Ctrl + Z |
| 6 | Redo | Ctrl + Y |
| 7 | Copy | Ctrl + C |
| 8 | Cut | Ctrl + X |
| 9 | Paste | Ctrl + V |
| 10 | Display Paste Special Dialogue Box | Ctrl + Alt + V |
| 11 | Find Box | Ctrl + F |
| 12 | Find and Replace | Ctrl + H |
| 13 | Find next match | Shift + F4 |
| 14 | Find Previous Match | Ctrl + Shift + F4 |
| 15 | Create an Embedded Chart | Alt + F1 – |
| 16 | Create Chart in new Worksheet | F11 |
| 17 | New Workbook | Ctrl + N |
| 18 | Open Workbook | Ctrl + O |
| 19 | Save Workbook | Ctrl + S |
| 20 | Save As | F12 |
| 21 | Print File | Ctrl + P |
| 22 | Open Print Preview | Ctrl + F2 |
| 23 | Close Workbook | Ctrl + F4 |
| 24 | Close Excel | Alt + F4 |
| 25 | Expand or close Ribbon | Ctrl + F1 |
| 26 | Activate Access Keys | Alt |
| 27 | Move to next control on Ribbon | Tab |
| 28 | Help | F1 |
| 29 | Select all contents of a worksheet. | Ctrl+A |
| 30 | Bold all cells in the highlighted section. | Ctrl+B |
| 31 | Fill the Content of the selected cell on top to bottom. CTRL + D (i.e. Ctrl+ Down) | Ctrl+D |
| 32 | “Search the current sheet. | Ctrl+F |
| 33 | Go to a certain area. | Ctrl+G |
| 34 | Find and replace. | Ctrl+H |
| 35 | Puts italics on all cells in the highlighted section. | Ctrl+I |
| 36 | Inserts a hyperlink. | Ctrl+K |
| 37 | Print the current sheet. | Ctrl+P |
| 38 | Fill Right. | Ctrl+R |
| 39 | Saves the open worksheet. | Ctrl+S |
| 40 | Underlines all cells in the highlighted section. | Ctrl+U |
| 41 | Pastes everything copied onto the clipboard. | Ctrl+V |
| 42 | Closes the current workbook. | Ctrl+W |
You can find the complete list of Excel Formulas in the PDF given below.
Download Excel Formula List PDF
You can download the Excel Formula List PDF from the download button given below.
We hope you find this content useful and are able to download the PDF for Excel Formula List.
Checkout:
googd
good and helpful