I want to select every other column

G

Guest

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
 
G

Guest

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.
 
G

Guest

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
 
M

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, ...)
 
L

lotrgranny

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
 
G

Gord Dibben

"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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top