Tech Tips Home
The Best Tech Tips And Daily Deals
Newsletter On The Internet!

Shop online 24hrs a day or call us Mon-Fri
8:30AM-4:30PM EST - 1-800-915-2088
WorldStart Tech Tip And Store Search
Email: Password: Login Remember Me

Like what you see here? Subscribe to the Tech Tips newsletter!   Email: Subscribe

Show Me The… Formulas?

Monday, November 22nd, 2004 by | Filed Under: MS Excel
 
Loading...


Show Me The… Formulas?

I don’t know about you but when I’m trying to proofread a document I usually need to go through a hard copy. For some reason seeing things in printed form will usually help with that whole process.

So, what do you do when you’re trying to proof an MS Excel worksheet?

You can print it out, but let’s face it. What you get in the printout is the results of the calculations.

How do you proof formulas when you aren’t seeing them?

You could go through the file on the monitor, cell by cell, continually jumping back and forth visually between the worksheet and the formula bar.

Yep—you could do that but it may take a while. (Not to mention the headache it gives you for your trouble.) And what about the people who proof better from a hard copy?

Are they just out of luck?

Well, let’s hope not! I mean, the program wouldn’t be very versatile if it was a situation of just “too bad, so sad for you”.

So, if we can print the formulas, not the values, then how?

The answer is all in your options.

Options?

Yes – options – as in, Tools menu, Options choice.

Now go to the View tab.

image

In the Windows options section (at the bottom) you’re looking for the Formulas choice.

Check the box.

Then click OK.

Instantly you should be returned to your worksheet where everything is now displayed as a formula, not a value. (Unless the data entered was a number – not a formula – those would still be numbers, of course.)

If you print now you’ll get a printout with the formulas instead of the values.

By the way, this setting will stay until you go back to the Options window and uncheck the Formulas choice. So… you’ll need to repeat the process to return to the calculated numbers.

When proofing, I sometimes find myself printing important files twice—especially if I know I have a mistake somewhere but can’t find it—once with formulas and once with the results. I find that being able to see both pieces of information simultaneously helps with the editing process.

Cheers to finding yet one more way to have what you want when you want it! We all need a few more of those options in our lives.

~ April

Comments are closed.

Like these tips? Get them for FREE in your email!

WorldStart's Tech Tips Newsletter

  • Tech Tips Daily - Become a tech pro! Get the very best tech and computer help sent directly to your email every weekday!

  • Tech Tips Weekly - If you don't want our Tech Tips newsletter every day, then sign up for this weekly newsletter to get the best information of the week. Sent on Fridays.

Other Newsletters

  • WorldStart's Daily Deals - Every week, we send out great deals in our Daily Deals newsletter. Many of these deals are exclusively for our Daily Deals newsletter subscribers and can't be found with our regular specials.

  • Just For Grins - Each issue includes a couple clean jokes, some funny quotes, and a hilarious reader's story. Newsletter is sent five days a week.


Enter Email Address:

Subscribe

Your e-mail address is safe with us!
We only use it to send you the newsletters you request. It is NEVER disclosed to a third party for any reason, ever! Plus, if you decided you don't like our newsletters (don't worry, you'll love them), unsubscribing is fast and easy.

Free Newsletter Signup



Tech Tips Daily

Become a tech pro! Get the very best tech and computer help sent directly to your email every weekday!

Tech Tips Weekly

The week's best in tech and computer help. Get your issue sent to your email every Friday!

WorldStart's Daily Deals

The very best deals on the Internet! Get a new set of incredible sales every day of the week!

Just For Grins

Clean jokes, funny quotes, and hilarious comics. Sent 5 times a week straight to your email.


Subscribe


Love Worldstart? Refer A Friend!

WorldStart's Premium Membership

Tip Archive


Categories:
Archives: