Audit Links
| Command Name | Key Stroke | Priority | Comments |
|---|---|---|---|
| Manage External Links | Ctrl Shift ? | 5 | Manage links for selected cells through the Linked |
| Edit External Link Source | Alt Shift E | 4 | Edit source of first linked item in selected cells |
| Unlink Selected Cells | Alt Shift U | 4 | Remove all links within selected cells |
| View External Link Source | Alt Shift V | 4 | View source of first linked item in selected cells |
Auditing
| Command Name | Key Stroke | Priority | Comments |
|---|---|---|---|
| Return To Audited Cell | Ctrl Shift | | 5 | Navigates to the last cell audited using Smart Pre |
| Smart Dependents | Ctrl Shift } | 5 | Traces and allows navigation through a cell’s depe |
| Smart Precedents | Ctrl Shift { | 5 | Traces and allows navigation through a cell’s prec |
| Find | ( Ctrl f ) / Alt ef | 4 | |
| Replace | ( Ctrl h ) / Alt ee | 4 | |
| Highlight Direct Cell Pre | ( Ctrl [ ) | 3 | |
| Highlight Direct Cell Dep | ( Ctrl ] ) | 3 | |
| Highlight Indirect Cell P | ( Ctrl { ) | 3 | |
| Highlight Indirect Cell D | ( Ctrl | 3 | |
| Show Precedent Arrows | Alt tut | 3 | Refers to direct precedents |
| Show Dependent Arrows | Alt tud | 3 | Refers to direct dependents |
| Display Cell Formulas (To | ( Ctrl ` ) | 3 | |
| Edit Links | Alt ek | 3 |
Auto Filling
| Command Name | Key Stroke | Priority | Comments |
|---|---|---|---|
| Smart Fill Dates | Ctrl Alt d | 4 | Fills in a series of dates by day, month or year a |
| Smart Fill Numbers | Ctrl Alt f | 4 | Fills in a series of numbers according to user pre |
Clear/Delete
| Command Name | Key Stroke | Priority | Comments |
|---|---|---|---|
| Delete Selection | Alt ed | 5 | |
| Clear Everything Within S | Alt eaa | 5 | |
| Edit Delete Sheet | Alt el | 3 |
Commands
| Command Name | Key Stroke | Priority | Comments |
|---|---|---|---|
| Edit Undo | ( Ctrl z ) / Alt eu | 5 | |
| Edit Redo (Reverse Undo) | ( Ctrl y ) / Alt er | 5 | |
| Repeat Last Command | F4 / ( Ctrl y ) / Al | 5 | Use F4 while outside Formula Bar |
Copy with Links
| Command Name | Key Stroke | Priority | Comments |
|---|---|---|---|
| Copy (FDS) | Ctrl Alt Shift C | 4 | Perform Excel Copy operation, preserving all link |
| Cut (FDS) | Ctrl Alt Shift X | 4 | Perform Excel Cut operation, preserving all link a |
| Paste (FDS) | Ctrl Alt Shift V | 4 | Perform Excel Paste operation, preserving all link |
| Fill Down (FDS) | Ctrl Alt Shift D | 3 | Perform Excel Fill Down operation, preserving all |
| Fill Left (FDS) | Ctrl Alt Shift J | 3 | Perform Excel Fill Left operation, preserving all |
| Fill Right (FDS) | Ctrl Alt Shift K | 3 | Perform Excel Fill Right operation, preserving all |
| Fill Up (FDS) | Ctrl Alt Shift U | 3 | Perform Excel Fill Up operation, preserving all li |
| Insert Copied Cells (FDS) | Ctrl Alt Shift I | 3 | Perform Excel Insert Copied Cells operation, prese |
| Move or Copy Sheet (FDS) | Ctrl Alt Shift S | 3 | Perform Excel Move or Copy Sheet operation, preser |
Copy/Paste
| Command Name | Key Stroke | Priority | Comments |
|---|---|---|---|
| Smart Copy Down | Ctrl Shift D | 5 | Copies a cell formula down intelligently according |
| Smart Copy Right | Ctrl Shift R | 5 | Copies a cell formula to the right intelligently a |
| Paste Special - Formulas | Alt esf Enter | 5 | Copies formulas and nothing else |
| Paste Special - Formats | Alt est Enter | 5 | Copies formats and nothing else |
| Paste Special - Values | Alt esv Enter | 5 | Copies values and nothing else |
| Copy Right (Excel) | ( Ctrl r ) | 5 | |
| Copy Down (Excel) | ( Ctrl d ) | 5 | |
| Smart Formula Column Spac | Ctrl Alt l | 4 | Copies a cell formula adjusting column spacing acc |
| Smart Formula Row Spacing | Ctrl Alt r | 4 | Copies a cell formula adjusting row spacing accord |
| Smart Formula Transpose | Ctrl Alt t | 4 | Copies a cell formula transposing references |
| Copy Value From Cell Abov | ( Ctrl Shift “ ) | 3 | |
| Copy Formula From Cell Ab | ( Ctrl ‘ ) | 3 |
Cut/Copy/Move/Paste/Insert
| Command Name | Key Stroke | Priority | Comments |
|---|---|---|---|
| Cut | ( Ctrl x ) / Alt et | 5 | |
| Copy | ( Ctrl c ) / Alt ec | 5 | |
| Paste | ( Ctrl v ) / Alt ep | 5 | |
| Insert (Copied) Cells | Alt ie | 5 | |
| Copy/Move Sheet | Alt em | 3 |
Export Data
| Command Name | Key Stroke | Priority | Comments |
|---|---|---|---|
| Export Chart to PPT as Pi | Alt Shift H | 3 | Export Chart to PowerPoint as picture |
| Export Chart to Word as P | Ctrl Alt Shift H | 3 | Export Chart to Word as picture |
| Export Table to PPT as Pi | Alt Shift B | 3 | Export to PowerPoint table as picture |
| Export Table to Word as P | Ctrl Alt Shift B | 3 | Export to Word table as picture |
| Export to PPT as MS Graph | Alt Shift M | 3 | Export Table to PowerPoint as MS Graph |
| Export to PPT as Text | Alt Shift L | 3 | Export to PowerPoint cell as text |
| Export to PPT as Word Tab | Alt Shift W | 3 | Export to PowerPoint as Word table |
| Export to Word as Tabbed | Ctrl Alt Shift A | 3 | Export Table to Word as Tabbed Table |
| Export to Word as Text | Ctrl Alt Shift L | 3 | Export to Word cell as text |
| Export to Word as Word Ta | Ctrl Alt Shift W | 3 | Export to Word as Word table |
FactSet Tools
| Command Name | Key Stroke | Priority | Comments |
|---|---|---|---|
| Data Downloading | Alt Shift N | 3 | Refresh All cells with ^= ^% code prefixes |
| Filings Wizard | Alt Shift Z | 3 | Download financial statements and notes |
| Insert ActiveGraph | Alt Shift G | 3 | Add refreshable ActiveGraphs to a model |
| Insert FactSet Formula | Alt Shift P | 3 | Build Data Downloading formulas that begin with ^= |
| Launch Factset | Alt Shift F | 3 | Launch FactSet |
| Refresh All =FDS | Alt Shift A | 3 | Refresh all cells that contain =FDS functions |
| Refresh Selected =FDS | Off | 3 | Refresh the currently selected cells that containi |
| Audit FactSet Code | Ctrl t | 1 | View components and source of FactSet code value |
File Optimization
| Command Name | Key Stroke | Priority | Comments |
|---|---|---|---|
| Clean Up Defined Names | Off | 3 | Removes unused defined range names from the active |
| Clean Up Number Formats | Off | 3 | Removes unused custom number formats from the acti |
| Clean Up Used Range | Off | 2 | Resets the used range of the selected worksheet to |
| Clean Up Used Ranges | Off | 2 | Resets the used range of each worksheet in the sel |
Files
| Command Name | Key Stroke | Priority | Comments |
|---|---|---|---|
| File New | ( Ctrl n ) / Alt fn | 5 | |
| File Open | ( Ctrl o ) / Alt fo | 5 | |
| File Close | Alt fc | 5 | |
| File Save | ( Ctrl s ) / Alt fs | 5 | |
| File Save As | F12 / Alt fa | 5 |
Formatting
| Command Name | Key Stroke | Priority | Comments |
|---|---|---|---|
| My Custom Table SmartCycl | Ctrl Alt 1 | 5 | Cycles through customizable table formatting style |
| My Custom Table SmartCycl | Ctrl Alt 2 | 5 | Cycles through customizable table formatting style |
| Table Formatting Wizard | Ctrl Alt Shift T | 5 | Applies a style or table style to the selected tab |
| Cell Formatting Dialog Bo | ( Ctrl 1 ) / Alt oe | 5 | |
| Apply FDS Paintbrush Styl | Ctrl Alt Shift P | 4 | Applies FactSet Paintbrush style to selected range |
| Capture FDS Paintbrush St | Ctrl Alt Shift Q | 4 | Captures formatting of selected cell as FactSet Pa |
| Decrease Table Size | Ctrl Alt Shift G | 4 | Proportionally decreases font, row, and column siz |
| Increase Table Size | Ctrl Alt Shift F | 4 | Proportionally increases font, row, and column siz |
| My Custom Table SmartCycl | Ctrl Alt 3 | 4 | Cycles through customizable table formatting style |
| My Custom Table SmartCycl | Ctrl Alt 4 | 4 | Cycles through customizable table formatting style |
| My Custom Table SmartCycl | Ctrl Alt 5 | 4 | Cycles through customizable table formatting style |
| Apply Sheet Style | Ctrl Alt y | 3 | Applies selected sheet style from user settings to |
| Cell Back Color SmartCycl | Alt Shift K | 3 | Cycles through customizable cell color styles |
| Column Header SmartCycle | Alt Shift @ | 3 | Cycles through customizable formatting styles |
| Decimal Aligned SmartCycl | Ctrl Alt Shift % | 3 | Cycles through customizable formatting styles |
| Font SmartCycle | Alt Shift ^ | 3 | Cycles through customizable formatting styles |
| Foreign Currency SmartCyc | Alt Shift $ | 3 | Cycles through customizable formatting styles |
| Hard Percent SmartCycle | Alt Shift % | 3 | Cycles through customizable formatting styles |
| Header SmartCycle | Alt Shift ! | 3 | Cycles through customizable formatting styles |
| Highlight SmartCycle | Alt Shift & | 3 | Cycles through customizable formatting styles |
| Label SmartCycle | Alt Shift # | 3 | Cycles through customizable formatting styles |
| My SmartCycle 1 | Alt Shift ( | 3 | Cycles through customizable formatting styles |
| My SmartCycle 2 | Alt Shift ) | 3 | Cycles through customizable formatting styles |
| My SmartCycle 3 | Ctrl Alt Shift ! | 3 | Cycles through customizable formatting styles |
| My SmartCycle 4 | Ctrl Alt Shift @ | 3 | Cycles through customizable formatting styles |
| My SmartCycle 5 | Ctrl Alt Shift # | 3 | Cycles through customizable formatting styles |
| Positive Multiple SmartCy | Alt Shift * | 3 | Cycles through customizable formatting styles |
| Right Aligned SmartCycle | Ctrl Alt Shift $ | 3 | Cycles through customizable formatting styles |
| Edit Clear Formats | Alt eaf | 3 | |
| Case SmartCycle | Alt Shift C | 2 | Cycles through CAPS, First Letter of Each Word Cap |
| Wrap Text | Ctrl Shift W | 1 | Toggles wrap text setting in selected cells |
Formatting - Alignment
| Command Name | Key Stroke | Priority | Comments |
|---|---|---|---|
| Center SmartCycle | Ctrl Shift C | 5 | Cycles through customizable centering styles |
| Horizontal Alignment Smar | Ctrl Shift H | 3 | Cycles through customizable horizontal alignment s |
| Indent SmartCycle | Ctrl Shift I | 3 | Cycles through customizable indentation levels |
| Right Indent SmartCycle | Alt Shift I | 3 | Cycles through customizable right-indentation leve |
| Vertical Alignment SmartC | Ctrl Shift V | 3 | Cycles through customizable vertical alignment sty |
Formatting - Borders
| Command Name | Key Stroke | Priority | Comments |
|---|---|---|---|
| Border SmartCycle | Ctrl Shift B | 3 | Cycles through customizable border styles |
| Border Outline | ( Ctrl Shift & ) | 3 | |
| Remove Borders | ( Ctrl Shift _ ) | 3 | |
| Border Bottom | Ctrl Alt Shift Down | 1 | Cycles through medium, thin and no border bottom f |
| Border Left | Ctrl Alt Shift Left | 1 | Cycles through medium, thin and no border left for |
| Border None | Ctrl Shift _ | 1 | Clears all border formatting from selected cells |
| Border Outline | Ctrl Shift & | 1 | Adds a solid border outline around selected range |
| Border Outline Light | Ctrl Shift ^ | 1 | Adds a light solid border outline around selected |
| Border Right | Ctrl Alt Shift Right | 1 | Cycles through medium, thin and no border right fo |
| Border Top | Ctrl Alt Shift Up Ar | 1 | Cycles through medium, thin and no border top for |
Formatting - Font
| Command Name | Key Stroke | Priority | Comments |
|---|---|---|---|
| AutoColor Selection | Ctrl Alt a | 5 | AutoColors the current selection according to Auto |
| Underline SmartCycle | Ctrl Shift U | 5 | Cycles through customizable underline styles |
| Bold | ( Ctrl b ) | 5 | |
| Italics | ( Ctrl i ) | 5 | |
| Underline | ( Ctrl u ) | 5 | |
| AutoColor Colors | Ctrl Alt e | 4 | Cycles through customizable font colors |
| AutoColor Sheet | Ctrl Alt s | 4 | AutoColors an entire spreadsheet at once according |
| AutoColor Workbook | Ctrl Alt q | 4 | AutoColors an entire workbook at once according to |
| Blue Black SmartCycle | Ctrl ; | 4 | Cycles through customizable font colors |
| No AutoColor | Ctrl Alt z | 4 | Cycles through customizable font colors |
| Decrease Font Size | Ctrl Shift G | 3 | Decreases font size of selected range (to uniform |
| FDSD Color SmartCycle | Ctrl ‘ | 3 | Cycles through customizable font colors |
| Increase Font Size | Ctrl Shift F | 3 | Increases font size of selected range (to uniform |
| FDST Color SmartCycle | Ctrl Alt 0 | 2 | Cycles through customizable font colors |
| Strikethrough | ( Ctrl 5 ) | 1 |
Formatting - Number Format
| Command Name | Key Stroke | Priority | Comments |
|---|---|---|---|
| Currency SmartCycle | Ctrl Shift $ | 5 | Cycles through customizable currency styles |
| Date SmartCycle | Ctrl Shift @ | 5 | Cycles through customizable date styles |
| Decrease Decimal | Ctrl . | 5 | Decreases number of decimal places in number forma |
| Increase Decimal | Ctrl , | 5 | Increases number of decimal places in number forma |
| Multiple SmartCycle | Ctrl Shift * | 5 | Cycles through customizable multiple styles (e.g.- |
| Percent SmartCycle | Ctrl Shift % | 5 | Cycles through customizable percent styles |
| General Number SmartCycle | Ctrl Shift ! | 4 | Cycles through customizable general number format |
| Binary Number SmartCycle | Ctrl Shift Y | 3 | Cycles through customizable binary number format s |
Formatting - Rows/Columns
| Command Name | Key Stroke | Priority | Comments |
|---|---|---|---|
| Column Autofit | Alt oca | 5 | |
| Column Width | Alt ocw | 4 | |
| Row Height | Alt ort | 4 | |
| Auto Column Width | Ctrl Alt Shift Page | 3 | Automatically adjusts column width of selected col |
| Auto Row Height | Alt Shift Page Down | 3 | Automatically adjusts row height of selected row(s |
| Column Width SmartCycle | Ctrl Alt Shift Page | 3 | Cycles through customizable column widths |
| Copy Row/Column Info | Ctrl Alt j | 3 | Captures row and column information (size, hidden |
| Paste Row/Column Info | Ctrl Alt k | 3 | Applies previously captured row and column informa |
| Row Height SmartCycle | Alt Shift Page Up | 3 | Cycles through customizable row heights |
| Row Autofit | Alt ora | 2 | |
| Column Standard Width | Alt ocs | 1 |
Formulas
| Command Name | Key Stroke | Priority | Comments |
|---|---|---|---|
| Enter/Exit Cell Formula B | F2 | 5 | You can use Esc to exit Formula Bar as well |
| Absolute/Relative Referen | F4 | 5 | Use F4 while in Formula Bar |
| Sum Formula | Alt = | 5 | |
| Insert Function (Function | Shift F3 | 5 | |
| Finish Entry | Enter | 5 | Moves selection depending on Excel user preference |
| Finish Entry and Move Rig | Tab | 5 | |
| Finish Entry and Move Lef | Shift Tab | 5 | |
| Copy Exact Formulas | Ctrl Alt , | 4 | Captures exact formulas from selected range for pa |
| Create Formula w/ Externa | Off | 4 | Initiate direct creation of an Excel formula conta |
| Paste Exact Formulas | Ctrl Alt . | 4 | Pastes previously captured formulas to selected ra |
| Calculate Formulas | F9 | 4 | |
| Check for Errors | Ctrl Shift E | 3 | Inserts/removes formula adjustment to replace erro |
| Leader Dots | Ctrl l | 3 | Inserts/removes leader dots after text in selected |
| Shift Decimal Left | Alt Shift < | 3 | Shifts decimal point one position to the left in s |
| Shift Decimal Right | Alt Shift > | 3 | Shifts decimal point one position to the right in |
| Sum Bar | Ctrl Shift S | 3 | Inserts/removes sum bars in selected cells |
| New Line in Cell Entry | Alt Enter | 3 | Use while in Formula Bar |
| Delete Remainder of Entry | ( Ctrl Delete ) | 3 | Use while in Formula Bar |
| Fill Selection With Entry | Ctrl Enter | 3 | |
| Insert Defined Name in Fo | F3 | 2 | |
| Insert Function Arguments | Ctrl Shift A | 1 |
Hiding
| Command Name | Key Stroke | Priority | Comments |
|---|---|---|---|
| Smart Hide | Ctrl Alt h | 4 | Automatically replaces hidden rows and columns wit |
| Collapse Column Levels | Ctrl Alt Shift _ | 3 | Collapses all column outline levels |
| Collapse Row Levels | Alt Shift _ | 3 | Collapses all row outline levels |
| Expand Column Levels | Ctrl Alt Shift + | 3 | Expands all column outline levels |
| Expand Row Levels | Alt Shift + | 3 | Expands all row outline levels |
| Group Rows/Columns | ( Alt Shift Right Ar | 3 | |
| Ungroup Rows/Columns | ( Alt Shift Left Arr | 3 | |
| Hide Rows | ( Ctrl 9 ) | 3 | |
| Hide Columns | ( Ctrl 0 ) | 3 | |
| Unhide Rows | ( Ctrl Shift 9 ) | 3 | |
| Unhide Columns | ( Ctrl Shift 0 ) | 3 | |
| Group Columns | Alt Shift Down Arrow | 2 | Groups selected columns |
| Group Rows | Alt Shift Right Arro | 2 | Groups selected rows |
| Hide Column | Ctrl Alt Shift Home | 2 | Hides selected columns |
| Hide Row | Alt Shift Home | 2 | Hides selected rows |
| Ungroup Columns | Alt Shift Up Arrow | 2 | Ungroups selected columns |
| Ungroup Rows | Alt Shift Left Arrow | 2 | Ungroups selected rows |
| Unhide Column | Ctrl Alt Shift End | 2 | Unhides selected columns |
| Unhide Row | Alt Shift End | 2 | Unhides selected rows |
Insert New
| Command Name | Key Stroke | Priority | Comments |
|---|---|---|---|
| Insert Row | Alt ir | 5 | |
| Insert Column | Alt ic | 5 | |
| Insert Worksheet | Alt iw / Shift F11 | 3 | |
| Insert Chart Sheet | F11 | 1 |
Insert/Delete
| Command Name | Key Stroke | Priority | Comments |
|---|---|---|---|
| Adjust Columns | Ctrl Shift Insert | 3 | Inserts, deletes, or formats columns in bulk at sp |
| Adjust Rows | Ctrl Alt Insert | 3 | Inserts, deletes, or formats rows in bulk at speci |
| Delete Column | Ctrl Alt Shift Delet | 3 | Deletes selected column(s) |
| Delete Row | Alt Shift Delete | 3 | Deletes selected row(s) |
| Insert Column | Ctrl Alt Shift Inser | 3 | Inserts column(s) to the left of selected range |
| Insert Row | Alt Shift Insert | 3 | Inserts row(s) above selected range |
Navigation
| Command Name | Key Stroke | Priority | Comments |
|---|---|---|---|
| Add Bookmark | Ctrl Alt b | 5 | Adds a bookmark to the selected range |
| Clear Bookmarks | Ctrl Alt x | 5 | Clears all bookmarks |
| Next Bookmark | Ctrl Alt n | 5 | Navigates to the next bookmark in sequence |
| Previous Bookmark | Ctrl Alt p | 5 | Navigates to the previous bookmark in sequence |
| Move Up | Up Arrow | 5 | |
| Move Down | Down Arrow | 5 | |
| Move Left | Left Arrow | 5 | |
| Move Right | Right Arrow | 5 | |
| Quick Move Up | Ctrl Up Arrow | 5 | |
| Quick Move Down | Ctrl Down Arrow | 5 | |
| Quick Move Left | Ctrl Left Arrow | 5 | |
| Quick Move Right | Ctrl Right Arrow | 5 | |
| Page Up | Page Up | 5 | |
| Page Down | Page Down | 5 | |
| Next Worksheet | ( Ctrl Page Down ) | 5 | |
| Previous Worksheet | ( Ctrl Page Up ) | 5 | |
| Next Workbook | Ctrl Tab / Ctrl F6 | 5 | |
| Previous Workbook | Ctrl Shift Tab / Ctr | 5 | |
| Go To… | F5 / ( Ctrl g ) / Al | 5 | |
| First Worksheet | Ctrl Alt Home | 3 | Jumps to first worksheet of the active workbook |
| Last Worksheet | Ctrl Alt End | 3 | Jumps to last worksheet of the active workbook |
| Move To Column A | Home | 3 | |
| Move To Last Used Column | End, Enter | 3 | |
| Move To Cell A1 | ( Ctrl Home ) | 3 | |
| Move To Bottom Right Cell | ( Ctrl End ) | 3 | |
| Page Left | Alt Page Up | 3 | |
| Page Right | Alt Page Down | 3 | |
| Move Down Within Selectio | Enter | 3 | |
| Move Up Within Selection | Shift Enter | 3 | |
| Move Left Within Selectio | Tab | 3 | |
| Move Right Within Selecti | Shift Tab | 3 | |
| Next Worksheet Loop | Ctrl Alt Page Down | 2 | Allows looping while paging down through the works |
| Previous Worksheet Loop | Ctrl Alt Page Up | 2 | Allows looping while paging up through the workshe |
| Move Clockwise Within Sel | ( Ctrl . ) | 1 | |
| Next Region Within Select | Ctrl Alt Right Arrow | 1 | |
| Previous Region Within Se | Ctrl Alt Left Arrow | 1 |
Other
| Command Name | Key Stroke | Priority | Comments |
|---|---|---|---|
| Insert Name (Define) | Alt ind / Ctrl F3 | 5 | |
| Activate/Deactivate Menu | F10 / Alt | 5 | Use arrows or menu accelerators to move through me |
| Help | F1 | 5 | |
| Tools Options | Alt to | 4 | |
| Show Right Click Menu | Shift F10 | 4 | |
| Insert Comment | Alt im / Shift F2 | 3 | Use Shift F2 to edit comments as well |
| Edit Clear Comments | Alt eam | 3 | |
| Insert Current Date | ( Ctrl ; ) | 3 | |
| Insert Current Time | ( Ctrl Shift : ) | 3 | |
| Spelling Check | F7 | 3 | |
| Next Toolbar | Ctrl Tab | 3 | |
| Previous Toolbar | Shift F10 | 3 | |
| Run Macro | Alt F8 | 3 | |
| Help (Context Sensitive) | Shift F1 | 3 | |
| Insert Hyperlink | ( Ctrl k ) / Alt ii | 2 | |
| Show/Hide Standard Toolba | Ctrl 7 | 1 | |
| Visual Basic Editor (Togg | Alt F11 | 1 |
Printing
| Command Name | Key Stroke | Priority | Comments |
|---|---|---|---|
| File Print | ( Ctrl p ) / Alt fp | 5 | |
| File Set Print Area | Alt fts | 5 | |
| Insert Page Break | Alt ib | 5 | |
| File Clear Print Area | Alt ftc | 5 | |
| File Page Setup | Alt fu | 5 | |
| File Print Preview | Alt fv | 5 | Use Esc to exit print preview mode |
Selecting
| Command Name | Key Stroke | Priority | Comments |
|---|---|---|---|
| Highlight Up | Shift Up Arrow | 5 | |
| Highlight Down | Shift Down Arrow | 5 | |
| Highlight Left | Shift Left Arrow | 5 | |
| Highlight Right | Shift Right Arrow | 5 | |
| Quick Highlight Up | Ctrl Shift Up Arrow | 5 | |
| Quick Highlight Down | Ctrl Shift Down Arro | 5 | |
| Quick Highlight Left | Ctrl Shift Left Arro | 5 | |
| Quick Highlight Right | Ctrl Shift Right Arr | 5 | |
| Select Row | Shift Spacebar | 5 | |
| Select Column | Ctrl Spacebar | 5 | |
| Select All (Entire Worksh | ( Ctrl a ) / Ctrl Sh | 3 | |
| Set/Clear Selection Ancho | F8 | 3 | |
| Select To Column A | Shift Home | 1 | |
| Select To Last Used Colum | End, Shift Enter | 1 | |
| Select To Cell A1 | ( Ctrl Shift Home ) | 1 | |
| Select To Bottom Right Ce | ( Ctrl Shift End ) / | 1 | |
| Extend Selection Page Up | Shift Page Up | 1 | |
| Extend Selection Page Dow | Shift Page Down | 1 | |
| Extend Selection Page Lef | Shift Alt Page Up | 1 | |
| Extend Selection Page Rig | Shift Alt Page Down | 1 | |
| Select Region Around Acti | ( Ctrl Shift * ) | 1 | |
| Only Select Active Cell | Shift Backspace | 1 |
Sidebar
| Command Name | Key Stroke | Priority | Comments |
|---|---|---|---|
| Show/Hide Sidebar | Ctrl m | 1 | Show or hide the FactSet Sidebar |
| Sidebar Edit | Alt Shift T | 1 | Show the FactSet Sidebar Edit tab |
| Sidebar swap focus | Ctrl j | 1 | Swap focus between Sidebar and its host applicatio |
View
| Command Name | Key Stroke | Priority | Comments |
|---|---|---|---|
| Window Freeze/Unfreeze | Alt wf | 5 | |
| Window Split | Alt ws | 5 | |
| View Zoom | Alt vz | 4 | |
| Gridlines | Ctrl Alt g | 3 | Toggles gridlines on active worksheet |
| Split Window Toggle | F6 | 3 | |
| View Page Breaks | Alt vp | 3 | |
| View Normal | Alt vn | 3 | |
| Decrease Zoom | Ctrl Alt - | 2 | Decreases view zoom magnification by specified inc |
| Increase Zoom | Ctrl Alt = | 2 | Increases view zoom magnification by specified inc |
Windows
| Command Name | Key Stroke | Priority | Comments |
|---|---|---|---|
| Next Application | Alt Tab | 5 | |
| Previous Application | Alt Shift Tab | 5 | |
| Windows Start Menu | Ctrl Esc | 5 | |
| Close Window | Ctrl F4 / ( Ctrl w ) | 4 | |
| Close Application | Alt F4 | 4 | |
| Training Window Size | Ctrl Alt o | 3 | Resizes Excel window to and from size which allows |
| Window SmartCycle | Ctrl Alt w | 3 | Cycles through an array of Excel window sizes and |
| Restore Window Size | Ctrl F5 | 3 | |
| Minimize Window | Ctrl F9 | 3 | |
| Maximize Window | Ctrl F10 | 3 | |
| Maximize Window | Ctrl Alt m | 1 | Maximizes Excel window |