| SHORTCUT | FUNCTION |
| File options | |
| Ctrl+N | Create a new worksheet |
| Ctrl+O | Open an existing worksheet |
| Ctrl+F4 | Close the current worksheet |
| Ctrl+S | Save the current worksheet |
| Ctrl+P | Print the current worksheet |
| Ctrl+Enter | Edit project template settings |
| Ctrl+M | Edit project notes |
| Worksheet options | |
| Alt+Enter | Edit Worksheet properties: title, customize column settings, page header and footer setup and price adjustments |
| Ctrl+Shift+L | Add a worksheet link to the Worksheet |
| Ctrl+U | Updates all or selected items against the Manufacturer or Custom Catalog. |
| Ctrl+D | Opens the Discount dialog box. |
| Home options | |
| Ctrl+X | Cut selected or if nothing is selected, the current item |
| Ctr+C | Copy selected or if nothing is selected, the current item |
| Ctrl+V | Paste the last item(s) that was cut or copied |
| Ctrl+Z, Alt+Backspace | Undo an action. The drop down allows multiple steps to be undone at one time |
| Ctrl+Y, Ctrl+Backspace | Redo an undone action. The drop down allows multiple steps to be redone at one time |
| Ctrl+F | Find any string in the worksheet |
| Ctrl+R | Replace an existing value with a new one |
| Ctrl+A | Selects all items in the Worksheet. |
| Esc | Deselects all items in the Worksheet. |
| Tools option | |
| F10 | Edit Worksheet Preferences |
| Help option | |
| F1 | Open the 2020 Worksheet Help file |
| View options | |
| Ctrl+Alt+V | Turns Full Screen View on and off. |
| Ctrl+Alt+P | Clicking this button turns the product lines on or off. Clicking-holding this button opens a flyout menu which additional view options. |
| Ctrl+Alt+O | Turns the options on or off. |
| Ctrl+Alt+A | Turns the attributes on or off in a worksheet |
| Ctrl+Alt+L | Turns the worksheet links on or off in a worksheet |
| Ctrl+Alt+S | Turns the Standards on or off in a worksheet |
| Ctrl+Alt+T | Turns the outline levels on or off in a worksheet |
| Ctrl+Alt+B | Turns the price adjustments on or off in a worksheet |
| Ctrl+Alt+U | Turns the subtotals on or off in a worksheet |
| Item options | |
| Ctrl+Shift+P | Add a product line to the Worksheet. Click and hold the button to open a flyout menu which contains all other insert options explained below. |
| Ctrl+Shift+O | Add an option line to the current Worksheet item |
| Ctrl+Shift+A | Add an attribute to the current Worksheet item |
| Ctrl+Shift+T | Add an outline level to the Worksheet |
| Ctrl+Shift+S | Add a Standard to the Worksheet |
| Ctrl+Shift+D | Add a price adjustment to the Worksheet |
| Ctrl+Shift+U | Add a subtotal to the Worksheet |
| Ctrl+Shift+Del | Delete the current row |
| Ctrl+Shift+Up Arrow | Move the current item up in the Worksheet |
| Ctrl+Shift+Down Arrow | Move the current item down in the Worksheet |
| Ctrl+Alt+Enter | View all the details of the current item |
| F8 | Add finishes in 2020 Options |
| F9 | Open Content tab to the location of the current item |
