Excel formula list helps users do calculations and work with data easily. In Microsoft Excel, formulas are used to add, subtract, multiply, divide, and find values automatically without doing math by hand. These formulas make working with numbers faster and more accurate.
In Microsoft Excel, you can find the mean (average) by using the AVERAGE function. Using formulas in Excel makes calculations more accurate and reduces the chance of mistakes compared to doing them manually. With advanced formulas, you can also work faster and more easily, since Excel can do repetitive calculations automatically, saving you time and effort.
500+ Excel Formulas List
Excel Function
Shortcut Keys
Close a Workbook
Ctrl + W
Repeat Last Command Actions
F4
Open Options
Alt + F + T
Open Help
F1
Undo
Ctrl + Z
Redo
Ctrl + Y
Copy
Ctrl + C
Cut
Ctrl + X
Paste
Ctrl + V
Display Paste Special Dialogue Box
Ctrl + Alt + V
Find Box
Ctrl + F
Find and Replace
Ctrl + H
Find next match
Shift + F4
Find Previous Match
Ctrl + Shift + F4
Create an Embedded Chart
Alt + F1 –
Create Chart in new Worksheet
F11
New Workbook
Ctrl + N
Open Workbook
Ctrl + O
Save Workbook
Ctrl + S
Save As
F12
Print File
Ctrl + P
Open Print Preview
Ctrl + F2
Close Workbook
Ctrl + F4
Close Excel
Alt + F4
Expand or close Ribbon
Ctrl + F1
Activate Access Keys
Alt
Move to next control on Ribbon
Tab
Help
F1
Select all contents of a worksheet.
Ctrl+A
Bold all cells in the highlighted section.
Ctrl+B
Fill the Content of the selected cell on top to bottom. CTRL + D (i.e. Ctrl+ Down)
Ctrl+D
“Search the current sheet.
Ctrl+F
Go to a certain area.
Ctrl+G
Find and replace.
Ctrl+H
Puts italics on all cells in the highlighted section.
Ctrl+I
Inserts a hyperlink.
Ctrl+K
Print the current sheet.
Ctrl+P
Fill Right.
Ctrl+R
Saves the open worksheet.
Ctrl+S
Underlines all cells in the highlighted section.
Ctrl+U
Pastes everything copied onto the clipboard.
Ctrl+V
Closes the current workbook.
Ctrl+W
Cuts all cells within the highlighted section.
Ctrl+X
Repeats the last entry.
Ctrl+Y
Undo the last action.
Ctrl+Z
Changes the format of the selected cells.
Ctrl+1
Bolds all cells in the highlighted section.
Ctrl+2
Puts italics all cells in the highlighted section.
Ctrl+3
Underlines all cells in the highlighted section.
Ctrl+4
Puts a strikethrough all cells in the highlighted section.
Ctrl+5
Shows or hides objects.
Ctrl+6
Shows or hides the toolbar.
Ctrl+7
Toggles the outline symbols.
Ctrl+8
Hides rows.
Ctrl+9
Hides columns.
Ctrl+0
Excel Shortcuts List (Top 50)
S.No.
Description
Excel Shortcuts
1
To create a new workbook
Ctrl + N
2
To open an existing workbook
Ctrl + O
3
To save a workbook/spreadsheet
Ctrl + S
4
To close the current workbook
Ctrl + W
5
To close Excel
Ctrl + F4
6
To move to the next sheet
Ctrl + PageDown
7
To move to the previous sheet
Ctrl + PageUp
8
To go to the Data tab
Alt + A
9
To go to the View tab
Alt + W
10
To go the Formula tab
Alt + M
11
To edit a cell
F2
12
To copy and paste cells
Ctrl + C, Ctrl + V
13
To italicize and make the font bold
Ctrl + I, Ctrl + B
14
To center align cell contents
Alt + H + A + C
15
To fill color
Alt + H + H
16
To add a border
Alt + H + B
17
To remove outline border
Ctrl + Shift + _
18
To add an outline to the select cells
Ctrl + Shift + &
19
To move to the next cell
Tab
20
To move to the previous cell
Shift + Tab
21
To select all the cells on the right
Ctrl + Shift + Right arrow
22
To select all the cells on the left
Ctrl + Shift + Left Arrow
23
To select the column from the selected cell to the end of the table
Ctrl + Shift + Down Arrow
24
To select all the cells above the selected cell
Ctrl + Shift + Up Arrow
25
To select all the cells below the selected cell
Ctrl + Shift + Down Arrow
26
To add a comment to a cell
Shift + F2
27
To delete a cell comment
Shift + F10 + D
28
To display find and replace
Ctrl + H
29
To activate the filter
Ctrl + Shift + L, Alt + Down Arrow
30
To insert the current date
Ctrl + ;
31
To insert current time
Ctrl + Shift + :
32
To insert a hyperlink
Ctrl + k
33
To apply the currency format
Ctrl + Shift + $
34
To apply the percent format
Ctrl + Shift + %
35
To go to the “Tell me what you want to do” box
Alt + Q
36
To select the entire row
Shift + Space
37
To select the entire column
Ctrl + Space
38
To delete a column
Alt+H+D+C
39
To delete a row
Shift + Space, Ctrl + –
40
To hide selected row
Ctrl + 9
41
To unhide selected row
Ctrl + Shift + 9
42
To hide a selected column
Ctrl + 0
43
To unhide a selected column
Ctrl + Shift + 0
44
To group rows or columns
Alt + Shift + Right arrow
45
To ungroup rows or columns
Alt + Shift + Left arrow
46
To group pivot table items
Alt + Shift + Right arrow
47
To ungroup pivot table items
Alt + Shift + Left arrow
48
To hide pivot table items
Ctrl + –
49
To create a pivot chart on the same sheet
Alt + F1
50
To create a pivot chart on a new worksheet
F11
Basic Excel Formulas
=SUM(C2:C5)
=MIN(E2:E5)
=MAX(E2:E5)
=AVERAGE(C2:C5)
=COUNT(E2:E5)
=POWER(D2/100,2)
=CEILING(F2,1)
=FLOOR(F2,1)
Modulus
CONCATENATE
LEN
REPLACE
LEFT, RIGHT, MID
UPPER, LOWER, PROPER
NOW()
TODAY()
TIME()
HOUR, MINUTE, SECOND
DATEDIF
VLOOKUP
Date & Time Excel Formulas & Functions
Functions
Excel Formulas
Description
DATE
=DATE(year,month,day)
Returns the serial number of a particular date
DATEVALUE
=DATEVALUE(date_text)
Converts a date in the form of text to a serial number
DAY
=DAY(serial_number)
Converts a serial number to a day of the month
HOUR
=HOUR(serial_number)
Converts a serial number to an hour
MINUTE
=MINUTE(serial_number)
Converts a serial number to a minute
MONTH
=MONTH(serial_number)
Converts a serial number to a month
NOW
=NOW()
Returns the serial number of the current date and time
SECOND
=SECOND(serial_number)
Converts a serial number to a second
TIME
=TIME(hour,minute,second)
Returns the serial number of a particular time
TIMEVALUE
=TIMEVALUE(time_text)
Converts a time in the form of text to a serial number
TODAY
=TODAY()
Returns the serial number of today’s date
YEAR
=YEAR(serial_number)
Converts a serial number to a year
DAYS360
=DAYS360(start_date,end_date,method)
Calculates the number of days between two dates based on a 360-day year
EDATE
=EDATE(start_date,months)
Returns the serial number of the date that is the indicated number of months before or after the start date
EOMONTH
=EOMONTH(start_date,months)
Returns the serial number of the last day of the month before or after a specified number of months
NETWORKDAYS
=NETWORKDAYS(start_date,end_date,[holidays])
Returns the number of whole workdays between two dates
Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days
WEEKDAY
=WEEKDAY(serial_number,[return_type])
Converts a serial number to a day of the week
WEEKNUM
=WEEKNUM(serial_number,[return_type])
Converts a serial number to a number representing where the week falls numerically with a year
WORKDAY
=WORKDAY(start_date, days, [holidays])
Returns the serial number of the date before or after a specified number of workdays
WORKDAY.INTL
=WORKDAY.INTL(start_date,days,weekend,holidays)
Returns the serial number of the date before or after a specified number of workdays using parameters to indicate which and how many days are weekend days
YEARFRAC
=YEARFRAC(start_date,end_date,basis)
Returns the year fraction representing the number of whole days between start_date and end_date
Converts a number from one measurement system to another
DELTA
=DELTA(number1,number2)
Tests whether two values are equal
ERF
=ERF(lower_limit,upper_limit)
Returns the error function
ERFC
=ERFC(x)
Returns the complementary error function
GESTEP
=GESTEP(number,step)
Tests whether a number is greater than a threshold value
ERF.PRECISE
=ERF.PRECISE(X)
Returns the error function
ERFC.PRECISE
=ERFC.PRECISE(X)
Returns the complementary ERF function integrated between x and infinity
BESSELI
=BESSELI(x,n)
Returns the modified Bessel function In(x)
BESSELJ
=BESSELJ(x,n)
Returns the Bessel function Jn(x)
BESSELK
=BESSELK(x,n)
Returns the modified Bessel function Kn(x)
BESSELY
=BESSELY(x,n)
Returns the Bessel function Yn(x)
BIN2DEC
=BIN2DEC(number)
Converts a binary number to decimal
BIN2HEX
=BIN2HEX(number,places)
Converts a binary number to hexadecimal
DEC2OCT
=DEC2OCT(number,places)
Converts a decimal number to octal
HEX2BIN
=HEX2BIN(number,places)
Converts a hexadecimal number to binary
HEX2DEC
=HEX2DEC(number)
Converts a hexadecimal number to decimal
HEX2OCT
=HEX2OCT(number,places)
Converts a hexadecimal number to octal
IMABS
=IMABS(inumber)
Returns the absolute value (modulus) of a complex number
IMAGINARY
=IMAGINARY(inumber)
Returns the imaginary coefficient of a complex number
IMARGUMENT
=IMARGUMENT(inumber)
Returns the argument theta, an angle expressed in radians
IMCONJUGATE
=IMCONJUGATE(inumber)
Returns the complex conjugate of a complex number
IMCOS
=IMCOS(inumber)
Returns the cosine of a complex number
IMDIV
=IMDIV(inumber1,inumber2)
Returns the quotient of two complex numbers
IMEXP
=IMEXP(inumber)
Returns the exponential of a complex number
IMLN
=IMLN(inumber)
Returns the natural logarithm of a complex number
IMLOG10
=IMLOG10(inumber)
Returns the base-10 logarithm of a complex number
IMLOG2
=IMLOG2(inumber)
Returns the base-2 logarithm of a complex number
IMPOWER
=IMPOWER(inumber,number)
Returns a complex number raised to an integer power
IMPRODUCT
=IMPRODUCT(inumber1,inumber2,…)
Returns the product of complex numbers
IMREAL
=IMREAL(inumber)
Returns the real coefficient of a complex number
IMSIN
=IMSIN(inumber)
Returns the sine of a complex number
IMSQRT
=IMSQRT(inumber)
Returns the square root of a complex number
IMSUB
=IMSUB(inumber1,inumber2)
Returns the difference between two complex numbers
IMSUM
=IMSUM(inumber1,inumber2,…)
Returns the sum of complex numbers
OCT2BIN
=OCT2BIN(number,places)
Converts an octal number to binary
OCT2DEC
=OCT2DEC(number)
Converts an octal number to decimal
OCT2HEX
=OCT2HEX(number,places)
Converts an octal number to hexadecimal
Sum Function
The sum function is one of the most used excel functions when it comes to computing data on Excel. This function works to sum a group of numbers in a specific set of cells. This means you don’t need to type a long cumbrous formula just to calculate the sum of all the data you need. Because of its popularity, newer versions of Microsoft Excel have a button specifically for this function.
TEXT Function
Text function is a useful tool that helps convert a date (or number) into a text string in a particular format. It falls in the category of string formulas that converts numerical values to a string. It is handy when users need to view numeric data in a readable format. Take note that the “TEXT” formula only works to convert numeric values to text.
You can download the Excel Formulas List in PDF format using the link given below.