MrExcel Publishing
Your One Stop for Excel Tips & Solutions

excel


Posted by Sai on May 05, 2001 10:21 AM

how do i print the formulas of the worksheet instead of the answer?


Posted by Dave Hawley on May 05, 2001 2:17 PM


Hi Sai

Go to Tools>Options|View-Formulas

Dave

OzGrid Business Applications

Posted by Dave Hawley on May 05, 2001 2:21 PM


Forgot to say, that to toggle between the two views, use Ctrl+~ (Tilde)

Dave

OzGrid Business Applications