Formula Results

Solved/Closed
Report
-
 Trowa -
Hello, can I show fomula results in next cell



2 replies

Yes you can.
You can re-enter the formula in the next cell.
You can paste only the values in the next cell.
Or you can refer to the cell with the formula. If the formula is in cell A1 type in the next cell =A1.
You can also use hide from the protection options to hide the formula from view.
And since you can do basically anything with VBA you could also write a macro.
2

Hi there,

To hide and show formulas in excel sheets get the tips on link below:

http://office.microsoft.com/en-gb/excel-help/display-or-hide-formulas-HP005199811.aspx?redir=0

Thanks
0