how to shift the cells to left to fill blank cells

[rehanemis]

Hi,

I would like to fill the blank cells by shifting cells to right. I found the solution
"Make sure you only have a single cell selected.

1. Press F5
2. Click the "Special..." button
3. Select "Blanks" and click OK
4. Right click and select "Delete..."
5. Select the "Shift cells left" option and press OK

"
The problem with that I only wants to apply it from column D to K not on the others.

Any suggestion?

 

[Joe4]

Just highlight the range (columns D-K) you want to apply it to before running steps 1-5.