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

Kiran Bedi a courage need to be saluted

Kiran Bedi  Kiran Bedi  was born and bred in the holy city of Amritsar, Punjab. She is a social activist and the first woman IPS officer in the country. She has not only served her department with full conviction, but has also made whole-hearted contribution to many social causes. A former tennis player, the multi-talented social activist from Amritsar is credited for bringing down the number of crimes against women in West Delhi during her service. She introduced several reforms at Tihar Jail, which gained worldwide acclaim and won her the Ramon Magsaysay Award in 1994. In 2003, Kiran became the first Indian woman to be appointed as a Police Advisor to the Secretary-General of the United Nations in the Department of Peace Keeping Operations. She resigned in 2007 to focus on social activism and writing. She has written several books, and runs the India Vision Foundation. Kiran Bedi introduced a number of reforms in the management of Tihar Jail, Delhi when she was th...
Post a Comment
Read more »trendingdestination.blogspot.com

All about Florida in US

10 Top Tourist Attractions in Florida known as “The Sunshine State”,   Florida   is heavily focused on the tourist trade. The beaches are one of the most popular   tourist attractions in Florida , along with some of the world’s best known theme parks, including Disney World, Universal Studios, and SeaWorld. However some of the state’s best secrets are in secluded locations away from tourist areas and well worth seeing. Regardless of preference Florida has something to offer for any kind of traveler. 10.  Amelia Island ( Where to Stay ) flickr/ katiew Amelia Island is one of the southernmost of the Sea Islands, a chain of barrier islands that stretches from  South Carolina  to Florida. Amelia Island is home to Fernandina Beach, a charming shrimping village with 50 blocks of historic buildings, delightful eateries, and unique B&Bs and six golf courses. 9.  Castillo de San Marcos Located in the city of St. Augustine, The Ca...
Post a Comment
Read more »trendingdestination.blogspot.com
Suzuki Intruder Launched In India; Priced At Rs. 98,340 Suzuki Motorcycles India has launched its 155 cc cruiser motorcycle, the Intruder at a price of Rs. 98,340 (ex-showroom, Delhi). The Intruder uses the engine and the underpinnings of the popular Suzuki Gixxer but of course, it does get a few changes, apart from the design. Suzuki has launched the Intruder in India at a price of Rs. 98,340 Highlights The Suzuki Intruder has the same underpinnings as the Gixxer It shares the engine and some components with the Gixxer The Intruder 150 will be going up against the Bajaj Avenger Street 150 Suzuki Motorcycles India entered the 150 cc cruiser motorcycle segment in India by launching the   Intruder and has priced it at Rs. 98,340 (ex-showroom Delhi). Not to be mistaken with the Intruder M1800, which is a 1,800 cc behemoth, this one is a 155 cc model, which uses the same engine and underpinnings as the highly popular   Suzuki Gixxer. The Intruder, n...
Post a Comment
Read more »trendingdestination.blogspot.com