Keyboard shortcut keys, Cheat Sheet of MS Microsoft Excel skills

The document can be utilized for learning keyboard shortcut keys for Windows, Word and Excel.

Typology: Cheat Sheet

2022/2023

Uploaded on 05/24/2023

jrr-chiranjivi
jrr-chiranjivi 🇮🇳

1 document

1 / 2

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
PDF-XChange Editor
DEMO
PDF-XChange Editor
DEMO
PDF-XChange Editor
DEMO
K
eyboard Shortcut Keys
Ctrl + A Select All
Ctrl + B Bold
Ctrl + C Copy
Ctrl + F Find
Ctrl + G Find next instance of
text
Ctrl + H Replace
Ctrl + I Italic
Ctrl + N New workbook
Ctrl + P
Print
Ctrl + R
Nothing right
Ctrl + S Save
Ctrl + U Underlined
Ctrl + V
Paste
Ctrl +W Close
Ctrl + Y
Repeat
Ctrl + Z Cancel
F1 Help
F2 Edition
F4 Repeat the last action
F5
Go-to
When entering a
formula,
switch between
absolute /
F4
F3 Paste the name Shift +
Ctrl + X CutPrevious Panel
the cell above
Ctrl + O Open Ctrl + ' Copy the formula
time
Ctrl + K Insert a hyperlink Ctrl +; Insert the current
mode
Ctrl + D Fill F9 Recalculate all
F6 Next Pane
F7 Spell Check
F8 Extension of the
workbooks
F10 Activate Menu bar
F11 New graph
F12 Save As
Ctrl +: Insert the current
date
Ctrl + " Copy the value of
from the cell
above
Shift
Offset
Adjustment for
Additional
Functions in the
Shift +
F1
What is it?
Edit cell comment
Paste the function
Shift +
F4
Search Next
Find
Shift +
F8
Add to the
selection
Calculate the
active
Shift +
Shift +
F12 Save
Ctrl +
F3
Set name
Ctrl +
F4
Close
Ctrl +
XL, size of the
F11 New spreadsheet
F10 Popup menu display
worksheet
pf2

Partial preview of the text

Download Keyboard shortcut keys and more Cheat Sheet MS Microsoft Excel skills in PDF only on Docsity!

PDF-XChange Editor

DEMO

PDF-XChange Editor

DEMO

PDF-XChange Editor

DEMO

K

eyboard Shortcut Keys

Ctrl + A Select All Ctrl + B Bold Ctrl + C Copy Ctrl + F Find Ctrl + G Find next instance of text Ctrl + H Replace Ctrl + I Italic Ctrl + N New workbook Ctrl + P Print Ctrl + R Nothing right Ctrl + S Save Ctrl + U Underlined Ctrl + V Paste Ctrl +W Close Ctrl + Y Repeat Ctrl + Z Cancel F1 Help F2 Edition F4 Repeat the last action F5 Go-to When entering a formula, switch between absolute /

F

F3 Paste the name Shift + Ctrl + X CutPrevious Panel the cell above Ctrl + O Open Ctrl + ' Copy the formula time Ctrl + K Insert a hyperlink Ctrl +; Insert the current mode Ctrl + D Fill F Recalculate all F6 Next Pane F7 Spell Check F8 Extension of the workbooks F10 Activate Menu bar F11 New graph F12 Save As Ctrl +: Insert the current date Ctrl + " Copy the value of from the cell above Shift Offset Adjustment for Additional Functions in the Shift + F What is it? Edit cell comment Paste the function into the formula Shift + F Search Next Find Shift + F Add to the selection Calculate the active Shift + Shift + F12 Save Ctrl + F Set name Ctrl + F Close Ctrl + XL, size of the

F

New spreadshe

F

Popup menu dis worksheet

Shift + ~ General Format Ctrl + F Next Workbook Windo w Shift + Ctrl + F Ctrl + F8 Resize Window Ctrl + F Minimize the workboo k Ctrl + F Ctrl + F Inset 4. Macro sheet Alt + F1 Insert a graph Alt + F4 Output Alt + F8 Macro dialog Alt + F Visual Basic Editor Ctrl + Shift + F Ctrl + Previous Window Ctrl + Shift + F printing Alt + (^) New spreadsheet Sav e Alt + = AutoSum Ctrl + Shift + A Insert the argument names in the formula Alt + down arrow automatic view format Alt + ' Format Style Dialog Ctrl + Toggle value / display of the formula Create a name using the names of row and column labels Maximize or Restore Window Previous Workbook Window