Formula Results

Solved/Closed
Viking57 - Jul 16, 2010 at 08:03 AM
 Trowa - Jul 16, 2010 at 10:01 AM
Hello, can I show fomula results in next cell



2 responses

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
Blocked Profile
Jul 16, 2010 at 09:51 AM
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