I know how to go into options and show all formulas, instead of the result. What I want to know is there any way to show the formulas only for certain cells - like show all the formulas in Column C, but I want to see the result of the formulas everywhere else on the sheet. Is this possible to do?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Show certain formulas
- Thread starter tbruin
- Start date
Zack Barresse
MrExcel MVP
- Joined
- Dec 9, 2003
- Messages
- 10,881
- Office Version
- 365
- 2010
- Platform
- Windows
- Mobile
- Web
ya, it's called copy/paste special values.
other than that, your SOL i think.
hope this helps.
other than that, your SOL i think.
hope this helps.
Upvote
0
I'm thinking it's probably not possible. I was just curious if someone else could think of a creative way. I don't see how paste special would accomplish this though - if you paste special formulas, it's not going to show the formulas just copy the formulas over. Maybe I'm missing something with that one; it wouldn't be the first time.
Upvote
0
Zack Barresse
MrExcel MVP
- Joined
- Dec 9, 2003
- Messages
- 10,881
- Office Version
- 365
- 2010
- Platform
- Windows
- Mobile
- Web
well, my thinking was if you wanted to create another copy (at least i would), copy a:b, paste special -> values, copy c, paste, copy d:end, paste special ->values. not very practical though, but for viewing only formula in column c, maybe you could think about doing that, or writing a macro for it - if repetition is going to be utilized.
i dunno, just a thought.
i dunno, just a thought.
Upvote
0
Similar threads
