View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default Autofill series with keyboard

For clarity, note that a selection of cells need to be active for these
shortcuts to work. I.e, to autofill B1 in range B1:B10, select B1:B10 with B1
active, then press Ctrl+D.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Luke M" wrote:

Fill to the right:
Ctrl+R
Fill down:
Ctrl+D

For further reading, an extensive list of keyboard shortcuts within XL:
http://www.mvps.org/dmcritchie/excel/shortx2k.htm
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Colin" wrote:

How do you autofill a series of data (days of the week for example) only
using the keyboard? My clients are unable to use a mouse and would like to
use this feature in Excel.
--
Thank you,

Colin.