Shortcuts in Excel 2016 2013 2010 2007 2003

Move entire column or entire row in Excel

Sometimes you need to reorder columns or rows in Excel. If your data does not contain formulas, the procedure does not seem complicated – copy/paste works well for the plain data cells. However, when you try to move data with formulas, you may run into problems.

Creating and using named ranges

Named ranges are a powerful Excel feature that allows you to assign a symbolic name for the cell or the range of cells for later use as a convenient replacement for cell or range address in formulas.

Copy and paste only nonblank cells

Unfortunately, when you try to paste a series of cells with blank cells, Paste special with Skip blanks option doesn't seem to work.

How to change default chart

When Excel is installed, the default chart is a 2-D Column chart, but you can easily change the default chart type.

Using shortcut keys to create a chart

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

Apply or remove cell borders

Exist several ways to apply or remove cell borders; you can choose anyone:

Saving changes to existing workbooks

Saving your workbook 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.

Adding commands to the Quick Access Toolbar

Suppose you'd like to add a couple more commands to the Quick Access toolbar. Also, say you're a big fan of AutoSum. You can add the AutoSum button to the Quick Access toolbar, so you can quickly create and use AutoSum entries.

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.

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information you’ve provided to them or they’ve collected from your use of their services.

Learn more