Download
excel fill and fill series n.
Skip this Video
Loading SlideShow in 5 Seconds..
Excel: Fill and Fill Series PowerPoint Presentation
Download Presentation
Excel: Fill and Fill Series

Excel: Fill and Fill Series

154 Vues Download Presentation
Télécharger la présentation

Excel: Fill and Fill Series

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Excel: Fill and Fill Series Computer Information Technology Section 6-10 • Some text and examples used with permission from: • http://www.jegsworks.com • Note: We are not endorsing or promoting religious doctrine, but simply taking advantage of this website for educational purposes.

  2. Objectives • The student will: • Understand how to use the fill handle • Understand how fill works on the following: • Values • Formulas • Series

  3. Excel: Fill • Fill is a way to: • copy data to other cells in the row or column • continue a pattern for data  • To use AutoFill, you just select a cell or cells and drag the fill handle in the bottom right corner of the selection across the cells you want to fill.

  4. Excel: Fill Results • If you fill from a cell that has a number or just text in it: • The result will be that number or word copied to all the cells or repeated:

  5. Excel: Fill Results • If the original cell has a formula in it: • Then the result will be the formula pasted in the cells (with references updated!):

  6. Excel: Fill Results • Excel recognizes days of the week and months and will Autofill those:

  7. Excel: Fill Results • Excel will also try and figure out if you want it to complete a series for you:

  8. Excel: Fill • Summary: • Fill is a quick and easy way to copy cells across columns or down the rows. • The results of the fill depend on the source cells

  9. Rest of Today • Do Homework 6-10. • Do Mavis Beacon.