Fix a Border Left Behind When Dragging Cells in Excel for Mac
Question details
Find out why a bottom border appears in the original cell after its contents are moved by dragging.

- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- The user moves cell content by drag and drop in an Excel worksheet on a Mac.
- Observed behavior
- A bottom border appears in the original cell after the content is moved.
Note the affected cell and how you drag it so you can repeat the same action in a test sheet. Check Excel > About Microsoft Excel and the Apple menu > About This Mac for your Excel and macOS versions.
Test a New Worksheet and Recreate the Affected Sheet
Use this approach to determine whether the border is specific to the worksheet or your Excel environment.
Choose File > New Workbook, enter sample content in a cell, and drag the cell to another location. Check whether a bottom border appears in the original cell.
In the affected workbook, click the plus button beside the sheet tabs to add a worksheet. Repeat the drag-and-drop test there.
If the issue also occurs in a new workbook, open Tools > Excel Add-ins, note which add-ins are enabled, and temporarily clear their checkboxes. Repeat the test, then restore the add-ins you need.
If the issue occurs only in the original worksheet, add a new sheet and copy the required data into it. Use Paste Special options to transfer values and any necessary formatting, then test dragging again.

Remove an Unwanted Cell Border
Use this to remove an existing border when you do not need to keep the cell's other borders.
Work With Excel Spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheets. Open compatible Excel files in WPS Spreadsheet to make moving between office suites easier; it does not repair an Excel-specific issue.

Frequently Asked Questions
Why does a border appear after I drag a cell?
The behavior may be related to the worksheet's formatting or condition, or to the Excel environment. Repeat the same drag in File > New Workbook to see whether it is specific to the original file.
How do I remove the bottom border from the original cell?
Select the cell and choose Home > Borders > No Border. This removes all directly applied borders from the selected cell, not just the bottom border.
What if the border appears only in one worksheet?
Add a new sheet using the plus button beside the sheet tabs, then copy the required data and formatting into it. Test the same drag operation in the new sheet.
How can I check whether an add-in is involved?
Open Tools > Excel Add-ins, note the enabled add-ins, and temporarily clear their checkboxes. Repeat the drag test, then re-enable the add-ins you need.




