Excel Formula List PDF Download

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.



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
1Close a WorkbookCtrl + W
2Repeat Last Command ActionsF4
3Open OptionsAlt + F + T
4Open HelpF1
5UndoCtrl + Z
6RedoCtrl + Y
7CopyCtrl + C
8CutCtrl + X
9PasteCtrl + V
10Display Paste Special Dialogue BoxCtrl + Alt + V
11Find BoxCtrl + F
12Find and ReplaceCtrl + H
13Find next matchShift + F4
14Find Previous MatchCtrl + Shift + F4
15Create an Embedded ChartAlt + F1 –
16Create Chart in new WorksheetF11
17New WorkbookCtrl + N
18Open WorkbookCtrl + O
19Save WorkbookCtrl + S
20Save AsF12
21Print FileCtrl + P
22 Open Print PreviewCtrl + F2
23Close WorkbookCtrl + F4
24Close ExcelAlt + F4
25Expand or close RibbonCtrl + F1
26Activate Access KeysAlt
27Move to next control on RibbonTab
29Select all contents of a worksheet.Ctrl+A
30Bold all cells in the highlighted section.Ctrl+B
31Fill 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
33Go to a certain area.Ctrl+G
34Find and replace.Ctrl+H
35Puts italics on all cells in the highlighted section.Ctrl+I
36Inserts a hyperlink.Ctrl+K
37Print the current sheet.Ctrl+P
38Fill Right.Ctrl+R
39Saves the open worksheet.Ctrl+S
40Underlines all cells in the highlighted section.Ctrl+U
41Pastes 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.


Share This:

2 thoughts on “Excel Formula List PDF Download”

Leave a Comment