logo ASAP Utilities

The ASAP Utilities menu in Excel (English)

Excel with ASAP Utilities in its menu

Reapply CSE (Ctrl+Shift+Enter) Array Formulas

ASAP Utilities  › Formulas  ›  8. Reapply CSE (Ctrl+Shift+Enter) Array Formulas

This tool re-enters all formulas in your selected cells as CSE (Control+Shift+Enter) array formulas. In Excel versions before dynamic arrays (Excel 2010-2016 and most of 2019), array formulas had to be confirmed by pressing Control+Shift+Enter. These are known as CSE array formulas.
If entered correctly, Excel displays the formula in curly braces, like:
{=A1:A3*B1:B3} If you forget to press Control+Shift+Enter, Excel may treat the formula as a regular one, which can lead to errors or incorrect results. Starting with Excel 365 in 2018, Excel introduced dynamic array formulas. These no longer require Control+Shift+Enter and automatically spill results into adjacent cells.
However, Excel still supports traditional CSE formulas for compatibility with older files. Manually reapplying CSE to many formulas can be time-consuming.
This tool automates the process by re-entering all formulas in your selection using Control+Shift+Enter. Note: The tool does not detect which formulas need to be array formulas. It simply re-enters all formulas in your selection as CSE formulas.

Starting this tool


Formulas  ›  8 Reapply CSE (Ctrl+Shift+Enter) Array Formulas
Additional keywords for this tool:
Reenter array formula, Fix array formulas, Convert formula to array formula, Add curly braces to Excel formula, Automate Ctrl+Shift+Enter in Excel, Convert regular formula to array formula, Batch apply Ctrl+Shift+Enter, Reapply CSE array formulas, Array formula not calculating, Dynamic vs legacy array formula, Rebuild array formulas, Convert formulas to CSE format

Choose your language preference below

English (us)NederlandsDeutschEspañolFrançaisPortuguês do BrasilItalianoРусский中文(简体)日本語

Download
Replace Named Ranges in Formulas with Cell References




Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us


🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.