How do you get the formulas on an Excel spreadsheet to

[Longhorn]

display in the cells? I'm putting together a tutorial for my students and when they turn in their results by printing, I'd like to be able to see the formulas they entered, not just the results. I've asked that dang paperclip this question every way I can think of and can't find the answer! ;)

Thanks!

[Ready4Change]

1. Think this will work

Open the Tools menu
Click Options...
Click the View Tab
Check box for Formulas
Click OK.

Hope that got it? (Took me a while to track it down, too.)

[Longhorn]

2. Wow, thanks for taking the time to find this for me!

I checked out all the menus I thought would apply but didn't go deep enough on the Tools menu. :yourock:

[Ready4Change]

3. No problem.

I like digging for stuff like that, and knew that one was in there somewhere.

[NewHampshireDem]

4. Shortcut: CRTL + ` (upper left corner of your keyboard)

Hope that helps! :)

[Longhorn]

5. Now that's cool!

I'm going to do a search for Excel shortcuts and see what else I can do. Thanks!

[NewHampshireDem]

6. You're welcome! :) n/t