Skip to main content

All about Excel Need for every step in your career

List of Excel shortcuts

To be more productive, faster, and more efficient when building financial models or performing financial analysis it’s important to know the main keyboard shortcuts in Excel.  These are critical for careers in investment banking, equity research, FP&A, finance, accounting, and more.
The first thing you’ll do if you’re hired as an investment banking analyst is take a series of intense Excel training courses.  Your mouse will be taken away and you’ll be expected to learn financial modeling with only keyboard shortcuts.  If you follow our tips and tricks below you’ll be able to master theses shortcuts on Windows or Mac operating systems.
It may seem slower at first if you’re use to the mouse, but it’s worth the investment to take the time and learn these important shortcuts.  We have provided the top time saving shortcuts for both PCs and Macs below. To master these skills, check out our Free Excel Crash Course.
You may also want to check out our section on other Excel formulas or the Excel formulas cheat sheet. Excel is quite robust, meaning there is a lot of different tools that can be utilized within it, and therefore many skillsone can practice and hone.

Keyboard shortcuts

Editing shortcuts

F2 Edit active cell
F3 Paste name into a formula
F4 Toggle references
ALT + ENTER Start a new line within the same cell
SHIFT + F2 Insert or edit cell comment
SHIFT + F10 Display short cut menu (i.e. same as right click)
SHIFT + F11 Insert worksheet
CTRL + F3 Define a name for a cell
CTRL + D Fill down (e.g. copy formula down in selected cells)
CTRL + R Fill right
CTRL + SHIFT + A Insert argument names and parentheses for a function after typing a function name in a formula
ALT, I, R Insert row
ALT, I, C Insert column

Formatting Shortcuts

CTRL + 1 Brings up format cells menu
CTRL + B Bold
CTRL + I Italic
CTRL + C Copy
CTRL + V Paste
ALT, E, S Paste special
CTRL + X Cut
CTRL + Z Undo
CTRL + Y Repeat last action
CTRL + A Select all used cells (select entire worksheet if command is repeated)

Navigation shortcuts

F5 Goto
SHIFT + ARROW Select the adjacent cell
SHIFT + SPACEBAR Select entire row
CTRL + SPACEBAR Select entire column
CTRL + SHIFT + HOME Select all to the start of the sheet
CTRL + SHIFT + END Select all to the last used cell of the sheet
CTRL + SHIFT + ARROW Select to the end of the last used cell in row/column
CTRL + ARROW Select the last used cell in row/column
CTRL + PAGE UP/DOWN Move to the next or previous worksheet (Move between tabs if you are in a menu window)
CTRL + TAB Move to next workbook (while in spreadsheet) Move to next divider (when in menu options)
TAB Move to the next cell (Move between items within a menu window)

Other shortcuts

CTRL+ ; Enter date
CTRL + : Enter time
CTRL + ` Show formula/show values (key to the left of 1)
CTRL + ] Select cells which refer to the active cell (useful before deleting a cell in a worksheet)
ALT Drives menu bar
ALT + TAB Next open program
ALT + = Autosum

Mac shortcuts

Editing shortcuts

CTRL + U Edit active cell
⌘ + T Toggle references
CTRL + OPTION + ENTER Start a new line within the same cell
SHIFT + F2 Insert or edit cell comment
SHIFT + F10 Display short cut menu
SHIFT + F11 Insert worksheet
CTRL + F3 Define a name
CTRL + D Fill down (e.g. copy formula down in selected cells)
CTRL + R Fill right
CTRL + SHIFT + A Insert argument names and parentheses for a function after typing a function name in a formula

Formatting Shortcuts

⌘ + 1 Brings up format cells menu
⌘ + B Bold
⌘ + I Italic
⌘ + C Copy
⌘ + V Paste
⌘ + SHIFT + V Paste special
⌘ + X Cut
⌘ + Z Undo
⌘ + Y Repeat last action
⌘ + A Select all used cells (select entire worksheet if command is repeated)

Navigation shortcuts

FF5 / CTRL + G Goto
SHIFT + ARROW Select the adjacent cell
SHIFT + SPACEBAR Select entire row
CTRL + SPACEBAR Select entire column
CTRL + SHIFT + HOME Select all to the start of the sheet
CTRL + SHIFT + END Select all to the last used cell of the sheet
CTRL + SHIFT + ARROW Select to the end of the last used cell in row/column
CTRL + ARROW Select the last used cell in row/column
CTRL + PAGE UP/DOWN Move to the next or previous worksheet (Move between tabs if you are in a menu window)
CTRL + TAB Move to next workbook or window
TAB Move to the next cell (Move between items within a menu window)

Other shortcuts

CTRL+ ; Enter date
CTRL + : Enter time
CTRL + ` Show formula / show values (key to the left of 1)
CTRL + ] Select cells which refer to the active cell (useful before deleting a cell in a worksheet)
⌘ + TAB Next open program
⌘ + SHIFT + T Insert auto sum formula

