There's no such thing as a stupid question, but they're the easiest to answer.


Business Applications Business Applications
Search Search
Search for:
Tech Support Guy > > >

Excel paste value every other row


Bob3d7d's Avatar
Bob3d7d Bob3d7d is offline
Computer Specs
Junior Member with 1 posts.
Join Date: Jan 2007
Experience: Advanced
08-Jan-2007, 04:45 PM #1
Excel paste value every other row
We have an Excel Spreadsheet that displays the weeks of the year. Sometimes we have to paste a value in for every other week. Right now we do that manually and it takes a long time. How can we automate the process of pasting this data into every other row?

bomb #21's Avatar
Member with 8,268 posts.
Join Date: Jul 2005
Location: The void AKA edge of the Fens
Experience: I bent my wookie :(
08-Jan-2007, 05:19 PM #2
Let's say you want it in row 1, row 3, etc.

Paste the value to (say) E1. Then select E1 and E2. Then hover over the small black square at the bottom right of the selection ("fill handle"). While holding down CTRL, click and drag the handle down as far as you need.

ChuckE's Avatar
Member with 2,311 posts.
Join Date: Aug 2004
Location: Redondo Beach, CA
Experience: Advanced
08-Jan-2007, 06:46 PM #3
Why hold down <Ctrl>? It does the same for me whether or not I hold down <Ctrl>.
bomb #21's Avatar
Member with 8,268 posts.
Join Date: Jul 2005
Location: The void AKA edge of the Fens
Experience: I bent my wookie :(
09-Jan-2007, 12:35 AM #4
For me, CTRL prevents incrementing. Alternatively, copying a value and a blank cell below & then pasting to a vertical range of even numbered cells should do it.
Zack Barresse's Avatar
Computer Specs
Member with 5,447 posts.
Join Date: Jul 2004
Location: Oregon, United States
Experience: I'ma learnin'!
09-Jan-2007, 10:47 AM #5
Bob, are your weeks of the year one per row?
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine

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.

Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools

You Are Using: Server ID
Trusted Website Back to the Top ↑