Skip to main content
Documentation
Documentation
Workday User Guide
Last Updated: 2023-06-23
Reference: Array Formula Keyboard Shortcuts

Reference: Array Formula Keyboard Shortcuts

Use these keyboard shortcuts for array formulas in Worksheets:
Keyboard Shortcut
Description
Ctrl+Alt+Enter or Ctrl+Alt+Shift+Enter (Windows)
Command+Option+Enter (Mac)
Use for unconstrained array formulas.
To place results for a formula in all applicable cells, select a single cell and submit the formula using the shortcut.
If the workbook doesn't include enough empty cells to display the complete results, an error occurs.
Use the keyboard shortcut to submit changes that you make in a pivot table formula. A pivot table is an example of an unconstrained array formula because it can shrink or grow depending on the underlying data.
Example:
  1. Select cell A1.
  2. In the formula bar, type
    ={1,2;3,4}
    .
  3. Press Ctrl+Alt+Enter (Windows) or Command+Option+Enter (Mac).
Workday shows these 4 values in 2 rows and 2 columns:
1    2
3    4
You can't edit individual cells in the results range.
Ctrl+Shift+Enter (Windows)
Command+Shift+Enter (Mac)
Use for constrained array formulas. This shortcut is the same in Worksheets and Excel.
Select a range of cells, then submit the formula using the shortcut.
Workday displays results only in the selected range.
Don't use this shortcut when you're working with Workday live data, entry area data, or an array with an undefined or unknown size. Use the shortcut for unconstrained arrays instead.
When you select more cells than necessary, Workday displays an #N/A error in the extra cells. When you don't select enough cells to display the complete results, the remaining results don't display.
Example:
  1. Select cells A1-B3.
  2. In the formula bar, type
    ={1,2;3,4}
  3. Press Ctrl+Shift+Enter (Windows) or Command+Shift+Enter (Mac).
Workday shows these values in 3 rows and 2 columns:
1    2
3    4
#N/A   #N/A
Workday displays the #N/A error because you selected more cells than the number of results.
You can't edit individual cells in the range.
Ctrl+Enter (Windows)
Command+Enter (Mac)
You can't use the Ctrl+Enter keyboard shortcut in entry areas.
This shortcut is the same in Worksheets and Excel.
Technically the shortcut isn't an array formula shortcut; it's similar to a paste: it places the same formula or data into a range of cells. Unlike array formulas, using Ctrl+Enter doesn't prevent you from editing individual cells in the range.
Example:
  1. Select cells A1-B3.
  2. In the formula bar, type
    ={1,2;3,4}
    .
  3. Press Ctrl+Enter (Windows) or Command+Enter (Mac).
Workday shows these 6 values in 3 rows and 2 columns:
1    1
1    1
1    1

This content is not part of the Workday Administrator Guide.