Once you are editing a cell, you can use the F2 / Ctrl+U again to toggle through available edit modes (edit, enter, point). 'Point' and 'Enter' work similarly. Microsoft Excel Shortcut Keys. Cut, Edit Cut. Repeat, Edit Repeat. Undo, Edit Undo. Help, Help Contents and Index.
Hi Ward, As far as I know the only way you can refresh PivotTable by shortcut is to run a macro. Sub Macro1 ' ' Macro1 Macro ' ' ActiveSheet.PivotTables('PivotTable1').PivotCache.Refresh End Sub I recorded a macro and created a shortcut key for this macro. When I use Ctrl+Shift+R, I can refresh PivotTable automatically. Hope it's helpful. Regards, Emi Zhang TechNet Community Support Please mark the reply as an answer if you find it is helpful. If you have feedback for TechNet Support, contact. Hi WardWulf, Could you use other shortcut keys in Excel?
![Ctrl F2 In Excel Ctrl F2 In Excel](/uploads/1/2/5/4/125449998/677278996.png)
For example COPY(Ctrl+C) or PASTE(Ctrl+V). Then you can open the file in safe mode and check if these shortcut keys work fine. Press Win + R, type ' excel /safe' in the blank box, press Enter. If it works fine in safe mode, please check the add-ins in your excel and disable them. You also need to check if you have any macros in your Excel.
Go to Developer Tab select Macros and check the list in pop-up dialog box. Any updates and results please let me know.
Regards, Emi Zhang TechNet Community Support Please mark the reply as an answer if you find it is helpful. If you have feedback for TechNet Support, contact. Office 365 64 bit user on Windows 10 and same problem but with Word and Excel (all I use). I used to use shift + F7 for thesaurus in Word and magically quit working. I looked in customize keyboard shortcuts and it is correctly assigned.
F4 in Word and Excel is supposed to repeat last action, or it used to, and that quit working as well. Started in safe mode and same issue. Reinstalled Office 365 (didn't uninstall first though) and still the same problem. Extremely frustrating and time consuming on my part. I'm sure Microsoft is too busy with flashy new features to worry about some basic productivity issue like this. Somewhat unrelated but along the same lines of basic functionality: why does highlighting text in Word deselect it but any other formatting change doesn't?
Oddly inconsistent.