Chapter 6 replace data

Chapter 6 Summary

• To insert data in the simplest form is to click the cell and type a value.
• It is not that handy for long sequences or series values.
• Auto Fill first element is recognized and use the fill handle until it extends far enough.
• Fill Series you can use the first two values and use the fill handle to extend the series.
• Auto Complete type the first few letters in a cell and if there is a value it suggests it.
• Copy cells
• You have some control over the series you can move it to the left or up
• Excel extends the previous values, Also use ctrl button to drag a series
• Auto Complete detects if a value you are entering is similar to previously entered values
• Ctrl and enter enters multiple value simultaneously
• There is a auto fill options to format cells