I want to select every other column
 

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

I want to select every other column
 

Excel currently has a maximum of 256 columns!

--
AP

"JS" a écrit dans le message de
...
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

I want to select every other column
 

Hi

Excel only has 256 columns. Do you mean rows?

Andy.

"JS" wrote in message
...
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

I want to select every other column
 

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

"AndyB" wrote:

Hi

Excel only has 256 columns. Do you mean rows?

Andy.

"JS" wrote in message
...
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

I want to select every other column
 

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" a écrit dans le message de
...
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

I want to select every other column
 

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" wrote in message
...
Oh yes, it is true...I meant many columns...
JS

"AndyB" wrote:

Hi

Excel only has 256 columns. Do you mean rows?

Andy.

"JS" wrote in message
...
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

I want to select every other column
 

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" a écrit dans le message de
...
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

I want to select every other column
 

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" wrote in message
...
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

I want to select every other column
 

"Do not want to be able to write" indicates that you would want to lock the
cells for editing.

Is this correct?

Every other column reaching how far across the sheet? Do you have a range
in mind?

Every other row reaching how far down the sheet? Do you have a range in
mind?

Which version of Excel? 2007 has 16384 columns and over 1 million rows.

Surely you would not need all those rows and columns locked.


Gord Dibben MS Excel MVP

On Tue, 24 Mar 2009 15:26:01 -0700, lotrgranny
wrote:

I want to skip every other column and everyother row from the top to the
bottom and from side to side of my document. Do I do something similar? I
do not want to be able to write in the first, third, fifth rows or columns?
What would I do