+ Reply to Thread
Results 1 to 5 of 5

Create shortcut for "Fill Up"

  1. 11-13-2008, 01:15 PM #1
    klassic is offline
    Registered User
    Join Date
    11-13-2008
    Location
    US
    Posts
    3

    Create shortcut for "Fill Up"

    Is there anyway to create a shortcut for the Fill Up command. You know, Fill Down is Ctrl-D and Fill Right is Ctrl-R. Is there anyway to set up one for Fill Up?
    Reply With QuoteRegister To Reply
  2. 11-13-2008, 09:47 PM #2
    sglife is offline
    Valued Forum Contributor
    Join Date
    08-26-2008
    Location
    singapore
    Posts
    626
    Go to Tools > Macro > Record New macro
    Macro Name: FillUp, Short Cut: Ctrl+****+U (Because Ctrl+U is unavaliable)

    Tools > Macro > Record New macro
    Macro Name: FillUp, Short Cut: Ctrl+****+U (Because Ctrl+U is unavaliable)
    Ok, then key in something or what ever, then stop recording
    Alt+F11, open the VBA
    Use the following code to overwrite the code in Modules, Sub FillUp()

    Please Login or Register  to view this content.
    Save
    Done
    I need your support to add reputations if my solution works.

    Reply With QuoteRegister To Reply
  3. 06-13-2013, 01:03 AM #3
    andre.jk is offline
    Registered User
    Join Date
    06-13-2013
    Location
    Dubai
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Create shortcut for "Fill Up"

    Hi sglife,

    Thanks for this. But how can I code it to work on multiple selected cells, like a row of data?
    Reply With QuoteRegister To Reply
  4. 06-13-2013, 01:08 AM #4
    andre.jk is offline
    Registered User
    Join Date
    06-13-2013
    Location
    Dubai
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Create shortcut for "Fill Up"

    Its k.. I got it. Just changed 'ActiveCell' to 'Selection'
    Reply With QuoteRegister To Reply
  5. 01-20-2015, 01:07 PM #5
    xoceejayxo is offline
    Registered User
    Join Date
    01-20-2015
    Location
    Whittier, CA
    MS-Off Ver
    2010
    Posts
    1

    Re: Create shortcut for "Fill Up"

    Thank you! This worked flawlessly and saved me so much time.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1