|
Leading the way in Microsoft Office Development |
| Home | | | Excel | | | Word | | | PowerPoint | | | Consultancy | | | Feedback | | | Contact |
| Microsoft Excel > AutoFill | < Previous | Next > |
Basic |
| Expand | - | Getting Started |
| Step By Step | - | AutoFill Options Smart Tag |
| Step By Step | - | Copy Cells |
| Step By Step | - | Copying Formulas |
| Step By Step | - | Copying Dates |
| Step By Step | - | Fill Series |
| Step By Step | - | Fill Formatting |
Advanced |
| More Details | - | Linear and Growth Trends |
| More Details | - | Numbered List |
| More Details | - | Custom Lists |
| More Details | - | Advanced Techniques |
| More Details | - | Office Online |
| More Details | - | Knowledge Base |
Shortcut Keys |
(Ctrl + D) - Copies the first cell in the selection downwards (Edit > Fill > Down). | ||
(Ctrl + R) - Copies the leftmost cell in the selection to the right (Edit > Fill > Right). | ||
(Ctrl + ' ) - Enters the formula from the cell directly above into the active cell. | ||
(Ctrl + " ) - Enters the value from the cell directly above into the active cell. |
Tools > Options |
(Edit tab, Allow Cell Drag and Drop) - Lets you drag cells and use the AutoFill feature. | ||
(Edit tab, Show Paste Options button) - Displays the AutoFill Smart tag. |
Related Topics |
| GoTo | - | Cells & Ranges |
| GoTo | - | Data Validation |
| Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved. | Top |