Tuesday, 27 May 2014

Basic Excel - Auto Fill

Auto fill is when Excel automatically fills selected cells with data





1. Type Apple into cell A1
 
 
 
2. Move the mouse curser to the right hand corner of the cell. The curser will change from a chunky white cross to a thin black cross



3. Hold down the left mouse button and drag the cell down. Apples will appear in a white box as you are dragging the cell down.



4. Once you reach the bottom of cell B2 release the left mouse button. Apples will now be in both cell A1 and A2

This you tube clip will show you how to use auto fill for months and dates
 
 

No comments:

Post a Comment