Shortcut keys can make your time on Excel much more efficient. Reaching for the mouse or touch pad to do something is definitely slower than using a shortcut key. Also, some of the best shortcut keys saving typing time and are more accurate.
It can take a bit of time to get used to using keys rather than the mouse. I think it is a good idea to just learn a few (or even one) shortcut keys at a time. Otherwise, it feels overwhelming, and you end up not using any because it is too hard to remember them all. Here are a few good ones to get you started on. Choose one to use today!
Ctrl+; —Inserts today’s date.
Ctrl+Shift+:—Inserts the current time
Ctrl+0— Hides the current column.
Ctrl+9—Hides the current row.
Ctrl+`—That’s the accent mark, up by the 1 key. Toggles the view in the sheet to show all the formulas or cell values.
Ctrl+PageUp or PageDown—Moves to the next worksheet in the currently open workbook.
F2—Start editing the current selected cell.
Shift+F10—Opens the right-click menu for the cell you’re in.
Ctrl+End – Move to the bottom right hand cell within the work area of the current worksheet.
Ctrl + Up Arrow – move to top of current column, or first gap in the data. Ctrl + Down Arrow – move to last cell in column, or first gap in the data
What are your favourite shortcut keys?