500+ Excel Formula List PDF

0.34 MB / 7 Pages
0 likes
share this pdf Share
DMCA / report this pdf Report
Excel Formula List
Preview PDF

500+ Excel Formula List

Excel Formula is an expression that operates on values in a range of cells or a cell. For example, =A1+A2+A3, which finds the sum of the range of values from cell A1 to cell A3. If you want to export in Excel then you must know the Excel formula. Excel Formulas List PDF can be downloaded from the link given at the bottom of this page.

Basic Excel Formula List

Excel FunctionShortcut Keys
Close a WorkbookCtrl + W
Repeat Last Command ActionsF4
Open OptionsAlt + F + T
Open HelpF1
UndoCtrl + Z
RedoCtrl + Y
CopyCtrl + C
CutCtrl + X
PasteCtrl + V
Display Paste Special Dialogue BoxCtrl + Alt + V
Find BoxCtrl + F
Find and ReplaceCtrl + H
Find next matchShift + F4
Find Previous MatchCtrl + Shift + F4
Create an Embedded ChartAlt + F1 –
Create Chart in new WorksheetF11
New WorkbookCtrl + N
Open WorkbookCtrl + O
Save WorkbookCtrl + S
Save AsF12
Print FileCtrl + P
Open Print PreviewCtrl + F2
Close WorkbookCtrl + F4
Close ExcelAlt + F4
Expand or close RibbonCtrl + F1
Activate Access KeysAlt
Move to next control on RibbonTab
HelpF1
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

Download 500+ Excel Formula List PDF

Free Download
Welcome to 1PDF!