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!