With this change, I can no longer double-click to edit a cell. On a Mac, go to preferences by using Command + comma, then click "Edit", and uncheck checkbox called "Double clicking allows editing directly in a cell" Then go to Advanced, and uncheck the checkbox labeled "Allow editing directly in cells" In Windows, use Alt F to access the File menu, then T to access options. If you want to always edit cells in the formula bar, even when you use a keyboard shortcut to edit a cell, you'll need to change a setting. You can also double-click a cell to edit. ![]() ![]() With Excel's default settings, this will put your cursor directly in the cell, ready to edit. ![]() In this video, we'll look at shortcuts for editing cells.įirst, the keyboard shortcut for editing a cell is F2 on Windows, and Control + U on a Mac.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |