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

Trick of the day: Navigate with Ctrl + Arrows

If you have a large Excel worksheet, it takes too long to use the mouse to navigate within it. Try this instead: Hold down the Ctrl key and use the arrow keys to go to the last populated cell in the range. 

Ctrl + Arrow Keys

Trick of the day: Copy Cell Above

Go to my new blog for more Excel Tricks: www.easy-excel.com

In Excel you often want to copy the cell right above the active cell. Instead of the usual Copy-Paste routine, there is a keyboard shortcut in Excel which will make your life easier:

Ctrl + D

Trick of the day: Switch between tabs

If you work with Excel all the time, you are probably pretty tired of switching between the tabs using the mouse. To make your life easier, learn this Excel keyboard shortcut:

Ctrl + PageUp
Ctrl + PageDown

Learn more Excel tricks here: easy-excel.com

Work faster in Excel!

There are a lot of simple techniques you can learn to work a lot faster in Excel. Follow this blog, and I will show you one trick every weekday!