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. What is the shortcut to ONLY select the visible cells? Guess, then click 'See Answer' as it can be done.
2. 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'



Speeding up Excel

 Speeding Up Excel

Once you have used Excel for awhile you will discover that your spreadsheets increase in size and complexity and start to slow down. At this stage you may want to consider ways of speeding up Excel.

Unfortunately there are no quick fixes and normally it is just a case of improving the design of your spreadsheet or financial model to perform the calculations in the most efficient and effective manner.

There is a very useful article on the Microsoft site ( ) which explains some of the better ways.