Excel - Fill Formula into Every Other Row

Use the Auto-Fill handle to fill a formula, but skip every other row.

[@michelepowell8769]

Exactly what I needed and super easy thank you!

[@ApexTrainingLLC]

I’m glad it helped!!

[@megadethfanboy4088]

EXACTLY WHAT I WAS LOOKING FOR THANK YOU

[@ApexTrainingLLC]

Thank you so much for the feedback!

[@kingsleyemeka2136]

Thanks so much sir, I'm very grateful.

[@ApexTrainingLLC]

Thank you for checking in!

[@Dannyisgreatful]

THANKS SO MUCH MAN!!!!
you just help me get my laser back up and running after 3 days :D

[@ApexTrainingLLC]

+Dannyisgreatful hey Danny, you have a laser controller by Excel? Fascinating.

[@prafullimahakal737]

So easy method....thank you so much

[@dalekasal7308]

Wonderful. Thanks!

[@ApexTrainingLLC]

Thanks Dale!

[@harsinchh4342]

Thank You very much, Sir. 🙏🙏🙏🙏🙏

[@ApexTrainingLLC]

Most welcome!

[@fw1374]

So easy! Thank you very much!

[@ApexTrainingLLC]

Thanks! I appreciate you checking out the channel. I am about to start loading a lot more videos on Excel. Stay tuned! Please subscribe!

[@OaktownGirl]

Thank you so much!

[@ApexTrainingLLC]

You're welcome!

[@calebpinnell6887]

Thank you!!

[@ApexTrainingLLC]

Thanks Caleb!

[@AdiAdi-ix8lc]

thank you !!!!

[@Franseven]

THANK YOU

[@ApexTrainingLLC]

Thanks for checking in! I’m glad you enjoyed the video. Please subscribe and click the notification bell! 😃

[@foxfirerage]

I knew this trick, the problem I am having is doing this with a ref. Anyone know how to stop the reference from skipping numbers. I am using =IF(NAMELIST!$D1="","",NAMELIST!$D1) but in row three it uses D3 then 5 then 7. I just want to skip rows but count normally D1 D2 D3. Any ideas?

[@ApexTrainingLLC]

There are a couple of ways to address this. I'll put together an example for you

[@foxfirerage]

@@ApexTrainingLLC awesome you are a life saver!

[@kevinwolfe388]

Was this ever solved? I am having the same issue where the reference is skipping cells. Thanks!@@ApexTrainingLLC

[@nxchauvin]

This only works if the next cell in the row is blank, if there is a formula or word, it will repeat that one as well and will not leave the second row unchanged.

[@jesschodor8949]

My next cell is blank but it is still copying the formula into all cells instead of every other. Any ideas??

[@PaulaStreet]

Thanks

[@RichKerr]

You're welcome Paula!

[@jesschodor8949]

This worked in one workbook I was working in, but now in my new workbook it is copying the formula into every row instead of keeping a blank cell in every other row. Any ideas??

[@ApexTrainingLLC]

Hi! Will check on this for you

[@jesschodor8949]

Thank you, Rich! Very time consuming task & room for error when this doesn't work, blah! @ApexExcelTraining

[@jesschodor8949]

Oy... I had some rows hidden. That was the issue. Resolved.

[@ApexTrainingLLC]

I’m glad you got it worked out!

[@moniquetulloch5091]

what if we also have calculations in the other row

[@ApexTrainingLLC]

Hi Monique. Id love to help, but I'm not clear on the question. Which other row?

[@moniquetulloch5091]

Ok so I want one row to have in the original price of something and the row following to have it at a discounted price. I want that format to continue for 24 times. However when I use this formula that u recommend i see it deleting the original price and making the duplicates of the discount. I'm doing a simulation project for quantitative methods, where it says in the first month travel cost is normal however every other month it should be discounted by 50% so I'm trying to find a formula to do that instead of having to do it manually.

[@ApexTrainingLLC]

Ok Monique, email me tomorrow so we can schedule a time to talk. I can help you with this. [e-mail]

[@foxfirerage]

create a new column and number it all the way down then filter to evens or odds to skip the other columns

[@PaleoAthletics]

Doesn't work

[@ApexTrainingLLC]

+PaleoAthletics hi, can you be a bit more specific about what is happening? I'd love to assist you, but I need more information.

[@pcb1962]

Office 2010 - the double click does nothing