- Advertisement -
Sl No. | Key | Function |
---|---|---|
1 | Ctrl+A | Select All |
2 | Ctrl+B | Bold |
3 | Ctrl+C | Copy |
4 | Ctrl+D | Fill |
5 | Ctrl+F | Find |
6 | Ctrl+G | Find Next Instance of Text |
7 | Ctrl+H | Replace |
8 | Ctrl+I | Italic |
9 | Ctrl+K | Insert Hyperlink |
10 | Ctrl+N | New Workbook |
11 | Ctrl+O | Open |
12 | Ctrl+P | |
13 | Ctrl+R | Nothing Right |
14 | Ctrl+S | Save |
15 | Ctrl+U | Underline |
16 | Ctrl+V | Paste |
17 | Ctrl+W | Close |
18 | Ctrl+X | Cut |
19 | Ctrl+Y | Redo |
20 | Ctrl+Z | Undo |
21 | F1 | Help |
22 | F2 | Edition |
23 | F3 | Paste |
24 | F4 | Repeat |
25 | F4 | Switch between Absolute / Relative References in Formula |
26 | F5 | Enlarge Size of Restore Window |
27 | F6 | Next Pane |
28 | F7 | Spell Check |
29 | F8 | Extension of the Mode |
30 | F9 | Recalculate Workbooks |
31 | F10 | Activate Menu Bar |
32 | F11 | New Graph |
33 | F12 | Save As |
34 | Ctrl+: | Insert Current Time |
35 | Ctrl+; | Insert Current Date |
36 | Ctrl+” | Copy Value of the Above Cell |
37 | Ctrl+’ | Copy Formula from the Above Cell |
38 | Shift | Offset Adjustment |
39 | Shift+F1 | Help Task Pane |
40 | Shift+F2 | Edit Cell Comment |
41 | Shift+F3 | Paste Function into Formula |
42 | Shift+F4 | Search Next |
43 | Shift+F5 | Find |
44 | Shift+F6 | Previous Panel |
45 | Shift+F8 | Add to Selection |
46 | Shift+F9 | Calculate Active Worksheet |
47 | Shift+F10 | Popup Menu Display |
48 | Shift+F11 | New Spreadsheet |
49 | Shift+F12 | Save |
50 | Shift+Ctrl+F6 | Previous Workbook Window |
51 | Ctrl+F1 | Open File |
52 | Ctrl+F3 | Set Name |
53 | Ctrl+F4 | Close |
54 | Ctrl+F5 | Size of Restore Window |
55 | Ctrl+F6 | Next Workbook Window |
56 | Ctrl+F7 | Move Window |
57 | Ctrl+F8 | Resize Window |
58 | Ctrl+F9 | Minimize Workbook |
59 | Ctrl+F10 | Maximize / Minimize Window |
60 | Ctrl+F11 | Insert 4.0 Macro Sheet |
61 | Ctrl+Shift+F3 | Create Name |
62 | Ctrl+Shift+F6 | Previous Window |
63 | Ctrl+Shift+F12 | Printing |
64 | Ctrl+Shift+A | Insert Argument Names in Formula |
65 | Ctrl+` | Toggle Value |
66 | Ctrl+Shift+~ | General Format |
67 | Alt+F1 | Insert Graph |
68 | Alt+F2 | Save As |
69 | Alt+F4 | Output |
70 | Alt+F8 | Macro Dialog Box |
71 | Alt+F11 | Visual Editor |
72 | Alt+Shift+F1 | New Spreadsheet |
73 | Alt+Shift+F2 | Save |
74 | Alt+= | Auto Sum |
75 | Alt+Down Arrow | View List |
76 | Alt+’ | Format Dialog Box |
Sl No. | Key | Function |
---|---|---|
1 | Ctrl+A | Select All |
2 | Ctrl+B | Bold |
3 | Ctrl+C | Copy |
4 | Ctrl+D | Fill |
5 | Ctrl+F | Find |
6 | Ctrl+G | Find Next Instance of Text |
7 | Ctrl+H | Replace |
8 | Ctrl+I | Italic |
9 | Ctrl+K | Insert Hyperlink |
10 | Ctrl+N | New Workbook |
11 | Ctrl+O | Open |
12 | Ctrl+P | |
13 | Ctrl+R | Nothing Right |
14 | Ctrl+S | Save |
15 | Ctrl+U | Underline |
16 | Ctrl+V | Paste |
17 | Ctrl+W | Close |
18 | Ctrl+X | Cut |
19 | Ctrl+Y | Redo |
20 | Ctrl+Z | Undo |
21 | F1 | Help |
22 | F2 | Edition |
23 | F3 | Paste |
24 | F4 | Repeat |
25 | F4 | Switch between Absolute / Relative References in Formula |
26 | F5 | Enlarge Size of Restore Window |
27 | F6 | Next Pane |
28 | F7 | Spell Check |
29 | F8 | Extension of the Mode |
30 | F9 | Recalculate Workbooks |
31 | F10 | Activate Menu Bar |
32 | F11 | New Graph |
33 | F12 | Save As |
34 | Ctrl+: | Insert Current Time |
35 | Ctrl+; | Insert Current Date |
36 | Ctrl+” | Copy Value of the Above Cell |
37 | Ctrl+’ | Copy Formula from the Above Cell |
38 | Shift | Offset Adjustment |
39 | Shift+F1 | Help Task Pane |
40 | Shift+F2 | Edit Cell Comment |
41 | Shift+F3 | Paste Function into Formula |
42 | Shift+F4 | Search Next |
43 | Shift+F5 | Find |
44 | Shift+F6 | Previous Panel |
45 | Shift+F8 | Add to Selection |
46 | Shift+F9 | Calculate Active Worksheet |
47 | Shift+F10 | Popup Menu Display |
48 | Shift+F11 | New Spreadsheet |
49 | Shift+F12 | Save |
50 | Shift+Ctrl+F6 | Previous Workbook Window |
51 | Ctrl+F1 | Open File |
52 | Ctrl+F3 | Set Name |
53 | Ctrl+F4 | Close |
54 | Ctrl+F5 | Size of Restore Window |
55 | Ctrl+F6 | Next Workbook Window |
56 | Ctrl+F7 | Move Window |
57 | Ctrl+F8 | Resize Window |
58 | Ctrl+F9 | Minimize Workbook |
59 | Ctrl+F10 | Maximize / Minimize Window |
60 | Ctrl+F11 | Insert 4.0 Macro Sheet |
61 | Ctrl+Shift+F3 | Create Name |
62 | Ctrl+Shift+F6 | Previous Window |
63 | Ctrl+Shift+F12 | Printing |
64 | Ctrl+Shift+A | Insert Argument Names in Formula |
65 | Ctrl+` | Toggle Value |
66 | Ctrl+Shift+~ | General Format |
67 | Alt+F1 | Insert Graph |
68 | Alt+F2 | Save As |
69 | Alt+F4 | Output |
70 | Alt+F8 | Macro Dialog Box |
71 | Alt+F11 | Visual Editor |
72 | Alt+Shift+F1 | New Spreadsheet |
73 | Alt+Shift+F2 | Save |
74 | Alt+= | Auto Sum |
75 | Alt+Down Arrow | View List |
76 | Alt+’ | Format Dialog Box |