software

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.

ThanksExcel currently has a maximum of 256 columns!

--
AP

quot;JSquot; gt; a écrit dans le message de
...
gt; I would like to know if there is a function where I can select a column,
skip
gt; a column, and select again, etc. without doing manually, because I have
more
gt; than a thousand columns to go through.
gt;
gt; Thanks
gt;
Hi

Excel only has 256 columns. Do you mean rows?

Andy.

quot;JSquot; gt; wrote in message
...
gt;I would like to know if there is a function where I can select a column,
gt;skip
gt; a column, and select again, etc. without doing manually, because I have
gt; more
gt; than a thousand columns to go through.
gt;
gt; Thanks
gt;
Oh yes, it is true...I meant many columns...
JS

quot;AndyBquot; wrote:

gt; Hi
gt;
gt; Excel only has 256 columns. Do you mean rows?
gt;
gt; Andy.
gt;
gt; quot;JSquot; gt; wrote in message
gt; ...
gt; gt;I would like to know if there is a function where I can select a column,
gt; gt;skip
gt; gt; a column, and select again, etc. without doing manually, because I have
gt; gt; more
gt; gt; than a thousand columns to go through.
gt; gt;
gt; gt; Thanks
gt; gt;
gt;
gt;
gt;

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

gt; Excel currently has a maximum of 256 columns!
gt;
gt; --
gt; AP
gt;
gt; quot;JSquot; gt; a écrit dans le message de
gt; ...
gt; gt; I would like to know if there is a function where I can select a column,
gt; skip
gt; gt; a column, and select again, etc. without doing manually, because I have
gt; more
gt; gt; than a thousand columns to go through.
gt; gt;
gt; gt; Thanks
gt; gt;
gt;
gt;
gt;

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

Andy.

quot;JSquot; gt; wrote in message
news
gt; Oh yes, it is true...I meant many columns...
gt; JS
gt;
gt; quot;AndyBquot; wrote:
gt;
gt;gt; Hi
gt;gt;
gt;gt; Excel only has 256 columns. Do you mean rows?
gt;gt;
gt;gt; Andy.
gt;gt;
gt;gt; quot;JSquot; gt; wrote in message
gt;gt; ...
gt;gt; gt;I would like to know if there is a function where I can select a column,
gt;gt; gt;skip
gt;gt; gt; a column, and select again, etc. without doing manually, because I have
gt;gt; gt; more
gt;gt; gt; than a thousand columns to go through.
gt;gt; gt;
gt;gt; gt; Thanks
gt;gt; gt;
gt;gt;
gt;gt;
gt;gt;
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

quot;Ardus Petusquot; wrote:

gt; Excel currently has a maximum of 256 columns!
gt;
gt; --
gt; AP
gt;
gt; quot;JSquot; gt; a écrit dans le message de
gt; ...
gt; gt; I would like to know if there is a function where I can select a column,
gt; skip
gt; gt; a column, and select again, etc. without doing manually, because I have
gt; more
gt; gt; than a thousand columns to go through.
gt; gt;
gt; gt; Thanks
gt; gt;
gt;
gt;
gt;

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 gt; Filter gt; Autofilter

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

Now you can select the filtered quot;bluequot; 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
savefile.com/projects/236895
xdemechanik
---
quot;JSquot; gt; wrote in message
...
gt; I would like to know if there is a function where I can select a column,
skip
gt; a column, and select again, etc. without doing manually, because I have
more
gt; than a thousand columns to go through.
gt;
gt; Thanks
gt;
quot;Do not want to be able to writequot; 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 gt;
wrote:

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