The table below lists the common commands of the XLL+ Function Wizard.
Command | Description | Shortcut | Menu | |
---|---|---|---|---|
OK/Save & Exit | Save changes and close the wizard. | Enter | File | |
Cancel | Abandon changes and close the wizard. | Escape | ||
New Function | Create a new function. | Ctrl+N | File | |
New Macro | Create a new macro add-in function. | File | ||
Select Function | Select a function from the active document. | File | ||
Show Advanced Properties | Show or hide advanced properties. | View | ||
Preview Function Wizard | Display a preview of the Excel Formula Wizard. | View | ||
Undo | Undo the last change. | Ctrl+Z | Edit | |
Cut | Cut the selected text to the clipboard. | Ctrl+X | Edit | |
Copy | Copy the selected text to the clipboard. | Ctrl+C | Edit | |
Paste | Paste text from the clipboard to the field currently being edited. | Ctrl+V | Edit | |
Delete | Delete the selected text. | Delete | Edit | |
Cut Argument | Cut the selected argument to the clipboard. | Argument | ||
Copy Argument | Copy the selected argument to the clipboard. | Argument | ||
Paste Argument | Paste a new argument from the clipboard. | Argument | ||
Add Argument | Add a new argument to the function. | Ctrl+I | Argument | |
Argument Details | Edit all the properties of the selected argument. | Alt+Enter | Argument | |
Delete Argument | Delete the selected argument. | Argument | ||
Move Argument Up | Move the selected argument to an earlier position in the list. | |||
Move Argument Down | Move the selected argument to a later position in the list. | |||
Scalar | Set the selected argument to be a single value. | Ctrl+0 | Argument | |
Vector | Set the selected argument to be a one-dimensional array of values. | Ctrl+1 | Argument | |
Matrix | Sets the selected argument to be a two-dimensional array. | Ctrl+2 | Argument | |
Refresh Preview Template | Reload template file and regenerate the preview. | Tools |