Microsoft 365 and Office | Excel | For education | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
You may check this link for Stale Value Formatting.
Auto - Strikethrough from Microsoft Excel
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
Whenever I open the Excel sheet, most of the numbers have a strikethrough. I tried pressing Ctrl + 5, but it didn’t resolve the issue. The strikethrough only disappears when I press the F9 button, but having to do that every time is inconvenient. Please help me resolve this issue.
Microsoft 365 and Office | Excel | For education | Windows
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
7 answers
Sort by: Most helpful
-
Anonymous
2024-10-14T08:03:58+00:00 -
Anonymous
2024-12-12T12:33:28+00:00 We just had the same thing, only on the screen it was clear. but when printing to pdfs via code, all the pdfs had strikethroughs. Looks like Microsoft turned on this as the options on refresh also changed. Now there is a partial option too as well as turn off strikethrough.
I hope someone at Microsoft is watching these. It's a buggy release.
-
Anonymous
2024-10-16T19:51:11+00:00 One of my spreadsheets just started getting the strikethrough effect. I couldn't get rid of it and thought it was a virus. Apparently, this change was made in 2023, but I had not come across it until now. There really should be a pop-up saying what happened.
-
Anonymous
2024-10-15T03:16:18+00:00 You are welcome:)
-
Anonymous
2024-10-15T03:09:55+00:00 Thanks, It works for me.