LinkBack Thread Tools Search this Thread Display Modes
  #31   Report Post  
Old April 30th 20, 08:55 AM posted to microsoft.public.excel.newusers
external usenet poster
First recorded activity by ExcelBanter: Apr 2020
Posts: 1
Default "Marching ants" around copied cell

On Thursday, 15 January 2009 15:04:33 UTC, Riccol wrote:
I know this is going to sound dumb but this really bugs me.

When I copy a cell(s), the copied area is highlighted with "marching
ants". Seems that after pasting, the "marching ants" around the source
area should go away, but it doesn't. The only way I can get rid of the
"marching ants" around the source is to click like a madwoman in a cell
adjacent to the ants. Sometimes when I do that though, the clicking goes
awry and I get stuck in a tangle that is very hard to explain, but the
only way out is to close the workbook without saving and then re-open it.

So my question is, what's the right way to get rid of the ants
highlighting the source area after copying?

(Excel 2002)


Simple, just right click the cell with the dancing ants, select format, press okay in the pop-up window and it's done.

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
HOW DO I SURROUND DATA WITH COLORFUL MARCHING ANTS novastar102c Excel Discussion (Misc queries) 1 November 10th 08 02:21 PM
At what times do the "moving ants" appear around a cell? sheana New Users to Excel 1 February 6th 08 10:47 AM
Turn off selection marching ants in Excel 2003 [email protected] Excel Discussion (Misc queries) 1 July 10th 07 10:01 PM
How to setup "marching ants" border Excel cell? OK in MS Word. NJDevil Excel Discussion (Misc queries) 3 January 31st 07 05:46 PM
Excel should include flashing cells/block and marching ants like W waholt Excel Worksheet Functions 2 October 21st 05 06:56 PM

All times are GMT +1. The time now is 04:02 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017