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
Ctrl+B
section.
Fill the Content of the selected cell
on top to bottom. CTRL + D (i.e. Ctrl+D
Ctrl+ Down)
“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
Ctrl+I
highlighted section.
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
Ctrl+U
highlighted section.
Pastes everything copied onto the
Ctrl+V
clipboard.
Closes the current workbook. Ctrl+W
Cuts all cells within the highlighted
Ctrl+X
section.
Repeats the last entry. Ctrl+Y
Undo the last action. Ctrl+Z
Changes the format of the selected
Ctrl+1
cells.
Bolds all cells in the highlighted
Ctrl+2
section.
Puts italics all cells in the
Ctrl+3
highlighted section.
Underlines all cells in the
Ctrl+4
highlighted section.
Puts a strikethrough all cells in the
Ctrl+5
highlighted section.
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)

Excel
[Link]. Description
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
Ctrl +
6 To move to the next sheet
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
Ctrl + C, Ctrl +
12 To copy and paste cells
V
Ctrl + I, Ctrl +
13 To italicize and make the font bold
B
Alt + H + A +
14 To center align cell contents
C
15 To fill color Alt + H + H
16 To add a border Alt + H + B
17 To remove outline border Ctrl + Shift + _
To add an outline to the select Ctrl + Shift +
18
cells &
19 To move to the next cell Tab
20 To move to the previous cell Shift + Tab
Ctrl + Shift +
21 To select all the cells on the right
Right arrow
Ctrl + Shift +
22 To select all the cells on the left
Left Arrow
To select the column from the
Ctrl + Shift +
23 selected cell to the end of the
Down Arrow
table
To select all the cells above the Ctrl + Shift +
24
selected cell Up Arrow
To select all the cells below the Ctrl + Shift +
25
selected cell Down Arrow
26 To add a comment to a cell Shift + F2
Shift + F10 +
27 To delete a cell comment
D
28 To display find and replace Ctrl + H
Ctrl + Shift +
29 To activate the filter 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 + $
Ctrl + Shift +
34 To apply the percent format
%
To go to the “Tell me what you
35 Alt + Q
want to do” box
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
Shift + Space,
39 To delete a row
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
Alt + Shift +
44 To group rows or columns
Right arrow
Alt + Shift +
45 To ungroup rows or columns
Left arrow
Alt + Shift +
46 To group pivot table items
Right arrow
Alt + Shift +
47 To ungroup pivot table items
Left arrow
48 To hide pivot table items Ctrl + –
To create a pivot chart on the
49 Alt + F1
same sheet
To create a pivot chart on a new
50 F11
worksheet

Basic Excel Formulas

1. =SUM(C2:C5)
2. =MIN(E2:E5)
3. =MAX(E2:E5)
4. =AVERAGE(C2:C5)
5. =COUNT(E2:E5)
6. =POWER(D2/100,2)
7. =CEILING(F2,1)
8. =FLOOR(F2,1)
9. Modulus
10. CONCATENATE
11. LEN
12. REPLACE
13. LEFT, RIGHT, MID
14. UPPER, LOWER, PROPER
15. NOW()
16. TODAY()
17. TIME()
18. HOUR, MINUTE, SECOND
19. DATEDIF
20. VLOOKUP
Date & Time Excel Formulas &
Functions

Functions Excel Formulas Description

Returns the
serial number
DATE #NAME?
of a particular
date
Converts a
date in the
DATEVALUE #NAME? form of text to
a serial
number
Converts a
serial number
DAY #NAME?
to a day of the
month
Converts a
HOUR #NAME? serial number
to an hour

Converts a
MINUTE #NAME? serial number
to a minute

Converts a
MONTH #NAME? serial number
to a month

Returns the
serial number
NOW 11/8/2025 4:28
of the current
date and time

Converts a
SECOND #NAME? serial number
to a second
Returns the
serial number
TIME #NAME?
of a particular
time
Converts a
time in the
TIMEVALUE #NAME? form of text to
a serial
number
Returns the
TODAY 11/8/2025 serial number
of today’s date
 Converts a
YEAR #NAME? serial number
to a year

