Solved: Keyboard Shortcut

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

floydcojacket

Thread Starter
Joined
Jul 4, 2008
Messages
281
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.
 

valis

Moderator
Joined
Sep 24, 2004
Messages
77,832
can't you just double click the fill handle? That's the little plus sign in the bottom left of the active cell.
 

floydcojacket

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

floydcojacket

Thread Starter
Joined
Jul 4, 2008
Messages
281
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.
 
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.
 

floydcojacket

Thread Starter
Joined
Jul 4, 2008
Messages
281
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.
 

valis

Moderator
Joined
Sep 24, 2004
Messages
77,832
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.
once you select the first cells horizontally and autofill them, does it not fill horizontally?
 

floydcojacket

Thread Starter
Joined
Jul 4, 2008
Messages
281
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.
 

Attachments

floydcojacket

Thread Starter
Joined
Jul 4, 2008
Messages
281
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.
 
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.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

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 807,865 other people just like you!

Latest posts

Staff online

Top