Autofill in Excel 2013

Topic

New Reply

I believe I used to be able to autofill two cells by highlighting them and clicking on the corner to drag them down and they would replicate into however many cells I dragged them.  Now, however, the cells want to increase in value instead of just copying.  I’ve changed the format in the cells to all different options but still won’t just copy.  Is there a way to format the cells I’m not aware of, or is this just the way it is now?

Reply | Quote

Replies

That is normal behavior. If you just  want to copy do this:

1. Select the cells to copy (source cells).
2. Press Ctrl+C.
3. Select the cells to copy to (destination cells).
4. Press Enter.

HTH

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote

Thank you!  So good to see you here again!

Reply | Quote

[Moonshine]

Select the two cells, then drag the ‘Fill Handle’ down the selected range, then click on the appearing ‘AutoFill Options’ menu to expand and then select ‘Copy Cells’.

• This reply was modified 4 years, 5 months ago by Moonshine.

3 users thanked author for this post.

RuosChalet, WSk32rem, RockFox

Reply | Quote

Select the cells and drag down, but before releasing the mouse press ctrl. It’s been like this for years.

Eliminate spare time: start programming PowerShell

3 users thanked author for this post.

RuosChalet, WSk32rem, zat_so

Reply | Quote

Gee, I didn’t  know about that one. Excel just has too many ways to do the same thing to remember them all, if you knew them in the first place…LOL!

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote

I’ve known about it for so long I don’t remember how I learned about it. Been on many Access courses but never an Excel one. But I do like simple! I bet Zeddy would know about this method!

Eliminate spare time: start programming PowerShell

Reply | Quote

It’s the way I do it for copying to a location I’m not quite sure about. Visual alignment makes it much easier.

cheers, Paul

Reply | Quote

If something you don’t expect happens in XL, try the same thing while pressing Ctrl or Shift or Alt. Even AltGr could help -it seems- .

Reply | Quote

You can drag the bottom-right handle with the right mouse button instead of the left mouse button and, when you release, it will pop up a menu for you to select what you’d like to do.

2 users thanked author for this post.

RuosChalet, WSk32rem

Reply | Quote

Okay, I’m not always the best at explaining my objectives.  In the attached Word file is a screenshot of the two aforementioned documents with highlighted cells.  My objective is to have Employee #1’s yellow highlighted number in Cell E5 on the righthand sheet transfer to the yellow highlighted cell (I6) on the lefthand sheet.  Then the next week it will be Cell E6 on the righthand sheet that will need to be transferred to Cell I6 on the lefthand sheet, and so on down each succeeding week.  Obviously, Employee #2 will have to have different references.

Also, it would be great if the “Check Date”, “Pay Week” and “Week Number” fields could be automatically updated each week.  I have another file that was set up years ago with the help of either Maudibe (sp?) and/or Zeddy that has a separate sheet for a calendar; then they used formulas that include “IF” and “MATCH” to populate for weekly updates on other sheets.  I don’t know how to do any of that, I can just see that’s what they used.  Maybe I should put the work sheets in one workbook?

Thanks again for any help!

Reply | Quote

Please ignore the prior post in this thread.  I put it in the wrong thread and don’t know how to delete it, if able to.  Sorry!

Reply | Quote