Images loading below. While you wait, can you answer this Excel related tip? Guess the answer then click SEE ANSWER to see how it can be done.

1. How do you take all the formatting from chart (see 1 below) and PASTE it onto another chart (2)? Guess and then see how it can be done with 'See Answer'

2. How do you copy from Excel (see 1 below) and paste into Word (2) WITHOUT seeing the filter button, gridlines, comment notes and more?

Guess and then view answer to see how it can be done!


Opening Excel files that you use regularly

If you are like us, you may find yourself opening the same Excel file many times. Typically you may use the Recent file list to do this.

For Screenshots go to the latest post about this topic at

In Excel 2007 and Excel 2010 there is a great new feature which allows you to ‘pin’ the files you regularly use. When you do this, the files will always be shown on the recent list, even if you haven’t used them recently.

To use, go to your Recent List (similar place to where you Open files). On the right of the file names you will see a ‘pin’. Click it. Excel 2007 and Excel 2010 handle it slightly differently but it is a great time saver.

See below how to perform this

Learn more at our Excel courses. Visit Live Excel Training page

Pin your regularly used Excel files