MS EXCEL SHORTCUT KEYS

   MS EXCEL SHORTCUT KEYS

MS EXCEL SHORTCUTS
1	Ctrl+Shift +Home	Extend selection to  first cell in worksheet
2	Ctrl+Shift +End	Extend selection to last cell in worksheet
3	F8	Toggle ‘Extend Selection’ mode
ACTIVE CELL
4	Shift +backspace	Select active cell
5	Ctrl+backspace	Show the active cell on worksheet
6	Ctrl+.	Move active cell clockwise to corners of selection
7	Enter	Move active cell down in selection –wrap to text column
8	Tab	Move active cell right in a selection –wrap to next row
9	Shift +Tab	Move active cell left in a selection –wrap to previous row
SELECT SPECIAL
10	Ctrl+G or F5	Display ‘Go To’ dialog box
11	Ctrl+Shift +o	Select cells with comments
12	Ctrl+Shift +*	Select current region  around active cell
13	Ctrl+A	Select current region
14	Ctrl+[	Select direct dependents
15	Ctrl+shift{	Select all precedents
16	Ctrl+]	Select direct dependents
17	Ctrl+shift+}	Select all dependents

 

DOWNLOAD PDF