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.

Excel shortcut keys 2016