Tips Get rid of entire columns or rows by right-clicking on the column or row header and clicking "Delete." This removes all cells in that column or now.