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...
ABCFGHMOPSVWXYZAAABACAD
1
availableNameKeyRocketBoostMacabacusFactsetSpreadsheettopiaTTS Turbo MacrosCIQSmartShorcutsBloomberg?AbleBitsASAP UtilitiesPower Pak v7WSTWallstreet PrepbpmToolbox
2
coming soonLite / Pro(Dealmaven)(Simple Shortcuts)
3
not availableWebsitehttp://www.veodin.com/keyrockethttp://wspanalytics.com/http://macabacus.com/www.factset.com/websitefiles/PDFs/brochures/officetoolshttp://www.spreadsheetopia.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$29$199Free / $10/month$29$75$40$660 AUDfree (open source)
5
(white) not filledOSWinWinWinWinWin/MacWinWin
6
CategorySub-CategoryFeature /ShortcutShortcutShortcutShortcutShortcutShortcutShortcutShortcutShortcutShortcut
7
Excel 2013yesno
8
Excel 2010yesyesyesyes
9
Excel 2007yesyesyesyes
10
Excel 2003noyesyesyes
11
Shorctus can be customizedyesyesyesnoyes
12
... for all other Excel functionsyesnononononononono
13
Proscustom shortcut every button$60 with source code
14
other applications
15
Consno advanced macros
16
17
Total Shortcuts43851036522175333
18
Exclusive Shortcuts7
19
Filter
20
Clear FilterAlt+Shift+L
21
Sorting
22
Sort AscendingAlt+Shift+Arrow-Down
23
Sort DescendingAlt+Shift+Arrow-Up
24
Highlight Duplicates(custom) ???
25
NAVIGATION
26
Sheets
27
Insert SheetShift+F11Shift+F11Shift+F11Shift+F11Shift+F11Shift+F11Shift+F11Shift+F11Shift+F11
28
Delete SheetCtrl+Shift+F11
29
Rename SheetCtrl+Shift+F2
30
Move/Copy Sheet(custom) ???
31
Move Sheet Up
32
Move Sheet Down
33
POWER TOOLS
34
Auditing
35
Trace PrecedentsCtrl+Alt+[Ctrl+Shift+[Ctrl+Alt+[Ctrl+Alt+[Ctrl+Shift+T Ctrl+Shift+]
36
Trace DependentsCtrl+Alt+]Ctrl+Shift+]Ctrl+Alt+]Ctrl+Alt+]Ctrl+Shift+[
37
Clear ArrowsCtrl+Alt+\Ctrl+Alt+\
38
Last Audited CellCtrl+Shift+\Ctrl+Shift+|Ctrl+Shift+|
39
Smart PrecedentsCtrl+Shift+{
40
Smart DependentsCtrl+Shift+}
41
Modeling
42
Power Fill RightCtrl+Shift+RCtrl+Shift+RCtrl+Shift+R
43
Power Fill DownCtrl+Shift+DCtrl+Shift+DCtrl+Shift+D
44
Smart Formula TransposeCtrl+Alt+T
45
Smart Formula Row SpacingCtrl+Alt+R
46
Smart Formula Column SpacingCtrl+Alt+L
47
Copy Cell Down(custom)Ctrl+Shift+D
48
Copy Cell Left(custom)Ctrl+Alt+L
49
Copy Cell Right(custom)Ctrl+Shift+R
50
Copy Cell Up(custom)Ctrl+Alt+U
51
Formulas
52
Error WrapCtrl+Shift+ECtrl+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 DetailCtrl+Alt+Arrow-Left
67
Show DetailCtrl+Alt+Arrow-Right
68
Previous Worksheet LoopCtrl+Alt+PageUpCtrl+Alt+PageUp
69
Next Worksheet LoopCtrl+Alt+PageDownCtrl+Alt+PageDown
70
First WorksheetCtrl+Alt+HomeCtrl+Alt+HomeCtrl+Alt+HomeCtrl+Alt+Home
71
Last WorksheetCtrl+Alt+EndCtrl+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+NCtrl+Alt+N
76
Previous BookmarkCtrl+Alt+PCtrl+Alt+PCtrl+Alt+P
77
First BookmarkCtrl+Alt+F
78
Clear BookmarksCtrl+Alt+XCtrl+Alt+X
79
Add BookmarkCtrl+Alt+WCtrl+Alt+BCtrl+Alt+B
80
Remove BookmarkCtrl+Alt+X
81
Comments
82
Fix Selected Comments(custom)(custom)
83
Delete Comment(custom)Ctrl+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 ToggleCtrl+Alt+GAlt+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 PageBreaks(custom)Ctrl+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 DatesCtrl+Alt+D
99
Smart Fill NumbersCtrl+Alt+F
100
FORMATTING
Loading...
 
 
 
Sheet1