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

 

Text footer excel

Text footer excel

A number of clients have queried the text footer excel limits on the number of characters allowed.

For example, if you want to include some terms and conditions as a footer to all printed pages you will eventually run out of space.

A way around this is to create the text as a picture (you can use Excel, Word or other program for this) and then include the picture as a footer. This way you avoid the character limit that Excel imposes.

For more why not attend our advanced excel training courses