Viruses Explained What are Trojans? What are Worms? What are Rootkits? Free AntiVirus Latest Virus Threats Top 10 Anti Virus Malware Tutorials
Spyware Explained Malware Tutorials Free Anti Spyware Manual Tips
FREE Anti Virus FREE Anti Spyware FREE Online Scanners Definition Updates Manual Updates BootUp Anti Virus Portable Protection Rootkit Removal Top Security Tips
HTML Tutorial WORD Tutorial EXCEL Tutorial Computer Beginners Windows Registry Top Security Tips Malware Tutorials
Web Templates Word Templates Word Processing

Home Page
Free Anti Virus
Free Anti Spyware
Free Online Scanners
Free USB Anti Virus
Bootable Anti Virus
Rootkit Removal
Latest Virus Threats
Viruses Explained
Spyware Explained
Windows Registry
Top 10 Antivirus
Manual Updates
Definition Updates
Malware Tutorials

Computer Basics
HTML Tutorials
Free Web Templates
Word Tutorials
Excel Tutorials

CV Creation
Free CV Templates
Free CV Examples

   IP: 54.81.120.254

Excel Basics   AutoSum   Formulas   AutoFill  

Excel Auto Fill:

The Fill Handle (auto fill) is an Excel utility to anticipate what the next cell may need e.g. if you type Monday into one cell and use the Fill Handle it will fill in the rest of the days of the week into the adjoining cells.

The Fill Handle is the small black box on the bottom left of a highlighted cell, see image below.



Float the pointer onto the small black box on the highlighted cell. Once its over the small black box it will change into a black cross. See below that you must wait for the cross to change into the small black cross before you can use the Fill Handle.



As an example lets do the days of the week. Start off by typing Monday into the top left cell A1. The cell must be highlighted to see the small black box. Float the pointer onto this small black box. When you see the cross change to the black cross, drag the cross across the cells like below.

This utility will also increment numbers and dates so feel free to experiment. A much more powerful use of Auto Fill is to use it with formulas; see further on in the lesson.



If you do not understand formulas go to them in the link above. If you see below there is a formula in cell B6 that adds the numbers in the B column.



As above for the days of the week, when you see the little black box as in the image above you can drag the Auto Fill across under the colums C,D,E and F. This will Auto Fill the formula Appropriate to thoes columns.



Below is the result; this is a very powerful utility and can be used in many ways.