First time here? Check out the FAQ!

In Excel the copy button is not working properly

0 votes
asked by
edited by

When a cell is copied it should show a flashing dotted border around the cell. It does not do this and when the cell is pasted it is only the value that is transferred, also it will not copy to multiple cells.

2 Answers

0 votes
answered by (8.2k points)

Do not try & copy different structured cells, colums or rows at 1 go, as excel cannot do so & cannot paste it in the requisite manner than.

If in case you are copying cells which are merged, cells which are aligned differently, etc, excel will either give you a error, cannot copy different cell structures, or else, it will not allow you to paste even with the paste special option.

–1 vote
answered by (100k points)
edited by

The problem resides in the fact that you try to copy multiple rows and columns which differ by structure. For the copy button to work properly you will need to select the same cells with the same structure and content. This is a minor problem regarding the copying process because it can be easily solved by paying attention to the content that is to be copied to clipboard for different purposes.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register