+ Reply to Thread
Results 1 to 3 of 3

Drag down formula through column until data stops - possible with keyboard shortcut?

  1. #1
    Registered User
    Join Date
    12-29-2014
    Location
    My cube
    MS-Off Ver
    2016
    Posts
    16

    Drag down formula through column until data stops - possible with keyboard shortcut?

    Is there a way to drag down this formula in cell A3 down through cell A13 with using just the keyboard? I have a mouse with programmable buttons and would like to add a macro to do this for me. Attached is the sample workbook.

    drag down formula.jpg

    Thank you for your time.
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,718

    Re: Drag down formula through column until data stops - possible with keyboard shortcut?

    Do you see that little black square in the bottom right corner of the cursor around A3? That is called the fill handle, and if you double click that the formula will be copied down to the bottom of the data that you have in column B.

    Another approach would be to convert the columns into a structured table, and then when the formula is entered into A3 it will automatically be copied down.

    Hope this helps.

    Pete

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,418

    Re: Drag down formula through column until data stops - possible with keyboard shortcut?

    Please Login or Register  to view this content.

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [keyboard shortcut] jump to last cell in column
    By boarders paradise in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 08-04-2017, 02:04 PM
  2. Keyboard shortcut to get to the next changing text in a column
    By Helal in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 10-26-2012, 09:14 AM
  3. Keyboard Shortcut Freeze Row And Column
    By goss in forum Excel General
    Replies: 2
    Last Post: 05-21-2012, 01:10 PM
  4. Copying Formulas In a Column - Keyboard Shortcut
    By Elden in forum Excel General
    Replies: 2
    Last Post: 08-28-2007, 10:17 AM
  5. Replies: 1
    Last Post: 02-08-2007, 10:57 AM
  6. [SOLVED] What is keyboard shortcut equivalent to drag the fill handle
    By JZ in forum Excel General
    Replies: 2
    Last Post: 07-31-2006, 01:30 AM
  7. Keyboard shortcut or selecting entire column
    By Precious_Stone in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-18-2006, 12:45 PM
  8. [SOLVED] Keyboard Shortcut to move to top of column in worksheet?
    By piddilin in forum Excel General
    Replies: 5
    Last Post: 03-21-2005, 07:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1