Comments

Popular posts from this blog

Airtel subse badiya 47 plan

Airtel Rs 47 Prepaid Plan Benefits Aforementioned, both Airtel and Vodafone are offering similar benefits with this prepaid plan. Airtel is offering a total of 7500 local, STD and national roaming seconds with this plan, which converts to a total of 125 minutes. Furthermore, the plan also offers 50 SMS and 500MB of 2G/3G/4G data for the entire validity period of 28 days. Airtel Rs 47 vs Vodafone Rs 47 Plan Comparison Vodafone India, on the other hand, is also providing similar benefits of 7500 seconds voice calling, 50 SMS and 500MB at Rs 47 and it’s an open market plan too. While both Airtel and Vodafone introduced this Rs 47 prepaid plan, Idea Cellular has come up with a Rs 75 prepaid plan with better benefits. Idea Cellular Introduces Rs 75 Prepaid Plan Idea’s all-new Rs 75 prepaid plan gives a user 300 minutes of voice calls even on national roaming, 100 SMS and 1GB of 2G/3G/4G data and that too for a period of 28 days. But Vodafone and Airtel ar...
Royal Enfield Continental GT 650 Twin: All You Need To Know Here is everything that you need to know about the Royal Enfield Continental GT 650 Twin.   Here is everything that you need to know about the new 650 cc Royal Enfield Continental GT 650 Highlights The RE Continental GT 650 will be launched in India in Mid 2018 It shares the engine, parts and components with the Interceptor 650 We expect the pricing to be Rs. 4 lakh - Rs. 4.5 lakh Along with the Royal Enfield Interceptor 650 Twin, the company also gave us a glimpse of the rather good-looking Continental GT 650 Twin. This marked the first occasion that Royal Enfield showcased motorcycles with a parallel-twin engine. The Interceptor and the Continental GT 650 share the same chassis and engine, of course. But that's where the similarities end broadly. A first look at the Continental GT 650 might lead you to believe that the bike is absolutely similar to the standard Continental GT w...

Jio impact

Jio impact: Now Vodafone offers 1.5 GB data per day at Rs 349 Vodafone Vs Jio: Vodafone Rs 458 recharge plan offers 1 GB data for 70 days. Vodafone India has launched some special prepaid recharge packs in order to counter newcomer Reliance Jio, which has captured 11.19 per cent market share in the wireless segment since its launch in September last year. Incumbent telecom player including Vodafone India have been launching new plans every other day to retain their existing subscribers and increase their average revenue per user (ARPU). Here are some of the recent prepaid plans launched by Vodafone to counter Jio: Vodafone Rs 349 recharge plan Vodafone offers 1.5 GB 3G/4G data and unlimited local and STD calls to any numbers and free roaming in this plan. However, there is a cap of 250 minutes per day and 1000 minutes per week on outgoing calls. Subscribers opting for this plan will also get free subscription of Vodafone Play. Validity of this plan is 28 days. ...