Categories
How-To Guides

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

In this post, I will explain how to move a cell data with comment(s) to another cell with everything intact including cell format, notes, etc.

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! 😆 

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.