Request: Excel equivalent of Google Spreadsheet ARRAYFORMULA + CONTINUE functionality
All you have to do is exactly what you did, except before you enter the formula in excel, select the entire range, A1 through A4. Then type the formula in and hit [ctrl][shift][enter].