Training in the Tropics
  • Home
  • About
  • Courses
  • Testimonials
  • Contact
  • Gallery
  • Resume Writing Service
  • Computer Tips
  • Subscribe

Computer Tips

Microsoft EXCEL - Fill Handle

8/7/2015

0 Comments

 
Picture
Instead of entering data manually on a worksheet, you can use the Auto Fill feature to fill cells with data that follows a pattern or that is based on data in other cells.  You can also copy formulas from adjacent cells to save reentering the same formula into several cells.

To do this, position mouse cursor on bottom right corner of cell you wish to copy or begin a pattern.  Once you have the bold plus symbol, left mouse click and drag down to the cells you wish data or formula to be inputted in.  You can also double click rather than drag down - data entry will stop once an empty cell is located.

In the above example drag the fill handle down from each cell reference to create a series as shown below.
Picture
See how column A simply copied the numeral 1 down.  To count 1 2 3 4 etc. Input 2 in cell A2 then select both A1 and A2, then move the mouse cursor to corner of cell A2 to get the fill handle, then drag down.  Excel will then input 3 into A3, 4 into A4 etc. 

Alternatively,  you can fill the active cell with the contents of an adjacent cell by selecting an empty cell that is below, to the right, above, or to the left of the cell that contains the data that you want to use to fill the empty cell. Then on the Home tab, in the Editing group, click Fill, and then click Down, Right, Up, or Left.



0 Comments



Leave a Reply.

    Author

    Julie Goleby is the Director of Training in the Tropics

    Archives

    August 2018
    March 2017
    May 2016
    February 2016
    November 2015
    October 2015
    August 2015
    May 2015

    Categories

    All
    Captions
    Graphics
    Images
    Microsoft
    Photographs
    Pictures

    RSS Feed

We are passionate about helping you improve your skills and knowledge!  


Hours

M-F: 9am - 5pm

Telephone

0428 411 050

Email

office@traininginthetropics.com
POSTAL

PO Box 1702, ATHERTON QLD 4883
  • Home
  • About
  • Courses
  • Testimonials
  • Contact
  • Gallery
  • Resume Writing Service
  • Computer Tips
  • Subscribe