ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pasting symbol? (https://www.excelbanter.com/excel-discussion-misc-queries/452063-pasting-symbol.html)

Terry Pinnell[_4_]

Pasting symbol?
 
In Excel 365 I inserted some new rows and this format symbol appeared.

https://dl.dropboxusercontent.com/u/...-Pasting-1.jpg

What exactly should I have done with it? What I actually did was to
click 'Format same as above'. Nothing obvious happened. In particular,
the symbol did not go away. How do I remove it, as it's rather
distracting?

--
Terry, East Grinstead, UK

GS[_6_]

Pasting symbol?
 
In Excel 365 I inserted some new rows and this format symbol
appeared.

https://dl.dropboxusercontent.com/u/...-Pasting-1.jpg

What exactly should I have done with it? What I actually did was to
click 'Format same as above'. Nothing obvious happened. In
particular, the symbol did not go away. How do I remove it, as it's
rather distracting?


Press the ESC key makes it disappear.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


Terry Pinnell[_4_]

Pasting symbol?
 
GS wrote:

In Excel 365 I inserted some new rows and this format symbol
appeared.

https://dl.dropboxusercontent.com/u/...-Pasting-1.jpg

What exactly should I have done with it? What I actually did was to
click 'Format same as above'. Nothing obvious happened. In
particular, the symbol did not go away. How do I remove it, as it's
rather distracting?


Press the ESC key makes it disappear.


Thanks Garry. Yep, discovered that embarrassingly obvious solution
shortly after posting. (Pity there's no reliable way to delete posts!)

Usually, clicking elsewhere also does it, but not in this case.

--
Terry, East Grinstead, UK


All times are GMT +1. The time now is 09:51 AM.

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