Heres my workaround: Select cell in question, hit any character to replace contents of the cell. It really should have a one-step shortcut, but to my knowledge, it doesnt. On the Mac, this doesn't seem to work in certain areas, notably Define Names, and the New Formatting Rule window when adding a conditional format that uses a formula. The great thing about copying the contents of the cell rather than the cell itself is to grab the contents without any formatting (plain text). Pressing F2 / Ctrl+U repeatedly will cycle through modes.you'll see the mode displayed in the status bar, in the lower left corner. "Edit" mode simply moves the cursor in the formula text. "Point" and "Enter" work similarly and allow you to point to a cell. ![]() Once you are editing a cell, you can use the F2 / Ctrl+U again to toggle through available edit modes (edit, enter, point). If you want the cursor to move to the formula bar, see below. ![]() This shortcut enters cell edit mode with the cursor at the end of the last line of text in the cell.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |