View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
John Bundy John Bundy is offline
external usenet poster
 
Posts: 772
Default Can fill handle be moved without mouse dragging?

Double clicking the fill handle fills the data down. If that doesn't do it
for you copy the cell hold shift tap End and then tap the down arrow.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Chris Lukowski" wrote:

I often select cells and use the fill handle to populate data in my
worksheets, but it's a royal pain using my mouse to drag the fill box all the
way down a spreadsheet containing thousands of rows. Is there a keyboard
shortcut to dragging the fill handle to the top/bottom of the sheet, or even
use page up/down if that's not possible? Thanks.