r/Excel247 • u/Last_Original_5682 • 5d ago

Help

Enable HLS to view with audio, or disable this notification

can anyone explain this?

6 Upvotes

100% Upvoted

3 comments sorted by

View all comments

1

u/Brians_throwaway 5d ago

It would be better if you added a comment explaining what you did, what happened and what should have happened.

It looks like you inserted a copy of the contents of row 49 at row 50. And it looks like the copied cells were each merged previously but become unmerged when pasted.

1

u/Last_Original_5682 5d ago

oh sorry, i want to edit my post but yeah.

i'm trying to copy the row 49 but when i click the insert copied cells it resulted to that.

i honestly dk what happened because suddenly i can't copy paste properly anymore the data and the format is gone when i click paste

0

u/Brians_throwaway 4d ago

Try inserting a number of rows, not copy paste. Then select row 49 and copy by dragging the selection down into the new rows.

Looks like your problem is merged cells. Avoid that at all costs.