Calculates the
number of
days between
DAYS360 #NAME?
two dates
based on a
360-day year

Returns the
serial number
of the date
that is the
EDATE #NAME? indicated
number of
months before
or after the
start date

Returns the
serial number
of the last day
of the month
EOMONTH #NAME?
before or after
a specified
number of
months

Returns the
number of
=NETWORKDAYS(start_date,end_ whole
NETWORKDAYS
date,[holidays]) workdays
between two
dates

Returns the
number of
whole
workdays
between two
=[Link](start_date,
[Link] dates using
end_date,[weekend],[holidays])
parameters to
indicate which
and how many
days are
weekend days
 Converts a
=WEEKDAY(serial_number, serial number
WEEKDAY
[return_type]) to a day of the
week
Converts a
serial number
to a number
=WEEKNUM(serial_number, representing
WEEKNUM
[return_type]) where the
week falls
numerically
with a year

Returns the
serial number
of the date
=WORKDAY(start_date, days,
WORKDAY before or after
[holidays])
a specified
number of
workdays

Returns the
serial number
of the date
before or after
a specified
number of
[Link] #NAME? workdays
using
parameters to
indicate which
and how many
days are
weekend days

Returns the
year fraction
representing
the number of
YEARFRAC #NAME?
whole days
between
start_date and
end_date

Lookup & Reference Excel Formulas

 Functions Excel Formulas Description
Returns a
=ADDRESS(row_num, reference as
ADDRESS column_num, [abs_num], [a1], text to a single
[sheet_text]) cell in a
worksheet
Returns the
column
COLUMN =COLUMN([reference])
number of a
reference
Returns the
number of
COLUMNS #NAME?
columns in a
reference

Looks in the
top row of an
=HLOOKUP(lookup_value,table_ar
array and
HLOOKUP ray,row_index_num,
returns the
[range_lookup])
value of the
indicated cell
Uses an index
to choose a
=INDEX(array,row_num,
INDEX value from a
[column_num])– 2 types
reference or
array

Returns a
reference
INDIRECT #NAME?
indicated by a
text value
Looks up
values in a
MATCH #NAME?
reference or
array
Returns a
reference
OFFSET #NAME? offset from a
given
reference
Returns the
ROW =ROW([reference]) row number of
a reference
Returns the
number of
ROWS #NAME?
rows in a
reference
 Looks in the
first column of
an array and
=VLOOKUP(lookup_value,table_arr
VLOOKUP moves across
ay,col_index_num,[range_lookup])
the row to
return the
value of a cell

Chooses a
CHOOSE Err:501 value from a
list of values

Returns data
=GETPIVOTDATA(data_field,pivot_ stored in a
GETPIVOTDATA
table,field,item,…) PivotTable
report

Creates a
shortcut or
jump that
opens a
document
HYPERLINK #NAME?
stored on a
network
server, an
intranet, or the
Internet

Returns the
TRANSPOSE #NAME? transpose of
an array
Returns the
number of
AREAS #NAME?
areas in a
reference

Text Excel Formulas & Functions

Functions Excel Formulas Description

Checks to see
if two text
EXACT #NAME?
values are
identical
Converts text
LOWER #NAME?
to lowercase

Capitalizes the
first letter in
PROPER #NAME?
each word of a
text value
 Removes
TRIM #NAME? spaces from
text
Converts text
UPPER #NAME?
to uppercase
Returns the
character
CHAR #NAME? specified by
the code
number

Removes all
nonprintable
CLEAN #NAME?
characters
from text

Returns a
numeric code
CODE #NAME? for the first
character in a
text string

Converts a
number to
text, using the
DOLLAR #NAME?
$ (dollar)
currency
format

Formats a
number as text
FIXED #NAME? with a fixed
number of
decimals

Extracts the
phonetic
(furigana)
PHONETIC #NAME?
characters
from a text
string

Repeats text a
REPT #NAME? given number
of times
Substitutes
new text for
SUBSTITUTE #NAME?
old text in a
text string
 Converts its
T #NAME? arguments to
text

Converts a text
VALUE #NAME? argument to a
number

