Excel表格技巧:如何每隔N行(如:十二行)删除一行?
本教程适用版本:WPS 365 点击免费使用
使用WPS Office打开表格,如图,每隔十二行删除一行。
则删除第13行、26行。在C13,C26输入数字1,拖动单元格下拉。
选中C列,快捷键“Ctrl+G”打开定位功能,依次点击“定位”—>“数据”—>“定位”。
>免费升级到企业版,赠超大存储空间
鼠标右键选中的行,依次点击“删除”—>“整行”即可。
Keyword: 全国楼凤论坛
本教程适用版本:WPS 365 点击免费使用
使用WPS Office打开表格,如图,每隔十二行删除一行。
则删除第13行、26行。在C13,C26输入数字1,拖动单元格下拉。
选中C列,快捷键“Ctrl+G”打开定位功能,依次点击“定位”—>“数据”—>“定位”。
>免费升级到企业版,赠超大存储空间
鼠标右键选中的行,依次点击“删除”—>“整行”即可。
Keyword: 全国楼凤论坛
# Score Big Savings on Bulk Chlorine Tablets for Your Pool! When it comes to maintaining a sparkling clean pool, chlorine tablets are an essential tool in your arsenal. Not only do they keep your water crystal clear, but they also help prevent the growth of harmful bacteria and algae. However, keeping your pool in…
Levaco Chemicals, a leading supplier of specialty chemical products, announces that it has successfully completed the legal incorporation of Levaco Brasil on 1 July 2023. With the aim of expanding its international presence and entering new markets, the medium-sized company has taken the step of investing in the promising Brazilian market. The establishment of a…
本身 html Ethnic Elegance: Layered Neo-Chinese Necklace with Yellow & Black Agate Beads for Qipao and Contemporary Fashion In the world of fashion, where tradition meets modernity, the Neo-Chinese Necklace with Yellow & Black Agate Beads stands out as a stunning piece of ethnic chic jewelry. This layered necklace effortlessly blends cultural heritage with contemporary…
# Paper Cup Making Machine: Revolutionizing the Packaging Industry The packaging industry has undergone significant transformations over the years, and one of the most notable advancements is the introduction of the paper cup making machine. This innovative piece of equipment has revolutionized the way disposable cups are produced, offering a sustainable and efficient solution for…
# Monkey Mart: A Thrilling Adventure in the World of Simian Commerce Step into the bustling world of Monkey Mart, where bananas are currency, and the art of commerce is taken to new heights. This isn’t your average shopping experience; it’s a thrilling adventure that will have you swinging from the shelves and racing through…
Many parameters must be considered when setting up a job on your CNC router or plasma, especially if you hope to achieve optimal precision, quality, and efficiency. In the CNC world, the most notable group of these parameters are feeds and speeds a term generally used to refer to feed rate, cutting speed, slew rate,…