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'



Change currency format in Excel (automatically)

Spreadsheets are often used to represent numbers that relate to currency and as a result you may want to change currency format in Excel on a regular basis. The easiest way to do this on a permanent basis is via the ‘Format cells’ option (right click on a cell and choose ‘Format cells’.

However, sometimes you want the currency format to change depending on the contents of a cell e.g. if cell A1 says dollars I want row 1 to be formatted as US dollars.

You can achieve this by using conditional formatting. One of the options you can use is to format the cells based on a formula and one of the format types is the Number format. This way by changing a single descriptive cell you can change the currency format.