EXCEL表格中有多行,我想一次删除2、4、6…行,怎么能快速删除?

发布网友 发布时间：2022-04-25 06:53

我来回答

共4个回答

热心网友 时间：2023-11-05 00:29

找一个空白列
第一行单元格输入
=mod(row(),2)
填充到底
筛选这列=1的行
拷贝到新表中即可（这样保险）
或者筛选这列=0的行
按照shift选中第一行，选中最后一行，右键-删除

热心网友 时间：2023-11-05 00:30

用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,找到此宏，执行即实现快速删除双数行。

热心网友 时间：2023-11-05 00:30

找一空列，输入=MOD(ROW(),2)，向下复制公式。
然后按这列排序，选择删除。

热心网友 时间：2023-11-05 00:31

In yards,tiffany heart necklace on Sale Power level of the

Photographer Thomas Ruff "JPEG" series dective 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/procer 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 reprocibility, 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.