Shortcuts in Excel 365 2016 2013 2010 2007

Create a toolbar button or menu item to run a Macro

If you assigned a key combination to a macro when you recorded it, you can run the macro by pressing that key combination. If not, you can subsequently assign the macro to the menu item.

Using shortcut keys to create a chart

Excel propose easy and very fast way to create a chart by using shortcut keys.

Saving workbooks

Saving your document in the same location with the same name is easy.

6 ways to open an Excel workbook

The Open dialog box, is your key to finding and retrieving Excel workbooks.

How to see formulas on the spreadsheet

Sometimes it is handy to view (and print) the formulas in all the cells in a spreadsheet with out having to manually enter each cell.

How to select all the embedded charts on the worksheet

If you need to select all objects embedded into the worksheet, e.g. select all charts to adjust their size, press Ctrl+G and click the Special button or use Ctrl to select objects individually.

How to enter a new line on a cell

If you have lengthy text in a cell, you can force Excel to display it in multiple lines within the cell.

How to use keyboard to navigate in the spreadsheet

To move around the worksheet with your keyboard, use the key combinations:

How to insert functions into formulas

The easiest way to enter a function into a formula is to use the Excel program's Insert Function dialog box.