【EXCEL】快速增加空行？

(adsbygoogle = window.adsbygoogle || []).push({});

⬛ 問題：EXCEL 快速增加空行？

EXCEL如何快速增加空行？方法有二

<div class="jane_bar" style="margin: auto auto 35px; padding: 10px; border-width: 0px 0px 0px 5px; border-style: solid dotted dotted solid; border-color:gray gray gray rgb(0, 82, 240); border-image: initial; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; line-height: 50px; vertical-align: baseline; letter-spacing: 1px; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; border-radius: 0px; background-color: rgb(235, 242, 255); box-sizing: border-box; text-align: center; "> EXCEL 快速增加空行：方法一

▼步驟一、用滑鼠選擇資料的區域

▼步驟二、① 按「Shift」並將滑鼠移到選取區域的下方。

② 滑鼠往下拉，即可產生空行。要增加幾行，滑鼠就拉幾行。

(adsbygoogle = window.adsbygoogle || []).push({});

<div class="jane_bar" style="margin: auto auto 35px; padding: 10px; border-width: 0px 0px 0px 5px; border-style: solid dotted dotted solid; border-color:gray gray gray rgb(0, 82, 240); border-image: initial; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; line-height: 50px; vertical-align: baseline; letter-spacing: 1px; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; border-radius: 0px; background-color: rgb(235, 242, 255); box-sizing: border-box; text-align: center; "> EXCEL 快速增加空行：方法二

▼步驟一、用滑鼠選擇「整行」。要增加幾行就選擇幾行。

▼步驟二、按「Ctrl + +」即可新增空行。按幾次，即增加幾次。

隨手記錄

【EXCEL】快速增加空行？

延伸閱讀

廣告一