How to make Excel show formula?

IHAVEAQUESTION

Golden Member
Nov 30, 2005
1,062
3
81
Well, i am trying to compare the formula of my classmates and mine...but I can't see theirs, it's showing up as $B$*(B1/B2). I am guessing the $B$ is the reference...but what does it mean? How do I make it appear as something understandable?
 

zzuupp

Lifer
Jul 6, 2008
14,866
2,319
126
from the auditing functions: you can 'trace all precedents' & it will point to b1, b2 & wherever $b$ is.
or from insert>names that will show a dialog with all of the defined names. You can highlight that one, and it will show you the cell reference.
 

NeoV

Diamond Member
Apr 18, 2000
9,504
2
81
hitting F2 should show you the referenced cells as well, assuming your cursor is currently on the cell with the formula

usually $ are used to anchor columns/rows in place, so that when a formula is copied, those don't change