Excel: alternative column display

hello guys i really need help (sorry 4 bad english) i have some numbers in odd columns like a1,c1,e1,... so on i want to use them in other places by autofill function but when i use them other values in b1,d1 will be there. i dont need them. how can i use a1,c1,e1 in auto fill function in a row? there were alots of threads about alternative rows here but no one said about how to display alternative column next to each other. can u plz help me/?

This question generated 10 answers. To proceed to the answers, click here.

This thread is current as of October 04, 2014.

For more resources for Microsoft Excel