Excel shortcuts

15 shortcuts to help you find your way around Microsoft Excel

If you're anything like the average person, you probably find Microsoft Excel to be a bit of a mystery. Even if you've used it before, chances are you only know a fraction of what this powerful software is capable of.

Excel is a complex program, and it can take years to master all of its features. But there are a few shortcuts that can help you get around the program more easily, and we're going to share them with you today.

1. Use the function key shortcuts

If you want to quickly access a certain feature in Excel, try using the function keys. The function keys are the keys at the top of your keyboard with the F1-F12 labels. Each function key has a different shortcut associated with it. For example, pressing F5 will take you to the Go To dialog box.

2. Use the ribbon shortcuts

The ribbon is the bar at the top of the Excel window that contains all of the different commands and options. To quickly access a certain command, you can use the ribbon shortcuts. For example, pressing Alt+H will take you to the Home tab, and pressing Alt+N will take you to the Insert tab.

3. Use the shortcut keys

In addition to the function keys and the ribbon shortcuts, there are also a number of shortcut keys that can be used to access different features in Excel. For example, pressing Ctrl+C will copy the selected cells, and pressing Ctrl+V will paste the copied cells.

4. Use the fill handle

The fill handle is a small square that appears in the bottom-right corner of the selected cells. It can be used to quickly fill in a series of cells. For example, if you have a series of numbers in a column, you can use the fill handle to quickly fill in the rest of the numbers.

5. Use the AutoFill options

Excel's AutoFill feature can be used to quickly fill in a series of cells. To use the AutoFill feature, select the cells that you want to fill, then click and drag the fill handle to the desired location. Excel will automatically fill in the cells based on the data that you selected.

6. Use the Flash Fill feature

The Flash Fill feature is a new feature in Excel 2013 that can be used to quickly fill in a series of cells. To use the Flash Fill feature, start by entering the data that you want to fill in the first few cells. Then, select the cells that you want to fill, and press the Ctrl+E shortcut key. Excel will automatically fill in the rest of the cells based on the data that you entered.

7. Use the fill down command

The fill down command is a quick way to fill in a series of cells. To use the fill down command, select the cells that you want to fill, then press the Ctrl+D shortcut key. Excel will automatically fill in the cells based on the data that you selected.

8. Use the fill left command

The fill left command is a quick way to fill in a series of cells. To use the fill left command, select the cells that you want to fill, then press the Ctrl+L shortcut key. Excel will automatically fill in the cells based on the data that you selected.

9. Use the fill right command

The fill right command is a quick way to fill in a series of cells. To use the fill right command, select the cells that you want to fill, then press the Ctrl+R shortcut key. Excel will automatically fill in the cells based on the data that you selected.

10. Use the fill up command

The fill up command is a quick way to fill in a series of cells. To use the fill up command, select the cells that you want to fill, then press the Ctrl+U shortcut key. Excel will automatically fill in the cells based on the data that you selected.

11. Use the AutoSum command

The AutoSum command is a quick way to sum a series of cells. To use the AutoSum command, select the cells that you want to sum, then press the Alt+= shortcut key. Excel will automatically calculate the sum of the selected cells.

12. Use the AutoCalculate feature

The AutoCalculate feature is a quick way to calculate a sum, average, or other statistic for a series of cells. To use the AutoCalculate feature, select the cells that you want to calculate, then press the Ctrl+Shift+A shortcut key. Excel will automatically calculate the sum, average, or other statistic for the selected cells.

13. Use the Paste Special command

The Paste Special command is a quick way to paste data from one cell to another. To use the Paste Special command, select the cell that you want to copy, then press the Ctrl+Alt+V shortcut key. Excel will open the Paste Special dialog box. In the dialog box, select the desired paste option, then click OK.

14. Use the Go To command

The Go To command is a quick way to jump to a specific cell in a worksheet. To use the Go To command, press the Ctrl+G shortcut key. Excel will open the Go To dialog box. In the dialog box, enter the address of the cell that you want to go to, then click OK.

15. Use the Find and Replace command

The Find and Replace command is a quick way to find and replace data in a worksheet. To use the Find and Replace command, press the Ctrl+F shortcut key. Excel will open the Find and Replace dialog box. In the dialog box, enter the data that you want to find and replace, then click the Find and Replace button.

These are just a few of the many shortcuts that can help you get around Microsoft Excel. With a little practice, you'll be able to use these shortcuts like a pro.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.