Google Sheets: Edit in the Cell

This week I was asked…. when you need to go back to a cell, how do you edit the cell so as to not have to start over?

Single Click to Replace Cell Text

When you click on a cell and start typing it will override what is in the cell. Use Control Z to undo if you did not mean to remove the entire contents of the cell.

Double Click to Edit Cell Contents

If you double click on the cell you are able to edit the content in the cell. This allows you to add to the content that is in the cell.

Shift Enter to Edit Cell Text

If instead of double clicking on the cell you hold down the Shift key and press the Enter key it will allow you to edit the cell text and the cursor will be right at the end of the text. This allows you to append the text without using the mouse at all!

Leave a Reply

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