'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Missing Excel Copy and Paste Dotted Lines
Question details
The user is unable to see the animated dotted border around cells after copying them in Excel.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Copying and pasting data in spreadsheets.
- Observed behavior
- The animated dotted border (marching ants) that usually highlights copied cells does not appear when copying.
Ensure you have saved your current workbook and note any recently installed third-party plugins or browser extensions, as they often interfere with clipboard behaviors.
Launch Excel in Safe Mode and Disable Conflicting Add-ins
Running Excel in Safe Mode bypasses add-ins and startup programs, helping you identify if a third-party extension is breaking the copy-paste animation.
The 'marching ants' animation relies on the system clipboard and Excel's UI renderer. Third-party add-ins or competing background applications can frequently hijack the clipboard, causing the dotted line to vanish.
Make sure Microsoft Excel is fully closed and no hidden spreadsheet windows are running in the background.
Press and hold the 'Ctrl' key on your keyboard, then click the Excel shortcut to launch it. Click 'Yes' when prompted to start in Safe Mode.
Open a blank workbook, type text in a cell, and press Ctrl+C. Check if the dotted lines appear.
If the lines appear in Safe Mode, navigate to 'File' > 'Options' > 'Add-ins'. Select 'COM Add-ins' from the Manage drop-down menu and click 'Go'.
Uncheck the add-ins one by one, clicking 'OK' and testing the copy function each time to find which add-in is causing the issue.
Try WPS Office for a Bug-Free Spreadsheet Experience
Tired of troubleshooting Excel clipboard glitches and add-in conflicts? WPS Office offers a free, lightweight, and highly compatible alternative that handles your spreadsheet tasks perfectly without bogging down your system.
- 1. Download the software: Visit the official WPS website and click 'Download WPS Office Free' to get the installer.
- 2. Open your files seamlessly: Launch WPS Spreadsheet and directly open your existing Excel workbooks without worrying about format issues.
- 3. Work efficiently: Select cells and use copy/paste with reliable, built-in visual feedback that does not easily conflict with Windows background apps.
Frequently Asked Questions
Why do the marching ants disappear when I switch to another window?
By design, Excel may clear the clipboard and remove the dotted selection lines when you switch to certain other applications, double-click another cell, or start typing elsewhere to prevent accidental pasting.
Can a full clipboard cause the copy-paste border to vanish?
Yes, if the Windows Clipboard is overloaded or being actively monitored by another program (like a dedicated clipboard manager or remote desktop software), Excel may fail to display the dotted outline.
How do I clear the clipboard to restore the dotted lines?
You can clear the system clipboard by pressing the Windows Key + V to open the clipboard history, then clicking 'Clear all'. Restarting your spreadsheet application afterward often restores normal copy-paste functionality.
