Search This Blog

Saturday 30 September 2017

KEYBOARD SHORTCUTS FOR MICROSOFT OFFICE EXCEL

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

You need to enable Secure Boot to install Windows 11 — here’s how.

You need to enable Secure Boot to install Windows 11 — here’s how. Windows 11 requires Secure Boot to run, and here are the steps to che...