Exclude empty cells from sheet

[rodrigorequiao]

Good afternoon,

I am trying to exclude all empty cells from my sheet, but I cannot find a way to do it other than to exclude them one by one. I am trying to make this:

To turn into this:

Does anyone know a way to do it?

 

[CodeNinja]

Highlight the range (A1:K5) then use goto special (CTRL + G) and click on Special button... then choose the radio button "Blanks". Now right click on one of the cells that are selected and choose delete. When prompted choose shift cells left.

Good luck,

CN.

 

[rodrigorequiao]

Thank you, it worked out perfectly!