The original results were copied, and the Values pasted back into the same cells before 'deleting' B6. depended on the row they were in, and in the case of column C, also depended on the contents of the same row of column A. Note: the original content of all cells was created using formulas that 1. Those 'same cells' dragged up one row and dropped on B6.The same table, with all cells in column B and below B6 selected.We want to 'delete' cell B6, which contains "EEEEE". In the example, the 'cells' are 'shifted up' into the 'empty' cell space. When you 'delete' the cell, I'm assuming you want the (contents of) the cells below it-or to the right of it-to move into the 'space'. You can delete the contents of a single cell, but the cell itself can be deleted only by deleting the whole row (or the whole column) that the cell occupies.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |