Saturday, November 10, 2012

Hide Zeroes in a Table in Excel


A new version of this post has been published here:
http://easy-excel.com/?p=319




Is it possible to hide all the zeroes in this table? Yes, and it’s easy!










Select the cells, go to the home ribbon, choose Conditional Formatting => Highlight Cell Rules => Equal to...











Type a zero in the left field and choose Custom Format in the drop-down menu.













Go to the Font tab and choose white colour (or light grey, if you don't want to hide them completely): 























And now the table looks nice and clean:


No comments:

Post a Comment