ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   grey dot in left upper corner of cell (https://www.excelbanter.com/excel-discussion-misc-queries/80890-grey-dot-left-upper-corner-cell.html)

singnothing

grey dot in left upper corner of cell
 

What is this dot? Don't know how it got there, but it seems to coincide
with a strangely large file size for the cell. How do I get rid of this?


--
singnothing
------------------------------------------------------------------------
singnothing's Profile: http://www.excelforum.com/member.php...o&userid=33058
View this thread: http://www.excelforum.com/showthread...hreadid=528724


Door

grey dot in left upper corner of cell
 

select the cell and press DEL ?

If the dot is in A1, then in B1 try =Len(A1) to see if there is valid
data there.

Is the cell format 'wrap'

Is the cell format text colour white (on white)?

Can you copy a blank cell and Paste it over this cell?

Any further clues?



singnothing Wrote:
What is this dot? Don't know how it got there, but it seems to coincide
with a strangely large file size for the cell. How do I get rid of this?



--
Door
------------------------------------------------------------------------
Door's Profile: http://www.excelforum.com/member.php...o&userid=33068
View this thread: http://www.excelforum.com/showthread...hreadid=528724



All times are GMT +1. The time now is 11:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com