Press Alt, then D, then T sequentially to open the Data Table dialog, leave the Row input cell blank, and enter W4 into the Column input cell—Excel will automatically generate the {=TABLE(,W4)} array formula for you without needing to press Ctrl + Shift + Enter.
