Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I can't delete a cell without deleting a row
I am using Excel on a work computer that someone else may have changed the
settings on. I want to simply delete a cell, without deleing the entire row the cell belongs to. Yet when I highlight the cell, and go to Edit - Delete, the program asks me if I want to delete the entire row, and only gives me two options: OK or Cancel. So I can't delete just one cell (and have all of the lower cells shift up one). When I right click, the 'delete' option is not present either. I tried changing the menu properties to add the 'delete' function, but it will not delete a cell without taking out the whole row. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
I can't delete a cell without deleting a row
I have the same problem but I don't think it's a setting because I didn't change anything. I've noticed this happens occassionally when I'm doing a bit of cutting and pasting. All of a sudden I can't delete cell contents, only rows. I've tried saving document, closing it and re-opening but it doesn't help. When I go into another excel file, I have no problem, it just occurs in the the one file I was cutting and pasting in. so I think it's something to do with that, possibly the Paste Values option? Anyway, when it's occurred before, I've managed to do something that's stopped it, i.e. I can delete cells again but I cant' figure out what! Does anyone know what causes this to occur and how to 'turn it off'? -- SandyW ------------------------------------------------------------------------ SandyW's Profile: http://www.excelforum.com/member.php...o&userid=35892 View this thread: http://www.excelforum.com/showthread...hreadid=544900 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
I can't delete a cell without deleting a row
I've figured out why Excel does this. I was using a filter on one of the columns. If you're using a filter then it only comes up with the 'Delete Row' option. If you take the filter off so you're viewing all the data then it allows you to delete cells. -- SandyW ------------------------------------------------------------------------ SandyW's Profile: http://www.excelforum.com/member.php...o&userid=35892 View this thread: http://www.excelforum.com/showthread...hreadid=544900 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
resetting last cell | Excel Discussion (Misc queries) | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Delete row based on contents of cell | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions |