ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   I can't delete a cell without deleting a row (https://www.excelbanter.com/excel-discussion-misc-queries/90171-i-cant-delete-cell-without-deleting-row.html)

Tenny May 23rd 06 11:06 PM

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

SandyW June 29th 06 09:50 AM

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


SandyW June 30th 06 12:52 AM

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. :rolleyes:


--
SandyW
------------------------------------------------------------------------
SandyW's Profile: http://www.excelforum.com/member.php...o&userid=35892
View this thread: http://www.excelforum.com/showthread...hreadid=544900



All times are GMT +1. The time now is 12:42 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
ExcelBanter.com