Once you've navigated the cell you were looking for, move the focus to, and place the insertions point in it with the F2 key.

In case you happen to lose the active cell, just press Ctrl + Backspace to instantly find it within a document. On the blank document, the combination will simply move you to the outer limits. If you're working with more than one range of cells, applying Ctrl+ A rrow key will take you to the edge of the current data in the supposed direction. When you press an Arrow key in an Excel worksheet, the active cell moves one cell in that direction. So, to save your nerve s and time, try to remember these handy navigational keyboard shortcuts. Navigation shortcuts and key combinations to perform actions: When you have to deal with a large Excel document, it often gets pretty hard to navigate throughout a worksheet. If you press F4, it will repeat your last command or action, if possible. Using Shift+F9 will force calculation in the active worksheet, and the F9 key will calculate all sheets in all open workbooks. The Alt+F1 keys will help you create a basic bar chart based on the data in the current range. I f you're looking for a quick, straightforward way to convert a selection of cells into a table, use C trl +T. T o easily switch between shee t s or tabs in an Excel workbook, hold the Ctrl key and press Page Down or Page Up to move from left-to-right or right-to-left accordingly.

Using Ctrl+F9 will mini mize the workbook window to an icon. I f you want to restore or maximize the size of the selected spreadsheet, press Ctrl+F10. Thus, using Ctrl+N will quickly launch a new worksheet for you, whereas the Ctrl+Shift+O combination will highlight all cells with comments on the sheet. Shortcuts to work in a spreadsheet : When you start working in Excel, the right combination of shortcuts can significantly speed up the process, no matter what you're going to create. Each letter corresponds to a certain menu item of the program. When activated, Key Tips become visible and overlay the Excel menu with letters. The feature is called Key Tips and can be accessed if you press Alt or F10. Keyboard shortcuts to navigate the Ribbon: In case you didn't come across our previous article about Microsoft Word shortcuts, you're less likely to know that almost any Office application lets you navigate the ribbon with just a couple of keyboard combinations.

Keyboard shortcuts for excel 2016