'%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)
How to Fix Excel Not Showing Marching Ants Border When Copying
Question details
The user needs to restore the animated dashed border that visually indicates copied cells or selected formula ranges.
- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Copying cell data or selecting ranges for formulas like VLOOKUP and IF.
- Observed behavior
- The animated dashed border, commonly known as marching ants, does not appear around the selected cells.
Verify if the issue occurs in a brand-new, blank workbook to determine if the problem is specific to one corrupted file or relates to the entire Excel application.
Run a Microsoft Office Repair
Using the built-in Office repair tool can fix corrupted application files that cause display glitches.
Press the Windows key + I on your keyboard to open Settings, then navigate to Apps > Installed apps.
Scroll down the list or use the search bar to find your Microsoft Office or Microsoft 365 installation.
Click the three dots (or right-click) next to the app, select Modify, choose Quick Repair, and click Repair. Restart your computer once finished.
Test Excel in Safe Mode
Booting Excel in Safe Mode helps identify if a third-party add-in is blocking the selection border.
Update Graphics Drivers
Outdated or corrupted display drivers can prevent Excel animations, such as the dashed copy border, from rendering correctly.
Switch to WPS Office to Avoid Display Glitches
If Microsoft Excel continues to suffer from missing borders and display bugs, consider trying WPS Office. It offers a smooth, lightweight spreadsheet application with high stability and familiar tools.
- 1. Download and Install: Visit the official WPS website and download the free WPS Office installer.
- 2. Open WPS Spreadsheet: Launch the application and select Spreadsheet to start your work.
- 3. Edit Your Excel Files: Open your existing .xlsx files directly; they will load perfectly with all formatting preserved.
Frequently Asked Questions
What is the marching ants border in Excel?
The 'marching ants' border is the animated, rotating dashed line that appears around cells when you copy them or select them for a formula. It visually confirms which data is currently saved on your clipboard.
Why does the copy border disappear when I start typing?
In Excel, performing certain actions like typing, double-clicking another cell, or pressing the Escape key automatically clears the clipboard, which intentionally removes the marching ants border.
Can conditional formatting hide the copy border?
Yes, heavily layered or complex conditional formatting rules can sometimes overload Excel's graphics rendering, which occasionally causes the copy border animation to fail.
