Review Rating
Click to rate this post!
[Total: 0 Average: 0]

Excel Shortcut Key List

FUNCTION-WINDOWS
New file Ctrl + N
Open Ctrl + O
Save Ctrl + S
Save as Ctrl + Shift + S
Print Ctrl + P
Print preview Ctrl + F2
Close workbook Ctrl + W
Close Excel Ctrl + Q

Working with data
FUNCTION WINDOWS
Copy Ctrl + C
Cut Ctrl + X
Paste Ctrl + V
Paste special Ctrl + Alt + V
Undo Ctrl + Z
Redo Ctrl + Y
Find Ctrl + F
Find previous Ctrl + Shift + F4
Find next Shift + F4
Find and replace Ctrl + H

Moving within a workbook
FUNCTION WINDOWS
Move right
Move left
Move up
Move down
Move right to next full cell Ctrl + →
Move left to next full cell Ctrl + ←
Move up to next full cell Ctrl + ↑
Move down to next full cell Ctrl + ↓
Move to beginning of row Home Fn
Move to last cell Ctrl + End Fn
Move to first cell Ctrl + Home Fn
Scroll right one screen Alt + PgDn Fn
Scroll left one screen Alt + PgUp Fn
Scroll up one screen PgUp Fn
Scroll down one screen PgDn Fn
End mode End Fn

Selecting cells
FUNCTION WINDOWS
Go to cell Ctrl + G
Select all Ctrl + A
Select row Shift + Space
Select column Ctrl + Space
Select current region Ctrl + Shift + *
Select current array Ctrl + /
Select all precedents Ctrl + Shift + {
Select direct dependents Ctrl + ]
Select all dependents Ctrl + Shift + }
Select only visible cells Alt + ;
Add cell range to selection Shift + Click Shift + Click
Add one-off cells to selection Ctrl + Click
Move selection one column left Option + Tab
Move selection one column right Option + Shift + Tab
Toggle selection add mode Shift + F8 Fn
Clear selection Esc
Expand selection up full screen Shift + PgUp Fn + Shift +
Expand selection down full screen Shift + PgDn Fn + Shift +
Expand selection to beginning of row Shift + Home Fn + Shift +
Expand selection to first worksheet cell Ctrl + Shift + Home Fn + Control + Shift +
Expand selection to last worksheet cell Ctrl + Shift + End Fn + Control + Shift +
Toggle extend selection mode F8 Fn + F8
Select only cells with comments Ctrl + Shift + O Fn + Control + Shift + O
Select row differences Ctrl + \ Control + \
Select column differences Ctrl + Shift + | Select direct precedents Ctrl + [

Working with active cells
FUNCTION WINDOWS
Only select active cell Shift + Backspace
Show active cell Ctrl + Backspace
Move active cell clockwise Ctrl + .
Move active cell down Enter Return
Move active cell up Shift + Enter
Move active cell right Tab
Move active cell left Shift + Tab

Editing formulas
FUNCTION WINDOWS
Edit active cell F2
Cancel entry Esc
Delete to end of line Ctrl + Delete
New line within cell Alt + Enter

Excel Shortcut Key List

यदि आप Ms Excel Basic Calculator Projectको बनाना सीखना चाहते हैं तो इस लिंक पर जाए

About VedantSri

Excel Shortcut Key List

VedantSri Computer Institute provides best Computer CoursesClasses and Training in Varanasi. There is NEILIT Courses CCC, BCC, O’level, Certificates and Diploma Computer Courses available with best training materials. Also Available Top 100 Best Computer Courses, For Example, OMDCAADCADTPDFAADAMADTP, ADFA, DCEMS Office. VedantSri Computer Coaching update CCC Online Test 2019 in vedantsri.net. There are some important computer Courses for jobs CCC ClassTyping, Internship And Spoken English Available Free of cost with Offer. More than 50 Computer Courses which are available with 50% Fee Discount in VedantSri Varanasi. You can get the Best Digital Marketing Course in Varanasi Institute VedantSri. There is Latest Computer Course Offer in ADCA Computer Course, DCA Computer Course, CCC Computer Course & English Spoken.

यदि आप CorelDraw Shortcut Key List को बनाना सीखना चाहते हैं तो इस लिंक पर जाए

(Excel Shortcut Key List)

यदि आप CorelDraw Design Entry Card Project को बनाना सीखना चाहते हैं तो इस लिंक पर जाए

Important Links

यदि आप PowerPoint Shortcut Keys List को बनाना सीखना चाहते हैं तो इस लिंक पर जाए

1-VedantSri Official Website:- https://vedantsri.com

2-VedantSri Student Support Website:- https://vedantsri.net

3-Students Jobs Assist Website:- https://www.jobdo.in

4- News By Students Website:- https://varanasigyan.com

5-Best Deal on IT Website:- https://www.computeritpoint.com

यदि आप CorelDraw Design Simple ID-Card Project को बनाना सीखना चाहते हैं तो इस लिंक पर जाए

(Excel Shortcut Key List)

Leave a Reply