Search

Community

General discussion

Gravatar
Locked

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.

0 total posts (Page 1 of 1)  
+ Follow this Discussion ·
| Thread display: Collapse - | Expand +

All Comments

Back to Community Forum
0 total posts (Page 1 of 1)  

Start or search

Related Discussions

Related Forums