Forum Discussion
Black dots in upper right corner of Excel cells
- Jun 25, 2022
These are ink objects with height 0 and width 0.
Draw and write with ink in Office
Use the selection pane (ALT-F10) or F5 to manage (delete) the objects.
I tried to attach a section I copied from the spreadsheet but can see no way to attach a document. Instead, I uploaded the test spreadsheet to my website and put a link here so you can download it to examine it: https://argee.net/.Test.xlsx Note cells with one dot: A5, J5, Y5, AG5, AW5, AX5, BA5, BC5, BE5, and BU5. There are two dots in H6, AF6, and BD6. Both of these appear many times throughout the original spreadsheet. The formatting of the affected cells appears completely normal. When I copy the format, the dot(s) appear in the new cell. When I cut and paste, the dot(s) remain in the original cell AND appear in the new cell. I appreciate any help you can give me.
These are ink objects with height 0 and width 0.
Draw and write with ink in Office
Use the selection pane (ALT-F10) or F5 to manage (delete) the objects.
- KiriMorgan-shetheyJul 26, 2023Copper Contributor
You're a lifesaver.
I was tearing my hair out over "dirty" cells in a spreadsheet that was crashing my computer and taking forever to load and save.
Thanks to this I found hundreds of these stupid little objects in my file, and now that they are all gone, I have no more trouble loading or saving the file!
- RGWilliscroftJun 25, 2022Copper ContributorThat worked. Thank you!