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 without scores so I will have last score, next to last, etc
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
was hoping that there was a function like small or large that would do that. Tried your suggestion and it worked. Thanks for that!
