Longhorn
(1000+ posts)
Send PM |
Profile |
Ignore
|
Sat Mar-26-05 06:11 PM
Original message |
How do you get the formulas on an Excel spreadsheet to |
|
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
(1000+ posts)
Send PM |
Profile |
Ignore
|
Sun Mar-27-05 12:26 AM
Response to Original message |
|
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
(1000+ posts)
Send PM |
Profile |
Ignore
|
Sun Mar-27-05 12:39 AM
Response to Reply #1 |
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
(1000+ posts)
Send PM |
Profile |
Ignore
|
Sun Mar-27-05 01:00 AM
Response to Reply #2 |
|
I like digging for stuff like that, and knew that one was in there somewhere.
|
NewHampshireDem
(1000+ posts)
Send PM |
Profile |
Ignore
|
Mon Mar-28-05 09:53 AM
Response to Original message |
4. Shortcut: CRTL + ` (upper left corner of your keyboard) |
Longhorn
(1000+ posts)
Send PM |
Profile |
Ignore
|
Mon Mar-28-05 10:06 AM
Response to Reply #4 |
|
I'm going to do a search for Excel shortcuts and see what else I can do. Thanks!
|
NewHampshireDem
(1000+ posts)
Send PM |
Profile |
Ignore
|
Mon Mar-28-05 01:00 PM
Response to Reply #5 |
6. You're welcome! :) n/t |
DU
AdBot (1000+ posts) |
Fri May 10th 2024, 06:54 AM
Response to Original message |