Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 21st 09, 10:49 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 75
Default Is there a keyboard shortcut to fill handle a large # of cells?

I know if you click on a cell and wait for the black cross you can fill
handle cells by clicking and dragging, but that takes a while when we need to
fill thousands of cells. Is there a keyboard shortcut that can drag and fill
the cells faster?

  #2   Report Post  
Old December 21st 09, 11:03 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 8,651
Default Is there a keyboard shortcut to fill handle a large # of cells?

Double click on the fill handle, & it will fill down as far as there is data
in the adjacent column.
Otherwise copy, then select the relevant range and paste.
--
David Biddulph

"Erin" wrote in message
...
I know if you click on a cell and wait for the black cross you can fill
handle cells by clicking and dragging, but that takes a while when we need
to
fill thousands of cells. Is there a keyboard shortcut that can drag and
fill
the cells faster?



  #3   Report Post  
Old December 22nd 09, 02:13 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,907
Default Is there a keyboard shortcut to fill handle a large # of cells?

What content is in the cells?

Enter =B1 in A1

In namebox type A1:A12000 and ENTER

Ctrl + d to fill down.


Gord Dibben MS Excel MVP

On Mon, 21 Dec 2009 13:49:01 -0800, Erin
wrote:

I know if you click on a cell and wait for the black cross you can fill
handle cells by clicking and dragging, but that takes a while when we need to
fill thousands of cells. Is there a keyboard shortcut that can drag and fill
the cells faster?




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
What is keyboard shortcut equivalent to drag the fill handle JZ Excel Discussion (Misc queries) 2 July 31st 06 06:25 AM
using the fill handle All the cells return the value of the first Chris Simmons Excel Worksheet Functions 1 December 12th 05 05:30 PM
There should be a keyboard shortcut for fill color in excel Jerry Excel Worksheet Functions 1 September 23rd 05 03:23 PM
Keyboard command to replace double clicking the fill handle Pat Excel Discussion (Misc queries) 1 May 18th 05 05:50 PM
what is keyboard shortcut to auto fill option Rozeta Excel Discussion (Misc queries) 3 February 18th 05 10:47 PM


All times are GMT +1. The time now is 03:17 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017