Menu
![Excel Excel](/uploads/1/2/5/6/125629954/647047652.gif)
Excel displays formula rather than result Sometimes a bug in Excel results in the application displaying the text of a formula rather than the result of the formula in the spreadsheet. I have not been able to find a pattern of when it does it, but I have some spreadsheets that do this consistently. Welcome to Excel 2011 for the Mac: Mastering Formulas and Functions. Practice while you learn with exercise files Download the files the instructor uses to teach the course.
Excel spreadsheets can often be customized to meet your specific needs, so if you need to know how to hide zero values in Excel for Mac 2011, you will be able to adjust your settings to do so. Excel spreadsheet views can be customized in other ways as well, such as if you wanted to to keep it visible as you scroll down. When you make the change that we outline in the steps in this tutorial, your Excel spreadsheet will stop displaying a zero in any of the cells in your worksheet that have a value of zero. You can then follow these steps again if you need to stop hiding your zero values for another spreadsheet in the future. Hide Zero Values in Excel for Mac 2011 This article will hide any zero values in your spreadsheet, regardless of whether you entered a value of zero into a cell, or a formula that was being calculated in the cell resulted in a value of zero. The only exception would be if you format a cell as “Text”. A zero value will be displayed in a cell that is formatted as text.
You can learn more about. Step 1: Open your spreadsheet in Excel for Mac 2011. Step 2: Click Excel at the top of the screen, then click Preferences. Step 3: Click the View button in the Authoring section of the window. Step 4: Click the check box to the left of Show zero values to remove the check mark. Step 5: Click the OK button at the bottom of the window to save your changes and close the window. Your spreadsheet will then update so that any cell containing a value of zero will be empty instead of displaying the zero value.
Does your spreadsheet contain a lot of sensitive information? You can add a password to it with the steps in and make it so that the spreadsheet can only be viewed by someone that has the password you created.
![Excel for mac 2011 displaying formula instead of value chart Excel for mac 2011 displaying formula instead of value chart](https://erc.barnard.edu/sites/default/files/styles/wysiwyg_largest/public/screen_shot_2013-10-24_at_12.55.35_pm.png?itok=NjUw6J5j)
Microsoft Excel can be configured to display column labels as numbers instead of letters. This feature is called ' R1C1 Reference Style', and though it can be useful, it can also be confusing if inadvertently enabled. This document contains instructions for disabling the ' R1C1 Reference Style' feature in the following versions of Microsoft Office:. Office 2008/2011 (Mac). Click on the Excel menu at the top of the screen and select Preferences.
Click on General. Uncheck R1C1 Reference Style. Click OK at the bottom. Office 2010/2013 (Win). Click on the File tab at the top of the screen and select Options. Click Formulas. Uncheck R1C1 Reference Style.
Click OK at the bottom of the window. Office 2007 (Win). Click on the Office button in the top left hand corner. Click on Excel Options. Select the Formulas tab on the left. Uncheck R1C1 Reference Style. Click OK at the bottom.
Office 2003 (Win). Click on the Tools menu.
Choose Options. Click on the General tab. Uncheck R1C1 Reference Style. Keywords: excel xp 2001 2002 2003 2007 2008 column label number letter r1c1 format display header reference Doc ID: 781 Owner: Leah S.