I want to select every other column

[JS]

I would like to know if there is a function where I can select a column, skip
a column, and select again, etc. without doing manually, because I have more
than a thousand columns to go through.

Thanks

Hi

Excel only has 256 columns. Do you mean rows?

Andy.

"JS" <JS@discussions.microsoft.com> wrote in message
news:01123CCC-290E-4E38-98C0-56E418A0E22F@microsoft.com...
>I would like to know if there is a function where I can select a column,
>skip
> a column, and select again, etc. without doing manually, because I have
> more
> than a thousand columns to go through.
>
> Thanks
>

[Ardus Petus]

Excel currently has a maximum of 256 columns!

--
AP

"JS" <JS@discussions.microsoft.com> a écrit dans le message de
news:01123CCC-290E-4E38-98C0-56E418A0E22F@microsoft.com...
> I would like to know if there is a function where I can select a column,
skip
> a column, and select again, etc. without doing manually, because I have
more
> than a thousand columns to go through.
>
> Thanks
>

[JS]

Oh yes, it is true...I meant many columns...
JS

"AndyB" wrote:

> Hi
>
> Excel only has 256 columns. Do you mean rows?
>
> Andy.
>
> "JS" <JS@discussions.microsoft.com> wrote in message
> news:01123CCC-290E-4E38-98C0-56E418A0E22F@microsoft.com...
> >I would like to know if there is a function where I can select a column,
> >skip
> > a column, and select again, etc. without doing manually, because I have
> > more
> > than a thousand columns to go through.
> >
> > Thanks
> >
>
>
>

[ufo_pilot]

http://www.andrewsexceltips.com/my_utilities.htm
Download Andrews Utilities (add in)
This thing does that and a whole lot more...


"Ardus Petus" wrote:

> Excel currently has a maximum of 256 columns!
>
> --
> AP
>
> "JS" <JS@discussions.microsoft.com> a écrit dans le message de
> news:01123CCC-290E-4E38-98C0-56E418A0E22F@microsoft.com...
> > I would like to know if there is a function where I can select a column,
> skip
> > a column, and select again, etc. without doing manually, because I have
> more
> > than a thousand columns to go through.
> >
> > Thanks
> >
>
>
>

Just so I understand your problem, why do you need to select alternate
columns/rows (still don't know which from your answer)? <vbg>
It may guide us to the best way of helping you.

Andy.

"JS" <JS@discussions.microsoft.com> wrote in message
news:D311EFC3-C1C6-4246-A687-B925C458A82A@microsoft.com...
> Oh yes, it is true...I meant many columns...
> JS
>
> "AndyB" wrote:
>
>> Hi
>>
>> Excel only has 256 columns. Do you mean rows?
>>
>> Andy.
>>
>> "JS" <JS@discussions.microsoft.com> wrote in message
>> news:01123CCC-290E-4E38-98C0-56E418A0E22F@microsoft.com...
>> >I would like to know if there is a function where I can select a column,
>> >skip
>> > a column, and select again, etc. without doing manually, because I have
>> > more
>> > than a thousand columns to go through.
>> >
>> > Thanks
>> >
>>
>>
>>

[JS]

OK, I meant I have 1000 columns of data, so I will use 4 worsheets! Is there
still a way to do what I want?
JS

"Ardus Petus" wrote:

> Excel currently has a maximum of 256 columns!
>
> --
> AP
>
> "JS" <JS@discussions.microsoft.com> a écrit dans le message de
> news:01123CCC-290E-4E38-98C0-56E418A0E22F@microsoft.com...
> > I would like to know if there is a function where I can select a column,
> skip
> > a column, and select again, etc. without doing manually, because I have
> more
> > than a thousand columns to go through.
> >
> > Thanks
> >
>
>
>

[Max]

If you mean select alternate rows, try this:

In an empty col, say, col E
enter into E1:E2: x, y
then select E1:E2 and drag down to row1000
(this will fill col E with alternating x,y,x,y,x,y ... )

Click Data > Filter > Autofilter

Select x from the droplist in E1
to get the filtered rows with "x", i.e. rows 3,5,7,9, ...

Now you can select the filtered "blue" row headers
(include the top row also),
and paste all these rows only somewhere else

Repeat likewise if required by selecting y from the droplist
(rows 2,4,6,8, ...)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"JS" <JS@discussions.microsoft.com> wrote in message
news:01123CCC-290E-4E38-98C0-56E418A0E22F@microsoft.com...
> I would like to know if there is a function where I can select a column,
skip
> a column, and select again, etc. without doing manually, because I have
more
> than a thousand columns to go through.
>
> Thanks
>