Community

In large spreadsheets will use keystokes instead of the Fill Handle to quickly copy a function or formula. Here are the steps as applied to the Zip+four example:
1. Move cursor one column to the left.
2. Press "Ctrl+Down Arrow" to move to the bottom of the spreadsheet.
3. Move cursor one column the the right(back to the last cell in the blank column.
4. Press "Ctrl+Shift+Up Arrow" to Highlight the entire coulmn.
5. Press "Crtl+D" to copy the formula down the entire column.