Most valuable professional
  • Hot Topics

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 4, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel