 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / December 2007Unable to add/delete/clear content of a row
My 2007 excel workbook has several sheets. One of them doesn't allow me to add, delete, or clear content of rows. This means when I right- click on a row, the "insert", "delete", "clear content" is grey out. Same thing when I use the ribbon. This only happens to this sheet, as the other ones don't have such problem. I can modify the content of cells and the sheet is not protected. Can someone shed a light on this mystery? I have Excel 2003, but could the Protect Sheet option be turned on for the sheet (Tools | Protection | Protect Sheet menu in Excel 2003) > My 2007 excel workbook has several sheets. One of them doesn't allow > me to add, delete, or clear content of rows. This means when I right- [quoted text clipped - 6 lines] > > Can someone shed a light on this mystery? Sorry, didn't read your entire message. If the protection is not on, can you copy all the data to a new sheet and delete the offending one? > My 2007 excel workbook has several sheets. One of them doesn't allow > me to add, delete, or clear content of rows. This means when I right- [quoted text clipped - 6 lines] > > Can someone shed a light on this mystery? I get the same issue. When I try to insert a row, it gives me a message about there is a lot of data and that it will take several minutes. I accept the message and it tries and then comes back with no change. I have tried saving it as a old version of Excel, copy it from the network to my local drive. There are three sheets in this workbook and two of the three are fine. The third one will not work. This is a file that was originally create in Excel 2003. I saved it as an Excel 2007 files yesterday and that is when the problem started happening. > My 2007 excel workbook has several sheets. One of them doesn't allow > me to add, delete, or clear content of rows. This means when I right- [quoted text clipped - 6 lines] > > Can someone shed a light on this mystery? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.