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!


 

Excel showing formula instead of result

Excel showing formula instead of result

A common question we get is why is excel showing formula instead of result or value. There are a couple of possible answers depending if it is the whole sheet doing it or just some select cells, columns or rows.

Excel CELL, COLUMN or ROW showing formula instead of result

In this situation, the most likely cause is that the cell is formatted as text. This often happens when you have imported data from another system.

You will need to change the format to General. Even then it may still show the formula. Click in the cell and click enter and it should revert to a formula that actually works. If there are lots of cells, use the FIND REPLACE tool and replace all the = with an = (you are just getting Excel to go into and out of each cell instead of you having to do it)

Another possibility is that there is an apostrophe ( ‘ ) in front of the formula. Remove the apostrophe and the formula should work.

Excel SPREADSHEET displays formulas instead of values

If the entire spreadsheet is showing the underlying formula instead of the results it could be that you have the ‘Show Formula’ button toggled to on. Go to the FORMULA tab, by the FORMULA AUDITING section and click the SHOW FORMULA button, or click CTRL + ~ (next to the 1 key)

Want to solve other problems like this? Attend our Excel training courses where we go beyond the obvious to the useful. Visit the Excel training page