1. select A2.*
2. click & drag the scroll bar to the end where the data of column O ends (row 100)
3. press & hold the SHIFT key & left click on the last cell in column O (O100). you should see them all selected
4. press CTRL + G Special Blanks OK. now only blanks are selected
5. right-click on any of the selected blank cells & click "Delete" (you have to repeat the above steps if you select any other cells. another way which is safer would be to go to Home Delete Delete Cells)
6. Shift cells left
7. OK
https://www.excelforum.com/excel-general/886341-move-data-to-empty-left-cell.html
Tidak ada komentar:
Posting Komentar