keyboard shortcutsmacosmicrosoft excelmicrosoft-excel-2016
I recently updated to Excel 2016 from Excel 2011 for mac, and I'm missing a very important feature which saved me a lot of time: custom keyboard shortcuts, i.e. being able to create new shortcuts for commands, or edit existing shortcuts.
I have googled for this and searched the support site for this and haven't found anything yet.
What surprises me most is that this feature would exist in Word (see here) and not in Excel.
Has anyone found a solution or workaround?
Use raw queries. For flagged or unread mails:
(com_microsoft_outlook_flagged = 1) || (com_microsoft_outlook_unread = 1)
Important note: Do not use this folder with the "mark as read immediately" option, as seen here:
This results in a continuous mark as read -- remove from view -- show next message -- mark as read cycle, until everything is marked as read and you have no idea what you've now missed. Instead, I've switched to the 2nd option displayed that marks as read when you select a different message.
yes it available you add it using the below steps.
Do a search on the site you want to add a quicksearch to.
Bookmark the page you are brought to (the results page).
Open the Properties dialog for your new bookmark.
In your bookmark’s URL (the Location field), find and replace what you searched for with %s (If it does not appear, you cannot use a quicksearch here)
Add a keyword
it will work like a charm when you search with the keyword in latest firefox also.
Hope this helps.
Best Answer
For now, at least, you need to do this with the OS X System Preferences -> Keyboard -> Shortcuts feature. This only works for commands that are available on the application's menus.
I was able to create shortcuts this way for my two most frequent functions, Insert Rows and Delete Rows. The menu item for Insert Rows is called "Rows". It's on the Insert Menu, but you just enter "Rows" in the shortcut. The menu item for Delete is Delete in the Edit menu, so just enter "Delete". This isn't the same as "Delete Rows", which is not available on the menu so I need to select a row with Shift-Space before deleting it.
I'm hopeful they will restore this feature in the future.