Below are 11 Useful Excel Shortcuts , which will simplify your work.
1. F4: During formula typing, adjusts the reference type, abs to relative, otherwise repeats last action
2. CTRL+;/:: Inserts current date
3. CTRL+/: Copies value from cell above to current cell
4. SHIFT+F2: Edits a cell comment
5. ALT+F8: Opens macro dialog box
6. ALT++/: Auto sum selected cells and places values in cells beneath
7. CTRL+SHIFT+S/4: Currency formats current cell
8. CTRL+SHIFT+&/7: Applies outline border to selected cells
9. CTRL+SHIFT+!/1: Comma formats current cell
10. SHIFT+CTRL+F: Activates font drop list
11. SHIFT+CTRL+P: Activates font point size drop down list
We hope that you found the above 11 Useful Excel Shortcuts of great use in simplifying your tasks and work in general.
