Keyboard shortcuts are the best way to navigate cells or enter formulas more quickly.
Control-Down/Up Arrow = Moves to the top or bottom cell of the current column Control-Left/Right Arrow = Moves to the cell furthest left or right in the current row
Control-Shift-Down/Up Arrow = Selects all the cells above or below the current cell
Shift-F11 = Creates a new blank worksheet within your workbook
F2 = opens the cell for editing in the formula bar
Control-Home = Navigates to cell A1
Control-End = Navigates to the last cell that contains data
Alt-= = Autosums the cells above the current cell
No comments:
Post a Comment
Your feedback is always appreciated. I will try to reply to your queries as soon as time allows.Please don't spam,spam comments will be deleted upon reviews.