Forum Discussion
compressing out zero or blank cells in a row
I am trying to manage individual players scores we have weekly scores, players do not always play what I want to do is reverse the order of the scores and have last first and compress out any cells w...
Hi Carlos,
To remove blank rows in the range please check this http://www.techrepublic.com/blog/microsoft-office/a-quick-way-to-delete-blank-rows-in-excel/, after that sort as you need
trying to determine how to compress cells to left if it is blank or zero. i have a row of 23 cells, some with scores and so me either blank or zero. I don't know how to get zeros to look like a blank so the function key works. Any suggerstions
Hi Carlos,
To show zeros as blank you may apply custom format
0;-0;;@
More options and details is here https://support.office.com/en-gb/article/Display-or-hide-zero-values-3ec7a433-46b8-4516-8085-a00e9e476b03#ID0EAAEAAA=2010