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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month


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