MICROSOFT OFFICE Excel KEYBOARD
SHORTCUTs
Table
of Contents:
1.
Navigate Worksheets
2.
Select Cells
3.
Juggle Rows, Columns, and Cells
4.
Edit Cell Content
5.
Duplicate Cells, Rows, and Columns
6.
Undo, Redo, and Repeat Action
7.
Cut, Copy, Paste, and Paste Special
8.
Format Cells
9.
Find and Replace
10.
Formulas
11.
Manage Workbooks
12.
Manage Worksheet Tabs
13.
Freeze, Split, and Hide
14.
Auto Filter
15.
Column Width and Row Height
16.
Navigate Multi-Cell Selections
17.
Comments and Hyperlinks
18.
Pivot Tables
19.
Excel Auto Tables and Data Forms
20.
Group Rows and Columns
21.
Other Shortcuts
22.
MS Excel MOS Certification
Navigate
Worksheets
Arrow Keys
|
Navigate
by one cell at a time in any direction
|
Page Down / Page Up
|
Move
one screen down / up
|
Alt + Page Down /
Page Up
|
Move
one screen right / left
|
Tab / Shift + Tab
|
Move
one cell to the right / to the left in a worksheet
|
Ctrl + Arrow Keys
|
Move
to the edge of next data region (cells that contains data)
|
Home
|
Move
to the beginning of row
|
Ctrl + Home
|
Move
to the beginning of worksheet
|
Ctrl + End
|
Move
to the last cell with content of worksheet
|
Ctrl + G
|
Display
the Go To dialog box
|
Ctrl + G then type e.g. A50
|
Go
to line 50, Column A
|
Ctrl + G then type e.g. G1
|
Go
to column G, Line 1
|
To download the full article in PDF version, Click Here.....
We
have the following Application Keyboard Shortcuts:
*
Microsoft Office Word Keyboard Shortcuts – Complete version
*
Microsoft Office Excel Keyboard Shortcuts – Complete version
*
Microsoft Office Access Keyboard Shortcuts – Complete version
*
Microsoft Office Word Keyboard Shortcuts – Complete version
*
Microsoft Office Outlook Keyboard Shortcuts – Complete version
*
Evernote Keyboard Shortcuts – Complete
*
Paint.net Keyboard Shortcuts – Complete
*
Photoshop Keyboard Shortcuts – Complete
*
FL Studio Keyboard Shortcuts – Complete
*
Skype Keyboard Shortcuts – Complete
You can also place an order for your favourite application keyboard shortcuts.
The
keyboard shortcuts work with any version of the applications.....
No comments:
Post a Comment