Sunday, October 14, 2012

A Line Won't Delete in Microsoft Excel


1. Check to see if you are highlighting the correct line to delete in your document. Point your cursor on the line number on the right side and left-click to highlight. Once highlighted, you should be able to delete the line.
2. Remove any document protections. If the Excel document is protected, this may prevent editing including removal of lines. On the 'Review' tab, click to see 'Changes' group to see if there are protections on the worksheet or workbook. These may have to be removed or a password inserted to continue.
3. Investigate the explanation of any error messages you receive when attempting to delete a line in Excel. The error message may provide insight into why the command cannot be executed. If you do not understand the message, visit Microsoft Online to search for Excel help.
4. Highlight all rows and press F5 and 'Go To' and click 'Special.' Select 'Visible Cells' and click 'OK.' This may now allow you to delete lines as necessary, especially if there are multiple or hidden lines.
5. Close the Excel document and exit the application. Delete any temporary or extra files off your computer as you may have a memory or resource issue. Shut down your machine and reboot. Open your Excel document and retry to delete your line.

Blogger news