How to Get Infinite (Unlimited) Keyboard Shortcuts in Excel

Well, not infinite, but, you get the idea. Microsoft limits you to CTRL + letter and CTRL + SHIFT + letter. Give up the CTRL + s and n for save and new and you have a lot less. Did I miss o for open? 😊

So?

Here's a video that does a walkthrough.

In words : 

1. Create a Personal Macro Workbook that contains your utilities. Above linked video gives you a walkthrough. Concisely : if you don't even have one, then create a dummy macro using the macro recorder, then find out where it's saved and overwrite it with the one you get from someone, or just add your code to it manually.
2. With a PERSONAL.xlsb in place, in the Microsoft Excel Objects section, edit the ThisWorkbook module and add code along the lines of :

Private Sub Workbook_Open()

    Application.OnKey "^+{]}", "PERSONAL.XLSB!startCrossHair" 

    Application.OnKey "^+{[}", "PERSONAL.XLSB!stopCrossHair" 

End Sub

And that's it! Did people who "know" tell you you could never get a shortcut like CTRL SHIFT ] (right box bracket)

Which are my favorites? (Most frequently used highlighted)

#	Shortcut	Function
1	CTRL H	Return "Home" (If one of the first two worksheets is called (any of) home,toc,contents,readme or index, make it the Active Sheet)
2	CTRL ALT T	Create a table of contents (If one already exists, update it) (Handy for starting with a big Workbook inherited from someone else - let's you navigate with links rather than just the tabs on the bottom row :)
3	CTRL SHIFT X	If active cell is in a table, then create a new sheet with that cell's entire row data displayed in an easy to read format, with a CLOSE button. Try it out!  (New sheet is called Legend) (Very handy for very wide tables with lots of data..(Thanks Shubh and Kopal Kaushik))
4	CTRL ALT G	Toggle the grid
5	CTRL SHIFT H	by default this is "Hide current row". I remap this to "Toggle active cell fill (Yellow)" (use Application.OnKey to remap reliably..)
6	CTRL SHIFT C	Create a copy of the active sheet in the same workbook
7	CTRL ALT N	Open a *copy* of the active sheet as a new Book - so you can hack at will
8	CTRL SHIFT ]	Enter "Highlight row and column of active cell" mode (with a confirm dialog when custom highlighting detected on the sheet)              (aka CrossHair) Useful for presentations
9	CTRL SHIFT [	Exit "Highlight row and column of active cell" mode (Sebastian Bulz)
10	CTRL SHIFT F	Filter table (if already filtered using another column, then add to the filtering) by only showing (of the currently visible rows) only those for which this column's entry matches the active cell's value. This, along with CTRL ALT C (unfilter current column) is one way of getting the filter buttons to show, if they are not currently visible
11	CTRL SHIFT N	Set filter to the next value in this column's element list
12	CTRL SHIFT B	Set filter to previous value in this column's element list
13	CTRL SHIFT E	Exclude filter (add to Table's existing filter) - of the visible rows, filter out (don't show) rows for which this column's entry matches active cell's value
14	CTRL ALT F	Clear the Table's filter (and dismiss the filter drop-down buttons)
15	CTRL ALT C	Clear filter from this column (of active cell) only
16	CTRL SHIFT A	Re-arrange the rows of the table by sorting this column in ascending order - very useful to have a "serial number" column since you can then use that column to sort and return the table to original state anytime
17	CTRL SHIFT D	Re-arrange the rows of the table by sorting this column in descending order
18	CTRL ALT SHIFT DEL	Delete active sheet without confirmation!
19	CTRL Right Arrow	Move column (of active cell) right (aka swap its position it with its right neighbor)
20	CTRL Left Arrow	Move column to the left (aka swap its position with its left neighbor)
21	CTRL -	(native, not custom)
22	CTRL T	Add a copy of the current row of the Table immediately above
23	CTRL SHIFT T	Add a copy of the current row of the Table above the first non-blank row of the table (i.e., at the top)
24	CTRL SHIFT V	Fill the column with a serial numbers, in ascending (top-most is lowest) order (it's always useful to have a serial-number column o that you can always send the table back to its original state after re-arranging based on other columns
25	CTRL SHIFT W	Fill the column with serial numbers in descending order. This is not a bad idea - you can see how many rows you have at a glance :)
26	CTRL SHIFT >	Enter row-only highlight mode (Sebastian Bulz)
27	CTRL SHIFT <	Exit row-only highlight mode (Sebastian Bulz)
28	CTRL J	Center stage - you have a frozen section at the left that you want always visible. Get the columns of the selected cells adjacent to that section by hiding the intervening columns (and vice versa - so this one toggles it). Very handy for analysis of data. Thanks Khurram Mukhtar
29	ALT SHIFT D	Delete row of active cell

https://www.quora.com/What-are-the-most-useful-shortcuts-for-Microsoft-Excel/answer/Ananth-Chellappa?__nsrc__=4&__snid3__=12318854975