Share via

Using Drag and Drop in Excel on MacBookpro

Anonymous
2019-09-02T19:55:19+00:00

A slightly unimportant issue but slightly annoying if nothing else.  

When moving cell contents by drag and drop, why is a bottom border inserted in the original cell?  This does not occur if I copy and paste or cut and paste the cell content.

Microsoft 365 and Office | Excel | For home | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2019-09-06T14:44:49+00:00

    Thanks for your advice.

    I have been using a spreadsheet showing my monthly expenses to keep an eye on my spending etc.  I have been using the same base sheet for about 5 years now.  for each new month I have created a basic blank standard sheet by creating a copy before the existing sheet, deleting unneeded transactions from it and entering new data. (The existing monthly sheet is then copied into a sheet containing all the previous months for a particular year.

    I think that somewhere in the past, possibly in 2016, one of these copied sheets has had the "fault"in it for some reason.  This has then been forwarded on to future sheets being used.

    I have now created a new sheet for next month (October) which looks like it will be functioning correctly. I have tried a couple of sample entries and the drag and drop seems to be working correctly.

    Why the issue began is beyond me, but I am pleased to say the annoyance has been overcome (I hope).

    1 person found this answer helpful.
    0 comments
Answer accepted by question author
  1. Anonymous
    2019-09-05T03:52:57+00:00

    Dear MALCOLMSMITH7,

    Please ignore the reply from Akiva, I think his post is irrelevant with your concern.

    I've performed the related test under the Office for Mac version 16.28(190812) and here is my test result:

    As you can see, if I use drag & drop, it won't add a bottom line for the original cell, thus I think it should be an issue related with your specific environment. Please check the following methods to narrow down on this issue:

    1.Please share us a screenshot on your Excel for Mac version and MacOS version. We will perform the test under the same environment as yours.

    2.Please check if the issue persist under a new Excel workbook?

    3.Have you installed any add-ins for your Excel? If so, please temporary disable them.

    Thanks for your cooperation.

    Regards,

    Alex Chen

    1 person found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  2. Anonymous
    2019-09-07T22:54:07+00:00

    Hi MALCOLMSMITH7,

    Good to know the issue has been resolved in the new worksheet.

    If issue reoccur in the future, please feel free to come back to us, we will be here for help.

    Regards,

    Alex Chen

    0 comments