Why are my Ctrl - and Ctrl + shortcuts (delete and insert cells) not behaving properly

Abhinav Jain 5 Reputation points
2024-05-20T06:00:19.39+00:00

I have multiple versions of the same file. I thought that the latest ones got corrupt at some point and Ctrl - wasn't working. All it did was delete the cell contents instead of deleting the cells.

So i started testing for the latest non corrupt file and found it, Ctrl - worked to delete 2-3 rows, then i tried deleting columns and it made the same error, deleting cell contents. Then when i tried deleting rows again (which worked earlier) and it started making that same error. I have no idea why this is happening. Please help.

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,619 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,671 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Chrysostomos Lefteratos 285 Reputation points
    2024-05-21T09:38:33.14+00:00

    Does it help?

    • Create a New Workbook: Copy and paste the data from the problematic workbook into a new Excel workbook. This can sometimes help resolve issues related to file corruption.
    • Save in a Different Format: Try saving the file in a different format (e.g., .xlsx to .xls or .csv) and then back to .xlsx.