Here's a list of the most useful shortcuts that should be part of your everyday keyboard use if you're a financial modeler:
|Copy the far left cell across the range. (You have to highlight range first.)
|Copy the top cell down the range. (You have to highlight the range first.)
|Delete a sheet.
|Delete selected cells.
|Move to new cells.
|Ctrl+Pg Up/Pg Down
|Go to end of continuous range and select a cell.
|Select continuous range.
|Move to beginning of the line.
|Move to cell A1.
|Edit formula, showing precedent cells.
|Start a new line in the same cell.
|Highlight within cells.
|Change absolute referencing ("$").
|Cancel a cell entry.
|ALT+= (equal sign)
|Sum selected cells.
|Recalculate all workbooks.
|Highlight precedent cells.
|Highlight dependent cells.
|Go back to original cell.
In the upper-left corner, you'll find the Quick Access Toolbar. You can change the shortcuts that appear on the Quick Access Toolbar by clicking the tiny arrow to the right of the toolbar and selecting what you want to add from the drop-down menu that appears. For example, if you add Paste Special to the Quick Access Toolbar, Paste Special can be accessed with the shortcut Alt+4. Note that this only works when the Quick Access Toolbar has been customized, and whatever you put in the fourth position will be accessed by the shortcut Alt+4.