Shulou(Shulou.com)11/24 Report--

The original title: "Boss: you can't even insert blank lines in bulk, but you still want a raise?" "

Hello, everyone! I have been seriously messing with Excel's Yali recently.

Let me ask you a little question:

If your boss asks you to insert blank lines according to different requirements, can you finish the task quickly and well?

Today's trick to share, pear will take you to learn about the different operations of inserting blank lines in Excel.

1. Insert a blank line at will ❶ first select a row (you can select it as needed), then press and hold the [Shift] key and place the mouse in the lower right corner to make it the "equal sign"

❷ then drag down, blank lines will come out in batches, and will not affect the table next to yo ~

2. Insert a blank row every 2 rows ❶ first enter a secondary serial number "1" in the D2 cell, then select two cells and drag to the bottom of the table

❷, press "Ctrl+G"-"location condition"-"constant", and click "OK"

❸ right-click, select insert "whole row", and click "OK".

So it's done.

3, no rules to insert blank lines, such as the following figure, you need to add a blank line after each department.

❶ first creates an auxiliary column on the right side of "departments", misplaces a row next to it, and copies and pastes all departments.

❷ then select this area, press "Ctrl+G"-"location condition"-"Line content difference Cell", and click "OK"

Finally, ❸ right-click to insert "whole row" and click "OK".

Well, have you learned all the three tips for inserting blank lines shared today?

This article comes from the official account of Wechat: Akiba Excel (ID:excel100), author: Yalizi

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.