找一个空白列
第一行单元格输入
=mod(row(),2)
填充到底
筛选这列=1的行
拷贝到新表中即可(这样保险)
或者筛选这列=0的行
按照shift选中第一行,选中最后一行,右键-删除
用VBA代码来处理
按Alt+F11,打开VBA编辑器,在左边的工程点右键插入模块,粘贴如下代码
Sub 删除双数行()
Dim R&, x&
R = Range("A65536").End(xlUp).Row
For x = R To 1 Step -1
If x Mod 2 = 0 Then
Rows(x).Delete
End If
Next x
End Sub
需要删除双数行时,按Alt+F8,找到此宏,执行即实现快速删除双数行。
找一空列,输入=MOD(ROW(),2),向下复制公式。
然后按这列排序,选择删除。
In yards,tiffany heart necklace on Sale Power level of the
Photographer Thomas Ruff "JPEG" series deductive is digital imaging compression and decompression processing technology,Discount UGG Call Paddington, Ruff will enlarge the grand canyon image processing, viewed from a distance, the picture is fine, clear, and near but vague.
Pedro Almodovar
Small yards
Pedro Almodovar director/producer with graphic designer Juan Gatti have long-term cooperation. This time, they again hand in hand altogether will create the works, they will plenties movie posters "tear" and again joining together. Whole &lady were covered with posters image, are taken from Almodovar of classic: Mother, wish All talking Bad Volver, complete and Matador.
In yards
Words written by T.J. Wilcox recent are creating his digital puzzle with watercolour combination of serial works,ugg mens kids, and choose the reproducibility, his "Apparition (Indian dancers II)". &lady depicts a suit on aborigines attire, wore dark glasses man and a are landing paratroopers.
Phil Poynter
Small yards
Photographer Phil Poynter want to Lindvall "stuck" Angela in this &lady wearer bodies. This is a surrealist works. Lindval wearing swimming cap, the goggles,ugg coquette slippers, submerged in a filled with water of glass vessels. When you put on this &lady, Lindvall as from your chest staring at the outside.
Today season of men's clothing T-shirt model case is dye-in-the-wood, special styles including "Grungy T", "Mr Marc T", "T" and "Horror made Drip T". Splicing knitting coat is today season the popular sheet is tasted, tie-in simple clothes pants have let you be the focus.
Illustration: he knows the ordinary dress to wear out their own style,tiffany cufflinks Marc Jacobs by Marc winter 2008 shows,cheap tiffany rings, this body clothing with the characteristic, a blue-collar portrayed a close to the common people,Discount UGG, particularly working-class image,tiffany watches, for its primary wins added points.