Following shortcuts are quite useful for Excel (only English language pack). If German language pack differs, you can find it in the next section of this article.
|Inserting new worksheet.||Shift + F11|
|Display a list of all OLE Objects / ActiveX Objects in the right of the application window.||Alt + F10|
|Deleting selecetd worksheets.||Alt + E + L|
Removing line breaks from Excel cells. Open the find and replace dialog of Excel and place the cursor in the search field.
After putting in Ctrl. + J you will see a little blinking dot in the search field.
Ctrl. + J
to enter a line break in the search dialog.
|Calling find and replace dialog.||Ctrl. + H|
|Open Data Validation Dropdown or Autofilter Dropdown in cell.||Alt. + Arrow Down|
|Apply AutoFilter.||Alt. + A + T|
|Remove AutoFilter.||Alt. + A + T|
|Jump to beginning or end of data area.||Ctrl. + Arrow (Down, Up, Left, Right)|
|Insert a new pivot table (just select one cell in a Range with data before executing the shortcut)||Alt. + N + V|
|Make table from current selection (just select one cell in a Range with data before executing the shortcut)||Alt. + N + T|
|Open the Import text wizard / dialog.||Alt. + A + E|
Following shortcuts are quite useful for Excel (only German language pack).
Some of these commands are really annoying. I am thinking of getting the English version as an extra language pack for Windows 7. Microsoft should keep shortcuts consistent accross all locales and not change it depending on the language settings.
|Deleting selected worksheets.||Alt + R + Ö + S|