Categories
How-To Guides

Google Sheets: How to move cell data with comment to another cell?

I’m not good in Google Sheets, however, I use its basic functions for organizing work-related information.

Recently, I had to polish an old spreadsheet so it would be easier for me to find the information I’ll need. To do so, I had to move cells from point A to B with everything intact such as comments, cell format, data, etc.

It was a challenge to me because I don’t have an idea how to move a comment in a cell to another one. Copy-paste won’t work!

So here’s what I did to accomplish the task:

Time needed: 1 minute.

In Google Sheets:

  1. Cut “the cell with a comment, etc.” that I want to move to another cell.

    Google Sheets - Cut a cell to move data with comment, notes, etc. to another cell

  2. Jump to the cell where I want to move the data

  3. Then, paste.

    Google Sheets - Pasting data to a cell

Now, I know! 😆