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:
- Cut “the cell with a comment, etc.” that I want to move to another cell.
- Jump to the cell where I want to move the data
- Then, paste.
Now, I know! 😆