 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Excel / December 2007where are my functions?
In Mac for Excel, which I just bought, there's no place in the toolbar that shows the contents of a particular cell. When I see #REF in the cell, I want to know what's IN the cell in order to fix the reference? Is there a specific toolbar for that? Thanks, In article <4670ba2a-3256-4dcf-a32c-3d600499da24@c4g2000hsg.googlegroups.com>, > In Mac for Excel, which I just bought, there's no place in the toolbar > that shows the contents of a particular cell. When I see #REF in the > cell, I want to know what's IN the cell in order to fix the > reference? Is there a specific toolbar for that? If the formula box in the formula bar has something like =#REF! then the referenced cell(s) have been deleted, and you can't get the reference back. The other option is that the cell refers to a non-existent reference, e.g.: =Sheet11!A2 where Sheet11 doesn't exist within the workbook. On 12/21/07 6:09 PM, in article jemcgimpsey-2B2155.16094121122007@news.microsoft.com, "JE McGimpsey" <jemcgimpsey@mvps.org> wrote: > If the formula box in the formula bar has something like I think that's the problem - sounds like the Formula Bar isn't displayed:-) Rolfe - The first place to check is the View Menu to make sure there Formula Bar is selected. That should fix it. If it is already checked & the Formula Bar still doesn't display hunt around a bit as it may be at least partially covered by another toolbar. If you're sure it isn't there come back & let us know. In the meantime, you can view the cell content directly in the cell if you double-click the cell. HTH |:>) Bob Jones [MVP] Office:Mac > On 12/21/07 6:09 PM, in article > jemcgimpsey-2B2155.16094121122...@news.microsoft.com, "JE McGimpsey" [quoted text clipped - 17 lines] > Bob Jones > [MVP] Office:Mac ack I'm an idiot......thanks......I was looking under the View-- Toolbars menu for the formula bar when it was staring me in the case on the view menu the whole time.....Thanks! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.