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

Why Was Africa Called the Dark Continent?

Why Was Africa Called the Dark Continent? Email The most common answer to the question, “Why was Africa called the Dark Continent?” is that Europe did not know much about Africa until the 19 th century, but that answer is misleading. Europeans had known quite a lot, but they began ignoring earlier sources of information. More importantly, the  campaign against slavery  and missionary work in Africa actually intensified Europeans’ racial ideas about African people in the 1800s.   They called Africa the Dark Continent, because of the mysteries and the savagery they expected to find in the “Interior ."
Post a Comment
Read more »trendingdestination.blogspot.com
OPINION | Dear Congress, Either Join The Tea Party, Or Lose T-Shirt In Gujarat The BJP understands, as the Congress does not, that tea symbolizes all the fuzzy warmth of Indian culture. It is a great leveller — from the richest to the poorest, everyone drinks tea. Mahatma Gandhi famously took his tea with a pinch of salt. It was 1931, the Salt Satyagraha was a year old and his tea-serving host was the British Viceroy, Lord Irwin. Had the Indian National Congress recalled that little soupcon of history, it would not have put out a meme of a British Prime Minister ordering another Gujarati (PM Narendra Modi) to ‘go sell tea’. The Mahatma was no great votary of tea, but was a master of symbolism. Gently rubbing salt into the Imperial wound, he twinkled, “To remind us of the famous Boston Tea Party”. An exquisite reference to the genesis of American Independence, with the implicit promise of freedom for India. If only today’s Congress understood the power of symbols a tenth as well.
Post a Comment
Read more »trendingdestination.blogspot.com

Nano come back to market

Nano to make a comeback with electric model MUMBAI: The Tata Nano is making a comeback, with an electric motor under the hood. Tata Motors, the manufacturer of the car once touted as the cheapest in the world, however, has only a limited role this time.  A Coimbatore-based company, Jayem Automotives, has signed an agreement with Tata Motors to source the body shell of the car, which will then be fitted with an electric motor and power train at its facility in the southern city, people in the know of the matter told ET.  It is expected to travel more than 150 kms on a full charge. An announcement of the vehicle's launch is likely in the next few days. The company already has orders for 400 electric Nanos from taxi aggregation platform   Ola   Cabs, the people said.   Autocar India magazine reported the news first. According to the report published on its website Wednesday, the vehicle, to be badged Jayem Neo, will likely be unveiled by Prime Minister Narendra
Post a Comment
Read more »trendingdestination.blogspot.com