Do you want to act “like a boss” using excel?
Or significantly improve your speed when you work in excel?
Just go through this simple shortcuts that can really make the difference in your daily job.
- CRTL + HOME: always bring user to cell A1
- CRTL + END: bring you to very end of data
- SHIFT+F11: auto insertion of a new sheets
- CTRL + N: open new workbook
- CRTL + A: select all (it works with ranges as well as different sheets)
- CRTL +SHIFT + arrows [®¯¬ ]: depending on the arrows goes to the next blank cell according to directions used
- CRTL + D: copy data into the selected cells
- CTRL + PLUS [+]: automatically add rows or columns
- CRTL + MINUS [-]: delete columns or rows
- CTRL + PgDown/PgUp: move between sheets
Leave a comments/tips if you like it and I’ll share new cool stuff on next post…