Entering and Revising Data

• Enter data by clicking on a cell and typing a value
• You can use AutoFill to enter data and copy and paste it easier instead of going one by one
• Fill Series is letting you enter two values in a series and use the fill handle to extend your series in the worksheet
• You have control over how Excel extends the values
• You can hold down the control key while you drag the fill handle
• Autocomplete detects a value you're entering is similar to that of the previous
• Pick from Dropdown List lets you choose a value from existing values in a column
• Ctrl and enter allows you to enter a value in more than one cell simultaneoulsy
• Copy Cells
• Fill Series
• Fill Formatting Only
• Fill Without Formatting