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
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAE
1
availableNameKeyRocketArixcel ExplorerBoostMacabacusMacabacusMacabacusMacabacusMacabacusFactsetFactsetSpreadsheettopiaTTS Turbo MacrosTTS Turbo MacrosTTS Turbo MacrosCIQCIQCIQSmartShorcutsBloomberg?AbleBitsASAP UtilitiesPower Pak v7WSTWallstreet PrepbpmToolbox
2
coming soonLite / Pro(Dealmaven)(Simple Shortcuts)
3
not availableWebsitehttp://www.veodin.com/keyrockethttp://www.arixcel.comhttp://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$7.50$199Free / $10/month$29$75$40$660 AUDfree (open source)
5
(white) not filledOSWinWinWinWinWinWin/MacWinWin
6
Excel 2010Feature /ShortcutManipulateView/NavigateShortcutShortcutShortcutShortcutFeatureCategoryUtilityDescriptionShortcutDescriptionShortcutShortcutFeatureDescriptionShortcutFeatureDescriptionShortcutShortcut
7
Excel 2007Excel 2013yesyesno
8
yesyesyesyesyes
9
yesyesyesyesyes
10
Excel 2003nonoyesyesyes
11
Shorctus can be customizedyesyesyesyesnoyes
12
... for all other Excel functionsyesnonononononononononononononononono
13
Proscustom shortcut every button$60 with source code
14
other applications
15
Consno advanced macros
16
17
Total Shortcuts433851036522175333
18
Exclusive Shortcuts7
19
Filter
20
Clear FilterShiftAltAlt+Shift+L
21
Sorting
22
Sort AscendingShiftAltAlt+Shift+Arrow-Down
23
Sort DescendingShiftAltAlt+Shift+Arrow-Up
24
Highlight Duplicates(custom) ???
25
NAVIGATION
26
Sheets
27
Insert SheetShiftShift+F11Shift+F11Shift+F11Shift+F11Shift+F11Shift+F11Shift+F11Shift+F11Shift+F11
28
Delete SheetShiftCtrl+Shift+F11
29
Rename SheetShiftCtrl+Shift+F2
30
Move/Copy Sheet(custom) ???
31
Move Sheet Up
32
Move Sheet Down
33
POWER TOOLS
34
Auditing
35
Trace PrecedentsAltCtrl+Alt+[Ctrl+QCtrl+Shift+[Ctrl+Alt+[Show All PrecedentsAUDITING5Similar to Excel's native Show Precedents tool, but can show precedents for multiple cells at onceCtrl+Alt+[Ctrl+Shift+T Precedent Tracer Traces cell's precedentsCtrl+Shift+]Trace DependentsCycle through the direct dependents of the highlighted cell
36
Trace DependentsAltCtrl+Alt+]Ctrl+Shift+QCtrl+Shift+]Ctrl+Alt+]Show All DependentsAUDITING5Similar to Excel's native Show Dependents tool, but can show dependents for multiple cells at onceCtrl+Alt+]Ctrl+Shift+[Trace PrecedentsCycle through the direct precedents of the highlighted cell
37
Clear ArrowsAltCtrl+Alt+\Ctrl+Alt+\Clear Arrow-sAUDITING4Clear trace Arrow-s from the active worksheet
38
Last Audited CellAltCtrl+Shift+\Ctrl+Shift+|Last Audited CellAUDITING3Return to the cell last audited using Smart Precedents/DependentsCtrl+Shift+|
39
Smart PrecedentsAltCtrl+Shift+{Smart PrecedentsAUDITING5Show all cells that are inputs to the selected cell
40
Smart DependentsAltCtrl+Shift+}Smart DependentsAUDITING5Show all cells whose computation is a function of the current cell
41
Modeling
42
Power Fill RightShiftCtrl+Shift+RCtrl+Shift+RSmart Copy RightMODELING5Copy a cell formula to the right cells right intelligently according to user preferencesCtrl+Shift+R
43
Power Fill DownShiftCtrl+Shift+DCtrl+Shift+DSmart Copy DownMODELING5Copy a cell formula down cells right intelligently according to user preferencesCtrl+Shift+D
44
Smart Formula TransposeShiftCtrl+Alt+TSmart Formula Transpose
45
Smart Formula Row SpacingShiftCtrl+Alt+RSmart Formula Row Spacing
46
Smart Formula Column SpacingShiftCtrl+Alt+LSmart Formula Column Spacing
47
Copy Cell DownShift(custom)Ctrl+Shift+DCopy cells down a range based on adjacent populated cells
48
Copy Cell LeftShift(custom)Ctrl+Alt+LCopy cells across a range based on adjacent populated cells
49
Copy Cell RightShift(custom)Ctrl+Shift+RCopy cells across a range based on adjacent populated cells
50
Copy Cell UpShift(custom)Ctrl+Alt+UCopy cells up a range based on adjacent populated cells
51
Formulas
52
Error WrapShiftCtrl+Shift+ECtrl+Shift+EError WrapMODELING5Adjust formulas to replace errors from existing formulas with custom error messages or valuesCtrl+Shift+ECtrl+Shift+EWrap IF ISERRORConvert invalid formula displays to selected message
53
Wrap IF ZeroShiftCtrl+Shift+EndConvert formulas with Zero result to selected message
54
Anchor FormulaShiftCtrl+F3MODELING4Modify formulas to use relative or absolute cell references
55
Paste
56
Paste Exact FormulasAltCtrl+Alt+ECtrl+Alt+EPaste ExactCOPY & PASTE5Paste copied cells exactly as they are, preserving original formulas
57
Paste Exact TransposeAltCtrl+Alt+TCtrl+Alt+TPaste TransposeCOPY & PASTE4Transpose paste copied cells as links, number formats, or exact formulas
58
Paste InsertAltCtrl+Alt+IPaste InsertCOPY & PASTE5Paste cells after inserting the required rows/columns to accomodate the cells
59
Paste LinksAltCtrl+Alt+LPaste LinksCOPY & PASTE5Paste links to copied cells and apply AutoColor settings to the pasted range
60
Paste Number FormatsAltCtrl+Alt+FPaste Number FormatsCOPY & PASTE5Paste number formats only
61
Paste Special 1ShiftAltCtrl+Alt+Shift+1Paste Special 1Pastes using the specified Paste Special format.
62
Paste Special 2ShiftAltCtrl+Alt+Shift+2Paste Special 2Pastes using the specified Paste Special format.
63
Paste Special 3ShiftAltCtrl+Alt+Shift+3Paste Special 3Pastes using the specified Paste Special format.
64
Paste Special 4ShiftAltCtrl+Alt+Shift+4Paste Special 4Pastes using the specified Paste Special format.
65
Navigation
66
Hide DetailAltCtrl+Alt+Arrow-Left
67
Show DetailAltCtrl+Alt+Arrow-Right
68
Previous Worksheet LoopAltCtrl+Alt+PageUpCtrl+Alt+PageUpPrevious Worksheet LoopNAVIGATION2Loop through sheets backward without stopping when the first sheet is reached
69
Next Worksheet LoopAltCtrl+Alt+PageDownCtrl+Alt+PageDownNext Worksheet LoopNAVIGATION4Go to the first worksheet in the active workbook
70
First WorksheetAltCtrl+Alt+HomeCtrl+Alt+HomeFirst WorksheetNAVIGATION4Go to the last worksheet in the active workbookCtrl+Alt+HomeCtrl+Alt+HomeGo to First WorksheetMove user to the first worksheet in the current workbook
71
Last WorksheetAltCtrl+Alt+EndCtrl+Alt+EndLast WorksheetCtrl+Alt+EndCtrl+Alt+EndGo to Last WorksheetMove user to the last worksheet in the current workbook
72
Select All WorksheetsAltCtrl+Alt+Arrow-UpSelect All WorksheetsSelect all worksheets in the current workbook
73
Goto MaxAltCtrl+Alt+Shift+.Ctrl+Alt+Shift+.Go To MinNAVIGATION2Go to the cell with the minimum value in a selected range
74
Goto MinAltCtrl+Alt+Shift+,Ctrl+Alt+Shift+,Go To MaxNAVIGATION2Go to the cell with the maximum value in a selected range
75
Next BookmarkAltCtrl+Alt+NNext WatchNAVIGATION3Navigate to the next watch in sequenceCtrl+Alt+NCtrl+Alt+NNext BookmarkJump to the next bookmark in the current workbook
76
Previous BookmarkAltCtrl+Alt+PPrevious WatchNAVIGATION3Navigate to the previous watch in sequenceCtrl+Alt+PCtrl+Alt+PPrevious BookmarkJump to the previous bookmark in the current workbook
77
First BookmarkAltCtrl+Alt+FFirst BookmarkJump to the first bookmark in the current workbook
78
Clear BookmarksAltCtrl+Alt+XCtrl+Alt+XClear BookmarksClear all bookmarks in active workbook
79
Add BookmarkAltCtrl+Alt+WAdd WatchNAVIGATION2Add a watch to the selected rangeCtrl+Alt+BCtrl+Alt+BAdd BookmarkAdd a bookmark to the current location
80
Remove BookmarkCtrl+Alt+XRemove WatchNAVIGATION2Remove watch from the selected range
81
Comments
82
Fix Selected CommentsShift(custom)(custom)Ctrl+Alt+Shift+X3Restore selected comment(s) to default position and resize to fit contentFix Comment
83
Delete CommentShift(custom)Ctrl+Alt+Shift+DDelete CommentUTILITIES & OTHERDelete cell comments from selected cells. When multiple worksheets are selected, all comments on those sheets will be deleted
84
Fix All CommentsShift(custom)
85
Delete Empty CommentsShift(custom)
86
Delete All CommentsShift(custom)
87
UTILITIES & OTHER
88
Quick SaveShiftCtrl+Shift+SQuick SaveUTILITIES & OTHER5Quickly save a workbook without recalculating, regardless of calculation settings
89
Gridlines ToggleAltCtrl+Alt+GAlt+Shift+GCtrl+Alt+GToggle GridlinesVIEW3Toggle gridlines on/off for the active worksheetAlt+Shift+GToggle GridlinesToggle gridlines on and off
90
Disable F1Ctrl+Shift+1 Disable F1 Key Turns F1 on / off
91
Disable Nuisance Keys Toggle(custom)
92
Fit to PowerPoint ShapeShiftCtrl+Alt+Shift+FFit to PowerPoint ShapeResizes chart to selected PowerPoint shape’s dimensions
93
Copy With LinkShiftCtrl+Alt+CCopy With LinkCopies the selected cell(s) or chart to paste in PowerPoint. The image will be linked to Excel for updating.
94
Hide PageBreaksAlt(custom)Ctrl+Alt+BHide PageBreaksVIEW3Hide Pagebreaks
95
Clean Up Number FormatsShiftCtrl+Alt+Shift+OClean Up Number FormatsUTILITIES & OTHER4Remove unused custom number formats from the active workbook
96
Clean Up Defined NamesShiftCtrl+Alt+Shift+NClean Up Defined NamesUTILITIES & OTHER4Remove unused defined names from the active workbook
97
Clean Up Used RangesShiftCtrl+Alt+Shift+RClean Up Used RangesUTILITIES & OTHER4Reset used ranges of worksheets in active workbook to the area bound by bottom-right-most data
98
Smart Fill DatesShiftCtrl+Alt+DSmart Fill Dates
99
Smart Fill NumbersShiftCtrl+Alt+FSmart Fill Numbers
100
FORMATTING
Loading...
 
 
 
Sheet1