What is the Autosum Excel function?
The Autosum Excel function can be accessed by typing ALT + the = sign in a spreadsheet and it will automatically create a formula to sum all the numbers in a continuous range. This function is a great way to speeding up your financial analysis. It allows you to easily add up a series of numbers either vertically or horizontally without having to use the mouse or even the arrow keys on the keyboard!
For a financial analystGuide to Becoming a Financial AnalystHow to become a financial analyst. Follow CFI's guide on becoming a financial analyst - networking, resume, interviews, financial modeling skills and more. We've seen thousands of people become financial analysts over the years and know precisely what it takes. performing calculations all day long, even a small increase in speed for one function can add up to a lot of time saved over the course a day, week, or even year.
In industries like investment bankingInvestment BankingInvestment banking is the division of a bank or financial institution that serves governments, corporations and institutions by providing underwriting (capital raising) and mergers and acquisitions (M&A) advisory services. Investment banks act as intermediaries between investors and corporations who require capital,Investment BankingInvestment banking is the division of a bank or financial institution that serves governments, corporations and institutions by providing underwriting (capital raising) and mergers and acquisitions (M&A) advisory services. Investment banks act as intermediaries between investors and corporations who require capital keyboard shortcuts are critical, and analysts are expected to know them all by heart (see our guide on how to get a jobHow to get a job in investment bankingThis guide will outline how to get a job in investment banking using out top three tactics: networking and resume, interview prep, and technical skills. This guide is based on my firsthand experience of what is the most effective way of how to get a job in investment banking. in investment banking).
How Autosum works
The Autosum shortcut is very simple, just type two keys:
ALT =
Step 1: place the cursor below the column of numbers you want to sum (or to the left of the row of numbers you want to sum).
Step 2: hold down the Alt key and then press the equals = sign while still holding Alt.
Step 3: press Enter.
Example of the Autosum Excel function
Here are two screenshots of the auto sum shortcut in action.
The first example shows the Autosum formula being used in a vertical series of numbers, and the second example shows the formula on a horizontal series of numbers.
It’s important to place your cursor in the correct place before pressing “Alt =”.
See Excel screenshots example below:
Download the Free Template
Enter your name and email in the form below and download the free template now!
More Excel guides
Thank you for reading this guide to using the Autosum Excel shortcut to speed up your financial analyst work in your work in spreadsheets. To keep learning and advancing your career CFI highly recommends these additional resources:
- Excel for dummiesExcel for BeginnersThis Excel for beginners guide teaches you everything you need to know about Excel spreadsheets and formulas to perform financial analysis. Watch the Video and learn everything a beginner needs to know from what is Excel, to why do we use, and what are the most important keyboard shortcuts, functions, and formulas
- Index and Match functionsIndex Match FormulaCombining INDEX and MATCH functions is a more powerful lookup formula than VLOOKUP. Learn how to use INDEX MATCH MATCH in this Excel tutorial. Index returns the value of a cell in a table based on the column and row number and Match returns the position of a cell in a row or column. Learn how to them in this guide
- Excel shortcuts listExcel Shortcuts PC MacExcel Shortcuts - List of the most important & common MS Excel shortcuts for PC & Mac users, finance, accounting professions. Keyboard shortcuts speed up your modeling skills and save time. Learn editing, formatting, navigation, ribbon, paste special, data manipulation, formula and cell editing, and other shortucts
- Important Excel formulasExcel Formulas Cheat SheetCFI's Excel formulas cheat sheet will give you all the most important formulas to perform financial analysis and modeling in Excel spreadsheets.
- Free online courses
