In a big excel data how we remove single cells in between the data?

Question

In a big excel data how we remove single cells in between the data?

Answer 1

you may need to be careful deleting cells, as this can mess with calculations further down or across. The alignment of reference cells may no longer be in correct place so any calculations may error out as data cannot be found, or your result may be different as another value is entered in the final result. If you have graphs etc in this file they may not work. Try saving the file to a back up location and then try editing one of the files.

Answer 2

right click on the cell

select Delete

excel will prompt you if you want to shift the other cells up, down, left, right, etc.