My new blog

This blog will not be updated anymore. 
Instead, I will provide great tips & tricks as well as smart shortcuts on this page: http://easy-excel.com/

Trick of the day: New Sheet in Excel

Click here for an updated version of this post

If you want to create a new sheet in an Excel Workbook, you can use the mouse an click next to the rightmost existing sheet. But why not use a shortcut instead?

Alt + Shift + F1

Trick of the day: Chart Shortcut

If you want to create a chart in Excel, you can always select the data table, go to the Insert menu and choose a chart. But why not use a shortcut instead?

Select the data table and use this shortcut: 

Alt + F1

You will get a chart on the same sheet in a second!

Trick of the day: AutoSum

If you want to add together a range of data, you can use the SUM function. But instead of typing the formula, you can use this shortcut to make your life a little easier:

Alt + Equal sign (=)

Trick of the day: Format Painter

If you want to copy the format, but not the values, from another cell, use the Format Painter. Select the cell that has the format you want to copy and click here:

Then, click on the cell that you want to format. If you want to copy a format into multiple cells, double-click on the Format Painter icon. Press escape to deactivate it when you're done.

More on this: http://xl-easy.blogspot.se/2012/11/copy-format-in-excel.html

Trick of the day: Lock cells

When you copy a formula, you sometimes need to lock some of the cell references with dollar signs (absolute reference): A1 => $A$1 or $A1 or A$1
Use this shortcut to make your life easier:

F4

Trick of the day: Open Format Cells Window

If you want to format a cell or a cell value in Excel, you can open the Format Cells Window. To save some time, use the shortcut to open the window:

Ctrl + 1