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!
You must log in to post a comment.