Excel Modeling Tool Comparison
Comments
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Still loading...
ABCGHPSVWXYZAAABACAD
1
availableNameBoostMacabacusTTS Turbo MacrosCIQSmartShorcutsBloomberg?AbleBitsASAP UtilitiesPower Pak v7WSTWallstreet PrepbpmToolbox
2
coming soonLite / Pro(Simple Shortcuts)
3
not availableWebsitehttp://wspanalytics.com/http://macabacus.com/https://www.ttsuniversity.com/Product.aspx?c=books&n=excel_best_practicehttps://www.capitaliq.com/home/what-we-offer/how-you-can-get-it/office-plug-ins/excel-plug-in.aspxhttp://www.smartshortcuts.com/AbleBits.comhttp://www.asap-utilities.comhttp://spreadsheetpage.com/http://www.bestpracticemodelling.com/http://xltoolbox.sourceforge.net/
4
Excel standardPrice$199Free / $10/month$75$40$660 AUDfree (open source)
5
(white) not filledOSWinWinWinWin
6
CategorySub-CategoryFeature /ShortcutShortcutShortcutShortcutShortcutShortcutShortcut
7
Excel 2013no
8
Excel 2010yesyesyes
9
Excel 2007yesyesyes
10
Excel 2003yesyesyes
11
Shorctus can be customizedyesyesyes
12
... for all other Excel functionsnononononono
13
Pros$60 with source code
14
15
Cons
16
17
Total Shortcuts85103175333
18
Exclusive Shortcuts
19
Filter
20
Clear Filter
21
Sorting
22
Sort Ascending
23
Sort Descending
24
Highlight Duplicates
25
NAVIGATION
26
Sheets
27
Insert SheetShift+F11Shift+F11Shift+F11Shift+F11Shift+F11Shift+F11
28
Delete Sheet
29
Rename Sheet
30
Move/Copy Sheet
31
Move Sheet Up
32
Move Sheet Down
33
POWER TOOLS
34
Auditing
35
Trace PrecedentsCtrl+Shift+[Ctrl+Alt+[Ctrl+Shift+T Ctrl+Shift+]
36
Trace DependentsCtrl+Shift+]Ctrl+Alt+]Ctrl+Shift+[
37
Clear ArrowsCtrl+Alt+\
38
Last Audited CellCtrl+Shift+\Ctrl+Shift+|
39
Smart PrecedentsCtrl+Shift+{
40
Smart DependentsCtrl+Shift+}
41
Modeling
42
Power Fill RightCtrl+Shift+RCtrl+Shift+R
43
Power Fill DownCtrl+Shift+DCtrl+Shift+D
44
Smart Formula Transpose
45
Smart Formula Row Spacing
46
Smart Formula Column Spacing
47
Copy Cell DownCtrl+Shift+D
48
Copy Cell LeftCtrl+Alt+L
49
Copy Cell RightCtrl+Shift+R
50
Copy Cell UpCtrl+Alt+U
51
Formulas
52
Error WrapCtrl+Shift+ECtrl+Shift+ECtrl+Shift+E
53
Wrap IF ZeroCtrl+Shift+End
54
Anchor FormulaCtrl+F3
55
Paste
56
Paste Exact FormulasCtrl+Alt+ECtrl+Alt+E
57
Paste Exact TransposeCtrl+Alt+TCtrl+Alt+T
58
Paste InsertCtrl+Alt+I
59
Paste LinksCtrl+Alt+L
60
Paste Number FormatsCtrl+Alt+F
61
Paste Special 1Ctrl+Alt+Shift+1
62
Paste Special 2Ctrl+Alt+Shift+2
63
Paste Special 3Ctrl+Alt+Shift+3
64
Paste Special 4Ctrl+Alt+Shift+4
65
Navigation
66
Hide Detail
67
Show Detail
68
Previous Worksheet LoopCtrl+Alt+PageUpCtrl+Alt+PageUp
69
Next Worksheet LoopCtrl+Alt+PageDownCtrl+Alt+PageDown
70
First WorksheetCtrl+Alt+HomeCtrl+Alt+HomeCtrl+Alt+Home
71
Last WorksheetCtrl+Alt+EndCtrl+Alt+EndCtrl+Alt+End
72
Select All WorksheetsCtrl+Alt+Arrow-Up
73
Goto MaxCtrl+Alt+Shift+.Ctrl+Alt+Shift+.
74
Goto MinCtrl+Alt+Shift+,Ctrl+Alt+Shift+,
75
Next BookmarkCtrl+Alt+NCtrl+Alt+N
76
Previous BookmarkCtrl+Alt+PCtrl+Alt+P
77
First BookmarkCtrl+Alt+F
78
Clear BookmarksCtrl+Alt+X
79
Add BookmarkCtrl+Alt+WCtrl+Alt+B
80
Remove BookmarkCtrl+Alt+X
81
Comments
82
Fix Selected Comments(custom)
83
Delete CommentCtrl+Alt+Shift+D
84
Fix All Comments(custom)
85
Delete Empty Comments(custom)
86
Delete All Comments(custom)
87
UTILITIES & OTHER
88
Quick SaveCtrl+Shift+S
89
Gridlines ToggleAlt+Shift+GCtrl+Alt+GAlt+Shift+G
90
Disable F1Ctrl+Shift+1
91
Disable Nuisance Keys Toggle(custom)
92
Fit to PowerPoint ShapeCtrl+Alt+Shift+F
93
Copy With LinkCtrl+Alt+C
94
Hide PageBreaksCtrl+Alt+B
95
Clean Up Number FormatsCtrl+Alt+Shift+O
96
Clean Up Defined NamesCtrl+Alt+Shift+N
97
Clean Up Used RangesCtrl+Alt+Shift+R
98
Smart Fill Dates
99
Smart Fill Numbers
100
FORMATTING
Loading...
 
 
 
Sheet1