-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathshortcut-list
More file actions
66 lines (65 loc) · 6.11 KB
/
Copy pathshortcut-list
File metadata and controls
66 lines (65 loc) · 6.11 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
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)
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 :)
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))
CTRL ALT G : Toggle the grid
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..)
CTRL SHIFT C : Create a copy of the active sheet in the same workbook
CTRL ALT N : Open a *copy* of the active sheet as a new Book - so you can hack at will
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
CTRL SHIFT [ : Exit "Highlight row and column of active cell" mode (Sebastian Bulz)
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
CTRL SHIFT N : Set filter to the next value in this column's element list
CTRL SHIFT B : Set filter to previous value in this column's element list
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
CTRL ALT F : Clear the Table's filter (and dismiss the filter drop-down buttons)
CTRL ALT C : Clear filter from this column (of active cell) only
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
CTRL SHIFT D : Re-arrange the rows of the table by sorting this column in descending order
CTRL ALT SHIFT DEL : Delete active sheet without confirmation!
CTRL Right Arrow : Move column (of active cell) right (aka swap its position it with its right neighbor)
CTRL Left Arrow : Move column to the left (aka swap its position with its left neighbor)
CTRL - : (native, not custom) : Delete selection (row or cell or column) (- = “minus”)
CTRL T : Add a copy of the current row of the Table immediately above
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)
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
so that you can always send the table back to its original state after re-arranging based on other columns
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 :)
CTRL ALT A : Re-arrange table in "correct" order using the serial number column. This is why I always add a serial number column to anything I get from anyone - then I can sort at will knowing that I can always get back to initial state
CTRL SHIFT > : Enter row-only highlight mode (Sebastian Bulz)
CTRL SHIFT < : Exit row-only highlight mode (Sebastian Bulz)
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
CTRL ALT E : Go to end of block (go down this column to the first cell that differs from current cell)
CTRL ALT S : Go to start of block (go up this column to the first cell that differs from current cell)
CTRL ALT H : Filter the table to show the rows where any cell has highlighting that differs from the other cells in the row
CTRL ALT SHIFT H : Filter the table to show the rows such that cells in this column (of active cell) have highlighting differing from other cells in their row
CTRL ALT ShIFT S : Launch the save filter form (you have a filter applied to the table and want to save it)
CTRL ALT SHIFT V : View the saved filters
CTRL ALT SHIFT F : Apply the default filter from the saved filter list
CTRL ] : Increase font in current cell
CTRL [ : Decrease font in current cell
ALT UpArrow : Increment (date or number in current cell)
ALT DnArrow : Decrement (data or number in current cell)
CTRL ALT SHIFT N : Toggle format of numeric cells in the selection : if engineering format (Eg. 100k) change to regular (100000), and vice versa
CTRL ALT D : Fill in the blanks if you have (in a column, A,,,B,,F,,,,,C,, then you get A,A,A,B,B,F,F,F,F,F,C,C
CTRL ALT W : Create digital timing diagram using cell borders (Thank you Daniel Jazbec)
CTRL ALT SHIFT BkSpc : Delete the hidden rows from the table (with confirmation pop-up)
ALT SHIFT D : Delete row of active cell
Accomplished by this code in the PERSONAL.XLSB's "ThisWorkbook" (access with ALT-F11)
Private Sub Workbook_Open()
Application.OnKey "^+{]}", "PERSONAL.XLSB!startCrossHair" ' start :)
Application.OnKey "^+{[}", "PERSONAL.XLSB!stopCrossHair" ' stop highlighting
Application.OnKey "^{RIGHT}", "PERSONAL.XLSB!MoveColumnToRight"
Application.OnKey "^{LEFT}", "PERSONAL.XLSB!MoveColumnToLeft"
Application.OnKey "^%f", "PERSONAL.XLSB!clear_filter"
Application.OnKey "^%n", "PERSONAL.XLSB!CopyToNew" ' ActiveSheet.Copy
Application.OnKey "^%c", "PERSONAL.XLSB!Clear_Current_Col_Filter" ' CTRL+ALT+C
Application.OnKey "^%g", "PERSONAL.XLSB!Toggle_Grid" ' CTRL+ALT+G
Application.OnKey "^%+{DEL}", "PERSONAL.XLSB!DeleteThis" 'CTRL+ALT+SHIFT+DEL
End Sub