Skip to main content

EXCEL Shortcuts

 General

Open help F1

Undo last action Ctrl + Z

Redo last action Ctrl + Y

Copy selection Ctrl + C

Repeat last action F4

Cut selection Ctrl + X

Paste content from clipboard Ctrl + V

Display the Paste Special dialog box Ctrl + Alt + V

Find previous match (after initial Find) Ctrl + Shift + F4

Find next match (after initial Find) Shift + F4

Insert embedded chart Alt + F1

Insert embedded chart Alt + F1

Toggle Autofilter Ctrl + Shift + L

Activate Filter Alt + ↓

Create table Ctrl + T 

Select table row Shift + Space

Select table column Ctrl + Space 

Select table (when active cell is in table) Ctrl + A

Clear slicer filter  Alt + C

Run Spellcheck F7

Open Thesaurus Shift + F7

Open Macro dialog box Alt + F8

Open VBA Editor Alt + F11

Duplicate object Ctrl + D

Snap to grid (whilst dragging) Alt

Hide or show objects Ctrl + 6

Open Modify Cell Style dialog box Alt + ' 

Show right-click menu Shift + F10

Display control menu Alt Space


Worksheet 

Insert new worksheet Shift + F11 

Go to next worksheet Ctrl + PgDn 

Go to previous worksheet Ctrl + PgUp 

Rename current worksheet Alt + O , H R 

Delete current worksheet Alt + E , L 

Move current worksheet Alt + E , M 


Move between the worksheet, Ribbon, 

task pane and zoom controls in a worksheet 

that has been split F6 OR Shift + F6

Select adjacent worksheets Ctrl + Shift + PgUp/PgDn 

Select non-adjacent worksheets Ctrl + Click Toggle scroll lock ScrLk 

Toggle full screen Ctrl + Shift + F1

Print Ctrl + P 

Open print preview window Ctrl + F2 

Set print area Alt + P , R S 

Clear print area Alt + P , R C 

Zoom in Ctrl + Mouse Wheel Up 

Zoom out Ctrl + Mouse Wheel Down 

Protect sheet Alt + R , P S

Create new workbook Ctrl + N 

Open workbook Ctrl + O 

Save workbook Ctrl + S 

Save as F12 

Go to next workbook Ctrl + Tab 

Go to previous workbook Ctrl + Shift + Tab 

Minimize current workbook window Ctrl + F9 

Maximize current workbook window Ctrl + F10 

Protect workbook Alt + R , P W 

Close current workbook Ctrl + F4 

Close Excel Alt + F4

Ribbon

Expand or collapse ribbon Ctrl + F1 

Activate access keys Alt 

Move through Ribbon tabs and groups → ← ↑ ↓ 

Activate or open selected control Space OR Enter 

Confirm control change enter

Get help on selected control f1




Labels:

Comments

Post a Comment

Popular posts from this blog

Vlookup with wildcard

The VLOOKUP function in Excel can be used with wildcard characters to find and retrieve data based on a partial match of a lookup value. The wildcard characters that can be used with VLOOKUP are the "*" (asterisk) and "?" (question mark) characters. The "*" (asterisk) character is used to match any sequence of characters, while the "?" (question mark) character is used to match any single character. To use a wildcard character with VLOOKUP, you need to include the wildcard character in the lookup value within quotation marks. For example, to find the price of a product that starts with the letter "A" and has any number of characters after it, you can use the following formula: =VLOOKUP("A*",A1:C10,3,FALSE) This formula will look for the value "A*" in the first column of the range A1:C10, and if it finds a match, it will return the value in the third column of the same row. Similarly, if you want to find a pro...
Post a Comment
Read more

vlookup with vstack

1 comment
Read more

Get multiple lookup values in single cell

Post a Comment
Read more