Please note that Macabacus no longer supports Internet Explorer versions 7 and 8. Before we get started, take out a small screwdriver or key and pop off the F1, Scroll Lock, and Insert keys from your keyboard and store them in a safe place.

You should never need them again, and you won't be a modeling bad-ass until you perform this critical step. There are many Excel keyboard shortcuts, but we focus here only on those you might actually use and benefit from. In some cases there is more than one shortcut for a given action or command.

Note that these shortcuts apply to Excel Windows and earlier, since most companies have not yet transitioned to a newer version. That said, many of these shortcuts work in Excel as well. While there are several shortcuts that can be used to apply number formats, these default formats are rarely suitable for use in professional-looking financial models. Therefore, you won't find a discussion of these shortcuts here.

You may want to install a third-party macro or build your own to create shortcuts for the custom number formats you require, if your employer has not already installed such a macro on your work computer. Each shortcut is assigned a "utility", which represents the shortcut's time-saving potential and expected frequency of use on a scale of 1 to 5.

HOME ADD-INS TOPICS Deal Mechanics Sale Processes Purchase and Sale Agreements Private vs. Intrinsic Value FIN Unearned Compensation FIN Escape — Cancel entry in the cell or Formula Forex alligator trading. Also, close any open menu, submenu, dialog box, or message window. Tab — Move one cell to the right in the worksheet.

Move to the next option or option group in a dialog box.

Move between unlocked cells in a protected worksheet. Although not unique to Excel, this shortcut is useful for quickly toggling between a data stock options excel worksheet e.

When the cell s are pasted, they are moved from their current location in the spreadsheet to the new location upon pasting. Press Enter to execute the selected action. Your toolbars should be arranged so that buttons you use most often e. F5 — Display the Go To dialog box. This is especially useful when trying to quickly locate a named cell or a cell what is considered a stock market crash a worksheet with hundreds of rows of data.

This is most useful when you want to copy a group of cells or an entire worksheet. This can be accomplished just as easily without shortcuts using the arrow keys. F2 — Places the active cell in edit mode and highlights precedent cells.

Positions the insertion point at the end of the cell contents.

Importing Historical Stock Prices from Yahoo into Excel

F4 — Repeat the last command or action when NOT in edit mode, if possible. Use the arrow keys to cycle through the tabs and the Tab key to cycle through elements on the active tab. Hit Enter to enter the equation and calculate the cell. Use arrow keys to navigate the tabs, and the Tab key to cycle through the options on the active tab.

Pressing Enter replaces any formula with the value calculated by the formula, and pressing Esc exits edit mode for the active cell. F9 — Calculate all worksheets in all open workbooks. Useful when using Tables that are not set to recalculate automatically.

Naming cells that are used in the calculation of many other cells is a very good idea and makes checking your work easier. Tables are a great way to show the sensitivity of an output to various inputs e.

How to Lock Cells in Excel

Press this sequence again to unfreeze panes. Use for data entry on large spreadsheets.

Setting validation rules for critical or unintuitive spreadsheet inputs prevents invalid inputs from breaking your model.

Connect Facebook Twitter Feedback About Privacy Policy Legal Notices Pronounce. Build models 5x faster with Macabacus for Excel.