Changes full-
width (double-
byte) English
letters or
katakana
ASC #NAME? within a
character
string to half-
width (single-
byte)
characters
Converts a
number to
text, using the
BAHTTEXT #NAME?
ß (baht)
currency
format

Most Common Excel Formulas &

Functions

Functions Excel Formulas Description

Finds one text

value within
FIND #NAME?
another (case-
sensitive)

Returns the
leftmost
LEFT #NAME? characters
from a text
value

Returns the
number of
LEN #NAME?
characters in a
text string
 Returns a
specific
number of
characters
MID #NAME?
from a text
string starting
at the position
you specify

Replaces
REPLACE #NAME? characters
within text
Returns the
rightmost
RIGHT #NAME? characters
from a text
value

Finds one text

value within
SEARCH #NAME?
another (not
case-sensitive)

Excel All Formulas

SUM Excel Formula : SUM(number1, [number2] )

AVERAGE(number1, [number2],
AVERAGE Excel Formula :
…)
0
MAX & MIN Excel Formula :
0
COUNT & COUNTA Formula : COUNT(value1, [value2], …)
IF(logical_test, [value_if_true],
IF Excel Formula :
[value_if_false])
TRIM Excel Formula : Excel Function
LEN Excel Formula : #NAME?
CONCATENATE Excel Formula : CONCATENATE(text1, [text2], …)

For Engineering Excel Formulas &

Functions

Functions Excel Formulas Description

 Converts a
number from
one
CONVERT #NAME?
measurement
system to
another

Tests whether
DELTA #NAME? two values are
equal

Returns the
ERF #NAME?
error function

Returns the
ERFC #NAME? complementar
y error function
Tests whether
a number is
GESTEP #NAME? greater than a
threshold
value
Returns the
[Link] #NAME?
error function

Returns the
complementar
y ERF function
[Link] #NAME?
integrated
between x and
infinity

Returns the
modified
BESSELI #NAME?
Bessel function
In(x)
Returns the
BESSELJ #NAME? Bessel function
Jn(x)
Returns the
modified
BESSELK #NAME?
Bessel function
Kn(x)
Returns the
BESSELY #NAME? Bessel function
Yn(x)
 Converts a
BIN2DEC #NAME? binary number
to decimal

Converts a
BIN2HEX #NAME? binary number
to hexadecimal
Converts a
decimal
DEC2OCT #NAME?
number to
octal
Converts a
hexadecimal
HEX2BIN #NAME?
number to
binary

Converts a
hexadecimal
HEX2DEC #NAME?
number to
decimal
Converts a
hexadecimal
HEX2OCT #NAME?
number to
octal

Returns the
absolute value
IMABS #NAME? (modulus) of a
complex
number

Returns the
imaginary
IMAGINARY #NAME? coefficient of a
complex
number

Returns the
argument
IMARGUMENT #NAME? theta, an angle
expressed in
radians

Returns the
complex
IMCONJUGATE #NAME? conjugate of a
complex
number
 Returns the
cosine of a
IMCOS #NAME?
complex
number

Returns the
quotient of two
IMDIV #NAME?
complex
numbers

Returns the
exponential of
IMEXP #NAME?
a complex
number

Returns the
natural
IMLN #NAME? logarithm of a
complex
number

Returns the
base-10
IMLOG10 #NAME? logarithm of a
complex
number
Returns the
base-2
IMLOG2 #NAME? logarithm of a
complex
number

Returns a
complex
IMPOWER #NAME? number raised
to an integer
power

Returns the
product of
IMPRODUCT Err:501
complex
numbers

Returns the
real coefficient
IMREAL #NAME?
of a complex
number
 Returns the
sine of a
IMSIN #NAME?
complex
number
Returns the
square root of
IMSQRT #NAME?
a complex
number

Returns the
difference
IMSUB #NAME? between two
complex
numbers

Returns the
sum of
IMSUM Err:501
complex
numbers
Converts an
OCT2BIN #NAME? octal number
to binary

Converts an
OCT2DEC #NAME? octal number
to decimal

Converts an
OCT2HEX #NAME? octal number
to hexadecimal