1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Keyboard Shortcut

Discussion in 'Business Applications' started by floydcojacket, Jan 30, 2013.

Thread Status:
Not open for further replies.
Advertisement
  1. floydcojacket

    floydcojacket Thread Starter

    Joined:
    Jul 4, 2008
    Messages:
    274
    Excel 2007,
    I have a worksheet with each day of the year 1/1/2013-12/31/2013 from cell "O-1" to cell "NO-1".
    I want to place a formula in the cell "O-3" and use a keyboard shortcut to copy/extend this formula to cell "NO-3". Simply dragging the formula across is no trouble, I'm just wanting to learn a better way.
    Isn't there a keyboard shortcut to do this with?
    Thank you for your help.
     
  2. valis

    valis Moderator

    Joined:
    Sep 24, 2004
    Messages:
    75,503
    can't you just double click the fill handle? That's the little plus sign in the bottom left of the active cell.
     
  3. floydcojacket

    floydcojacket Thread Starter

    Joined:
    Jul 4, 2008
    Messages:
    274
    Yes, but it only goes vertically down. I want it to go horizontally across.
    How to do that?
     
  4. Garf13LD

    Garf13LD

    Joined:
    Apr 17, 2012
    Messages:
    455
    Same. It's bottom right btw.
     
  5. floydcojacket

    floydcojacket Thread Starter

    Joined:
    Jul 4, 2008
    Messages:
    274
    Thank you for your reply.
    I have tried this process but it doesn't work for me.
    I have also tried Control+Shift+Right Arrow, but all that does is highlight all of the cells clear to the end of the row.
    Clicking the "+" at the bottom right corner however does work well for auto filling a column from top to bottom.
    Although in this case, I'm wanting to auto fill from left to right.
    Thank you again.
     
  6. Garf13LD

    Garf13LD

    Joined:
    Apr 17, 2012
    Messages:
    455
    make sure you select at least 2 cells before you drag.
    Meaning.
    select o1 and p1, then hold on to the plus sign and drag.
     
  7. floydcojacket

    floydcojacket Thread Starter

    Joined:
    Jul 4, 2008
    Messages:
    274
    No problem w/the clicking and dragging, that works very well.
    What I want is (the equivalent of double clicking the plus sign for vertical auto fill) in order to auto fill from left to right.
    My dates are running horizontally in a row. For example, cell A1 starts with 1/1/2013 and continues to cell NA1 with 12/31/2013.
    I want to be able to put in a formula in cell A2 like =month(A1) and auto fill that formula to cell NA2.
    When I double click cell A2, nothing happens, if I Control+Shift+Right Arrow, it merely highlights the rest of the cells to the right of cell A2, but does not copy and paste or auto fill.
    I can click and drag w/no problem, but I'm just looking for a way to auto fill this row from cell A2 to cell NA2.
    Thanks for your help.
     
  8. valis

    valis Moderator

    Joined:
    Sep 24, 2004
    Messages:
    75,503
    thanks, was walking out the door as I typed that. :)
     
  9. valis

    valis Moderator

    Joined:
    Sep 24, 2004
    Messages:
    75,503
    once you select the first cells horizontally and autofill them, does it not fill horizontally?
     
  10. floydcojacket

    floydcojacket Thread Starter

    Joined:
    Jul 4, 2008
    Messages:
    274
    I am attaching a worksheet so that you may see what I'm working on.
    At least I think it's attaching. I will post the reply and then see if it attached since it is not showing that it is attached here yet.
     

    Attached Files:

  11. floydcojacket

    floydcojacket Thread Starter

    Joined:
    Jul 4, 2008
    Messages:
    274
    I have found that if I copy formula from A2 and paste to B2, I can Control+Shift+Paste+Right Arrow+Enter and it will auto fill across row 2, but it auto fills all the way to the end of the spreadsheet instead of stopping at AN2. Wonder what to do about that now.
     
  12. Garf13LD

    Garf13LD

    Joined:
    Apr 17, 2012
    Messages:
    455
    I don't quite understand the "the equivalent of double clicking the plus sign for vertical auto fill"
    There are a few ways to fill numbers.
    1. to fill one cell, select the cell to the right you want to fill then ctrl+R. (eg at B2, ctrl+R will fill A2's formula)
    2. to fill more than one cells, goto NA2 > Ctrl+Shft+left > Ctrl+R
    3. copy A2, then select the cells you want to copy to, then either hit ENTER or PASTE.
     
  13. floydcojacket

    floydcojacket Thread Starter

    Joined:
    Jul 4, 2008
    Messages:
    274
    Thank you for your reply.
    That will work just fine.
    Have a great day.
     
  14. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1087600

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice