0
   

Fill Handle

 
 
gollum
 
Reply Fri 13 May, 2016 08:47 am
Where do I find the Fill Handle to use to enable me to fill adjacent cells with the same number in another cell?
  • Topic Stats
  • Top Replies
  • Link to this Topic
Type: Question • Score: 0 • Views: 1,878 • Replies: 5
No top replies

 
Tes yeux noirs
 
  2  
Reply Fri 13 May, 2016 10:33 am
Bottom right corner of a selected cell or area.
Tes yeux noirs
 
  1  
Reply Fri 13 May, 2016 10:56 am
1. Select the cell(s) containing the content you want to use. The fill handle will appear as a small square in the bottom-right corner of the selected cell(s).
http://content.gcflearnfree.org/topics/234/cell_fill_select_new.png
2. Click, hold, and drag the fill handle until all of the cells you want to fill are selected.
http://content.gcflearnfree.org/topics/234/cell_fill_drag.png
3. Release the mouse to fill the selected cells.
http://content.gcflearnfree.org/topics/234/cell_fill_done.png

0 Replies
 
chai2
 
  1  
Reply Fri 13 May, 2016 11:27 am
@Tes yeux noirs,
Tes yeux noirs wrote:

Bottom right corner of a selected cell or area.



Just to clarify, when you put the cursor on the bottom right corner, it will change to a little black cross.

That's how you know you're in the correct position to drag.
Tes yeux noirs
 
  1  
Reply Fri 13 May, 2016 11:31 am
@chai2,
Quote:
when you put the cursor on the bottom right corner, it will change to a little black cross.

Yes, the cursor changes from the normal Excel cursor (a white outline cross) to a thin black cross

1. Normal cursor
http://www.sussex.ac.uk/its/images/faq/excelcurs_point.gif
2. Fill cursor
https://qph.is.quoracdn.net/main-qimg-ab4595b904383f8ff2f1c001caabede6?convert_to_webp=true
gollum
 
  1  
Reply Fri 13 May, 2016 03:02 pm
@Tes yeux noirs,
Thank you all.
0 Replies
 
 

Related Topics

 
  1. Forums
  2. » Fill Handle
Copyright © 2024 MadLab, LLC :: Terms of Service :: Privacy Policy :: Page generated in 0.06 seconds on 12/11/2024 at 08:56:58