Excel Keyboard Shortcuts for Financial Modeling

A financial model is simply a logical and orderly representation of a business, which, if built correctly, will become one of the most vital tools in the entrepreneur’s tool box. Below is a list of some of the most important and commonly used keyboard shortcuts which are used in Finance. Learning to use these shortcuts will greatly speed up your financial modeling in Excel.

Basics & General

  • F2 - Edit Cell
  • F4 - Repeat Last Action
  • Ctrl + Z - Undo Last Action
  • Ctrl + O - Open File
  • Ctrl + S - Save File
  • F12 - Save File As
  • F9 - Recalculate Workbook
  • Ctrl + ; - Insert Current Date

Selection & Navigation

  • Ctrl + Arrowkey - Jump to Edge of Content
  • Ctrl + Spacebar - Select Column
  • Shift + Spacebar - Select Row
  • Alt + I + R - Insert Row
  • Alt + I + C - Insert Column
  • Alt + E + D - Delete Row / Column
  • Ctrl + G - Go To
  • Ctrl + F - Find
  • Ctrl + H - Find & Replace
  • Shift + Tab - Switch Workbooks
  • Shift + F11 - Insert Worksheet
  • Ctrl + Pageup / Pagedown - Move to Next / Previous Worksheet Tab
  • Alt + E + L + M - Delete Worksheet
  • Alt + O + H + R - Rename Worksheet
  • Alt + O + H + T - Recolour Worksheet Tab

Formatting

  • Ctrl + B - Bold
  • Ctrl + I - Italics
  • Ctrl + U - Underline
  • Alt + E + S + F - Paste Formulae
  • Alt + E + S + T - Paste Formatting
  • Alt + E + S + V - Paste Values
  • Ctrl + D - Copy Formula Down to Fill Selection
  • Ctrl + R - Copy Formula Right to Fill Selection
  • Ctrl + 1 - Open Formatting Dialogue
  • Ctrl + Shift + 1 - Autoformat Number Style
  • Ctrl + Shift + 2 - Autoformat Time Style
  • Ctrl + Shift + 3 - Autoformat Date Style
  • Ctrl + Shift + 4 - Autoformat Currency Style
  • Ctrl + Shift + 5 - Autoformat Percentage Style
  • Ctrl + 1, H, Alt + A, C, C - Center Cell Contents Across Selection
  • Ctrl + Shift + 7 - Outline Cell
  • Ctrl + Shift + - - Remove Cell Border
  • Alt + O + C + A - Autoformat Column Width
  • Alt + O + R + A - Autoformat Row Height
  • Alt + D + E - Text to Columns
  • Alt + D + F + F - Filter Data
  • Alt + D + S - Sort Data
  • Alt + O + D - Conditional Formatting

Data Manipulation

  • Ctrl + F3 - Name Cell
  • Alt + D + G + G - Group Rows / Columns
  • Alt + D + G + U - Ungroup Rows / Columns
  • Alt + D + G + H - Hide Grouped Rows / Columns
  • Alt + D + G + S - Show Grouped Rows / Columns
  • Alt + = - Autosum Adjacent Cells

Tables

  • Alt + D + P - Open Pivot Table Wizard
  • Alt + D + S - Create Data Table

Other

  • Alt + T + U + T - Trace Precendents
  • Alt + T + U + D - Trace Dependents
  • Alt + T + U + A - Remove Precedent / Dependent Arrows
  • Ctrl + [ - Highlight Precedents
  • Ctrl + ] - Highlight Dependents
  • Alt + Shift + ` - Show All Formulae
  • Alt + W + F + F - Freeze Panes Around Current Cell
  • Alt + T + M + R - Start / Stop Recording Macro
  • Alt + T + M + M - Show Macros

Quatrohaus

Quatrohaus is a full service digital agency based in Harare, Zimbabwe and whose focus areas are Web Development, Queue Management & Client Directing Systems, Mobile Application & Professional Training.

Quatrohaus is a full service digital agency with based in Harare, Zimbabwe and whose focus areas are Web Development, Queue Management & Client Directing Systems, Mobile Application & Professional Training.

Get in touch

  • Quatrohaus
    1 Verona Gardens
    70 Livingstone Ave
    Harare
    Zimbabwe
  • +263 8677 00 30 30
  • +263 772 595 347
  • sales@quatrohaus.com
Signup to our newsletter: