Show Formula Bar In Excel 2008 For Mac
My friend has a Mac is now learning Excel. She has toolbars Standard and checked. The formula bar is missing from up in the menu of the toolbar.
What is the keyboard shortcut or menu icon that allows me to see the formulas for a worksheet instead of the values in the cells for a worksheet for Excel for Mac 2008. I have spent 20 minutes on google, macRumors, and Mactopia and can not find the answer. Perhaps this feature does not exist for the mac version. I wouldn't be surprised as I am growing very with Office for Mac. Excel in my opinion is very inefficient.
h21h21h21h21h21h21h21h21h2
1(Enough of that). I desperately need to know how to toggle between values and formulas for a worksheet. In Microsoft Excel 2007 (for vista or xp or earlier versions) the keystroke is CTRL `. What is it for Excel for Mac 2008. Please help as I am pretty frustrated and need to find this.
I am using Excel 2008 for Mac (I am also trying to work using the newest version of Excel on my computer, but it keeps crashing). When I open the spreadsheet that I need to work from, some of the cells seem to contain too many characters, and are converted to '#' symbols: The data in the cell is supposed to be text with snippets of code (the% symbol appears as well as @ symbols). I tried expanding the size of the cells, but it didn't change anything. I cannot find much help online about this version of Excel, but following, I decided to ask it here. Excel can store about 32,000 text characters in a cell, but it can only display up to 255 characters if the cell is formatted as text.
If the cell contains more than 255 characters and the cell is formatted as text, then the hash marks are . The solution is to change the format of the cell to general; then the text will display as you expect. You should also note that you might see hash marks appear if you change the size of the font used in a cell.
Change the font to a larger size, and Excel may not be able to display the value horizontally. If you can't widen the column then consider making the font smaller so that Excel can make the full value visible.
