ahmad said:
kindly let me have a solution for selecting all the
even\odd rows or columns in an excel sheet,
Here's one way, but it may seem a bit odd.
First some preparation. Do this part only once.
In an unused column, paste
=MOD(ROW(),2)
in each row that has data in it.
Select the column, and use
Data > Filter > Auto filter
With this preparation done, you'll see a pull-down triangle at the top of
the column. Each time you want to do the selection, use the triangle to
choose 0 or 1 to show only the even or odd rows. With the desired rows
showing, use
Edit > Go to > Visible cells only
This does what you requested. To see that the alternate rows are selected,
you can use the pull-down triangle to show "All" rows. Notice the
horizontal stripes.
You can then copy (or delete or whatever) the selected rows.
