Help and in the contents or index area, type in 'keyboard', from a

Keyboard shortcuts and keyboard help is available in many 'Help'įiles of Microsoft products. It’s important to place your cursor in the correct place before pressing “ Alt =”.Shortcut Keys in Excel 2000 through Excel 2007 Applies to ALL versions of Excel though started from Excel 2000 (Excel Vers. The first example shows the Autosum formula being used in a vertical series of numbers, and the second example shows the formula used on a horizontal series of numbers.

Here are two screenshots of the Autosum Excel shortcut in action. Step 2: hold down the Alt key and then press the equals = sign while still holding 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).

The Autosum Excel shortcut is very simple – just type two keys: In industries like investment banking, keyboard shortcuts such as Autosum Excel are critical, and analysts are expected to know them all by heart (see our guide on how to get a job in investment banking). 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!įor a financial analyst 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 of a day, week, or year. This function is a great way to speed up your financial analysis. 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. Updated MaWhat is the Autosum Excel Function?

Excel shortcut keys 2007