Discussion Locked
Alternate method to for filling cells
0 helpful
0 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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.