General discussion


Alternate method to for filling cells

By bfankha ·
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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Related Discussions

Related Forums