• When converting an array formula to a single-cell formula, you can select the top-left cell or the entire array.

• When converting a single-cell formula to an array formula, the array formula is automatically sized correctly, or you can preselect the cells you would like to be included in the array.

• Location: Context Menu

• Keyboard shortcut: Ctrl-Shift-A

• Icon: Checked / Unchecked