An often-overlooked method of increasing productivity when working in an Excel model is to use Excel shortcuts, or shortcut keys. These shortcut keys perform major functions that, when used instead of clicking in the toolbar, dramatically increase efficiency in speed. Imagine simply pressing two or three keys on the keyboard as opposed to moving your hand to the mouse, moving the mouse and clicking several times. There are thousands of keyboard shortcuts that can be used within Excel to increase productivity. These shortcuts can perform any functions as simple as navigation within the spreadsheet to filling in formulas, or grouping data.
Before diving into the excel shortcuts, it would be prudent to first discuss basic terminology around the elements of excel.
There are also different types of data that exist within Excel.
To master the art of Excel, check out CFI's FREE Excel Crash Course, which teaches you how to become an Excel power user. Learn the most important formulas, functions, and shortcuts to become confident in your financial analysis.
Browse all of CFI’s Excel courses to take your career to the next level!
These pieces of data only show columns A to D and rows 1 to 4.
In this cutout from a spreadsheet, the user has a selection containing cells A2 to D2. This would be referenced in Excel formulas as A2:D2.
There can only be one active cell regardless of how large a selection is. In this case, the active cell is cell A2, with the text data “Orange.”
Cells A2:A4 contain the text data [Orange, Tomato and Potato]
Cells B1:D2 contain the text data [Price, Quantity and Total Price]
Cells B2:B4 and D2:D4 contain currency data, denoted in $
Cells C2:C4 contain number data