Thread: Cells resized in formula view

Hi,

I have created a spreadsheet using formulae. I need to display evidence of the use of formulae. So I have toggled the formula view. However, all the cells have resized automatically. Is there anyway to keep the cells to their original size?

Thanks.

Don't worry - I've found a work around:

In the cells with formulae, put a ' in front of the = in the formulae to store the formulae as text. Then, all of the formulae are showing.