Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete cell shifts cells up - How to avaoid happening
I intended to delete a row. But, by mistake, I right click on the cell
(instead of row) and click delete. Pop up window openswith options Shifts cells Left, Shift cells up, Shift, Entire row, Entire column. Default radio button is Shift cells up. When I accidently click oK button, all the cells below shifts up. Later I realised that my entire data become useless. The cell I deleted was from tel number column. Data was Tel number, Name, Company. Can anyone please advise how to disable delete cell command? Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ADD A BUTTON TO A CELL TO DELETE A RANGE OF CELLS? | Excel Discussion (Misc queries) | |||
what command shifts all cells in a column up or down? | New Users to Excel | |||
Delete record(s) in other cells based on value of one cell. | Excel Discussion (Misc queries) | |||
Text in cell shifts up when printed on HP Laserjet 5 | Excel Discussion (Misc queries) | |||
How do you delete one cell from a range of protected cells | Excel Worksheet Functions |