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

Post a Comment

Popular posts from this blog

Bill Gates says coding is easy check out

Billgates In 1975, Gates and Allen launched Microsoft, which became the world's largest  PC  software company. During his career at Microsoft, Gates held the positions of  chairman ,  CEO and  chief software architect , while also being the largest individual  shareholder  until May 2014. Gates stepped down as chief executive officer of Microsoft in January 2000, but he remained as chairman and created the position of chief software architect for himself. In June 2006, Gates announced that he would be transitioning from full-time work at Microsoft to part-time work and full-time work at the  Bill & Melinda Gates Foundation . He gradually transferred his duties to  Ray Ozzie  and  Craig Mundie . He stepped down as chairman of Microsoft in February 2014 and assumed a new post as technology adviser to support the newly appointed CEO  Satya Nadella .
Post a Comment
Read more »trendingdestination.blogspot.com

The biggest deal in health care industry

What the CVS-Aetna deal means for the future of health care When drug company chief executive Heather Bresch was hauled in front of Congress last year to defend the high price of lifesaving EpiPens, she drew skeptical lawmakers' attention to a large poster board that blamed the skyrocketing price tag on a coterie of drug supply chain middlemen. Of EpiPen's $608 list price, her company, Mylan, received only $274, Bresch said. "What the patient is paying is not . . . coming back to Mylan," Bresch said. "And when we were speaking earlier of the people, the middlemen in the system, that's either the pharmacy benefit managers, retailers, wholesalers, insurers." That supply chain — rarely seen by most consumers — is the center of attention in the corporate world after CVS Health announced a $69 billion deal to buy Aetna, the nation's third-largest insurer. Familiar as a corner drugstore, CVS Health actually makes most of its money from one of t...
Post a Comment
Read more »trendingdestination.blogspot.com

H-1B extension is now more difficult trump tightened walls again

Trump admin makes it more difficult for H-1B visa extension USCIS said the previous memorandum of April 23, 2004 appeared to place this burden on this federal agency. In a new directive, the Trump administration has made it more difficult for the renewal of non-immigrant visas such as H-1B and L1, popular among Indian IT professionals, saying that the burden of proof lies on the applicant even when an extension is sought.  Rescinding its more than 13-year-old policy, the  US Citizenship and Immigration Services  (  USCIS ) said that the burden of proof in establishing eligibility is, at all times, on the petitioner.  USCIS said the previous memorandum of April 23, 2004 appeared to place this burden on this federal agency.  "This memorandum makes it clear that the burden of proof remains on the petitioner, even where an extension of non- immigrant status is sought," USCIS said in its latest memorandum issued on October 23.   Unde...
Post a Comment
Read more »trendingdestination.blogspot.com