Excel 2016 Shortcut Keys
Excel 2016 Shortcut Keys - Download as PDF File (.pdf), Text File (.txt) or read online. Excel 2016 Shortcut Keys. Search Search. Close suggestions. Saved.Excel 2016 Shortcuts Platform: Windows/English [Ctrl]+[Enter] Complete cell entry and don't move selection Format Cells [Ctrl]+['] Duplicate value from Cell. Function keys. F1 alone: displays the Excel Help task pane. Ctrl+F1: displays or hides the ribbon. Alt+F1: creates an embedded chart of the data in the current range. Alt+Shift+F1: inserts a new worksheet.
I have just installed excel 2016 on my computer for work. I am processing a fairly average data set. However, I am finding the keyboard shortcuts much slower than in Excel 2013.
For example, when I use 'ALT-A-T' to create filters, the workbook takes 3-5 seconds to process. Alternatively, when I simply press the button in the ribbon, the workbook responds instantly.
I already turned off cursor animations in the OPTIONS > ADVANCED > GENERAL settings. Is there any other way to turn off whatever extraneous activity is happening in the background?
Thanks!Lisa
1 Answer
If you're using shortcuts that visually go through the ribbon, turn off animations for all of office 2016 -
create the following key in the registry if it does not exist yet: HKEY_CURRENT_USERSoftwareMicrosoftOffice16.0CommonGraphics
create a new DWORD DisableAnimations in that key and set its value to 1
It went from 15.0 to 16.0