SHIFT + CTRL + Enter enters an array formula in Excel, which is required for formulas that return multiple results or perform calculations on arrays of data. General, Number, and Date formats are accessed through different shortcuts. Array formulas allow powerful calculations across multiple cells.