Excel Keyboard Shortcuts for Financial Modeling 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 work 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
Posted on: Sat, 25 Jan 2014 12:07:46 +0000
Trending Topics
Recently Viewed Topics
© 2015