Hiding Cell Values In Excel
I have an Excel spreadsheet that I use to keep track of all my business expenses. In order to make it less cluttered, and easier on the eye, I wanted to get rid of all the repeated, irrelevant values in the columns that may not have an entry for each day. Here I am using a subset of the data, but it illustrates what I am trying to achieve:
Hiding zero values in a range or even a whole worksheet is easy. However, I wanted to hide the value of a cell if its' neighbouring cell was zero or blank. Here’s how I did it:
Select the values in the column you wish values to be hidden (“Cumulative” in this case).
On the Home toolbar click the “Conditional Formatting” button, select “Highlight Cells Rules” then “More Rules…”
Ensure the Style is “Classic” and then select “Use a formula to determine which cells to format” in the drop-down. Enter “=$b2=0” in the text box. Obviously, my data is in Column B and starts in Row 2, so you will need to to adjust this as necessary.
In the “Format with” drop-down select “Customised Format…”
Select “Custom” under “Category” and then select (or enter) “;;;” for the “Type”
- Select “OK” twice
The “Cumulative” column now only shows data where there is an entry for that row in the “Miles” column: