These Excel Shortcuts you
should know, Step by step Explanation.
1.
Ctrl + 1 - Format Cells
2. Ctrl + T - Insert Table
3. Ctrl + D - Fill Down from cell above
4.
Ctrl + R - Fill Down from Cell Left
5.
Ctrl + Page Up - Move One Sheet Left
6. Ctrl + Page down - Move One Sheet Right
7. Ctrl + Drag - Duplicate Worksheet
8.
Ctrl + Shift + & - Add border outline
9.
Ctrl + Shift + _ - Remove Borders
10.
Tab - Accept function with Autocomplete
11.
Alt + Enter - Start a New line in the same cell
12.
Alt + F1 - Create chart on same worksheet
13.
F11 - Create chart in new worksheet
14.
F2 - Edit the Active Cell
15.
F4 - Repeat Last Action
16.
F7 - Open Spelling Check
17. Shift + F11 - New Worksheet
No comments:
Post a Comment