Results 1 to 2 of 2

Thread: Keyboard Shortcut to Copy Down a Range
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Oct 2015
    Posts
    59
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Keyboard Shortcut to Copy Down a Range

    Hi,


    I have data in A2:A1000 and would like to put a formula in cell B2 and then copy it down from B3 to B1000.


    I know that I can use the fill handle and mouse to copy it quickly to B3:B1000.


    If I wanted to use the keyboard, is there a shortcut key sequence that I can use to select the range in B3:B1000 rather than using things like Shift+PgDn?


    Thanks!

  2. #2
    Board Regular
    Join Date
    Feb 2010
    Location
    London, UK
    Posts
    9,296
    Post Thanks / Like
    Mentioned
    24 Post(s)
    Tagged
    3 Thread(s)

    Default Re: Keyboard Shortcut to Copy Down a Range

    If you select a vertical range, e.g. A1:A10 and A1 has a formula or value, press CTRL+D (Windows) and it will fill A2:A10 with same contents as A1

    This may also help: http://tinyurl.com/y2py4akr


Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •