Formatting Issues

Fix a Border Left Behind When Dragging Cells in Excel for Mac

Muhammad TalhaMuhammad Talha Nov 14, 2026 869 views

Question details

Find out why a bottom border appears in the original cell after its contents are moved by dragging.

Fix a Border Left Behind When Dragging Cells in Excel for Mac
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.
Before you start

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.

Solution 1Recommended

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.

1
Test a new workbook

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.

2
Test a new worksheet

In the affected workbook, click the plus button beside the sheet tabs to add a worksheet. Repeat the drag-and-drop test there.

3
Check Excel add-ins

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.

4
Recreate the affected sheet

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.

Test a New Worksheet and Recreate the Affected Sheet
Compare the test results: If the new sheet works correctly, the original sheet's formatting or condition may be involved. If both sheets show the issue, the cause may be specific to the Excel environment.
Free Microsoft Office alternative

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.

Move cell contents and manage cell borders in WPS SpreadsheetOpen and edit Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interfaceTry a free, lightweight office suite
microsoft office alternative - wps office

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.