You can then follow these steps again if you need to stop hiding your zero values for another spreadsheet in the future. 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. 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 the formulas are visible, print your worksheet as you normally would.Įxcel 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. To show formulas in all cells press CTRL+` (that little mark is the grave accent mark key). With a quick key combination you can see formulas instead of formula results in a worksheet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |