In this video tutorial, I show you two ways to hide zero values in Excel 2010. In my example, I have a worksheet with formulas to add two amounts that I will be adding to throughout the year. Since I don’t want the zeros to appear in my worksheet, I try two different methods to hide them.
The first is by using Advanced Excel Options (File – Options – Advanced – Display Options for this Worksheet) and un-checking the “Show a zero in cells that have zero value” box.
The second method is by selecting the part or all of the worksheet to apply the formatting to and using Conditional Formatting (Home – Conditional Formatting – Highlight Cells Rules – Equal To) and formatting cells that are equal to 0 with custom formatting. In custom formatting, I change the font color to white. This changes all zero values to white so they are hidden from view and from printing.
This quick tutorial shows how you can easily automate data to fill in Excel. This example shows how to automate months and numbers to fill cells in Excel as well as how to expand an equation to fill cells by dragging data.
In this example, we have a fictional address list in which part of the data is in all caps and the rest is in sentence case. Additionally, some zip codes have the additional 4 digits and for this example, we only want to use 5-digit zip codes.
We use the UPPER function to change all the text to uppercase and the LEFT function to choose only the first 5 digits of the zip code. Also shown is paste values.
Video recorded using Cam Studio (www.camstudio.org)
This is a sample fictional budget to demonstrate how to use the format cell function, auto sum and simple equations in Excel. I demonstrate how to calculate a budget of monthly bills and extend the calculation to determine the cost of bills per year.
In this video, we are creating a simple HR employee hire form and limiting the user to selecting numeric months and years from a drop-down list on a separate tab. The tab can be hidden from the workbook once the form is complete so the user cannot alter the data.
The tutorial was done in Microsoft Excel 2010, but the function will be similar in previous versions.