Note: The other languages of the website are Google-translated. Back to English
登入  \/ 
x
or
x
註冊  \/ 
x

or

在Excel中隔隔一行插入空白行或列

一次在Microsoft Excel中插入一個空白行或列很容易。 但是,插入多個空白行或列並不容易,並且可能很難交替插入多個行或列。 但是 插入空白行和列 的工具 Kutools for Excel 可以幫助您以特定間隔快速插入多行或多列。

每隔第(n)行插入空白行

每隔(第n個)列插入空白列

Office選項卡在Office中啟用選項卡式編輯和瀏覽,並使您的工作更加輕鬆...
Kutools for Excel 解決了您的大部分問題,並將您的生產力提高了 80%
  • 重用任何東西: 將最常用或最複雜的公式,圖表等添加到您的收藏夾中,並在將來快速重用它們。
  • 超過20種文字功能: 從文本字符串中提取數字; 提取或刪除部分文字; 將數字和貨幣轉換為英文單詞。
  • 合併工具:將多個工作簿和工作表合二為一; 合併多個單元格/行/列,而不會丟失數據; 合併重複的行和總和。
  • 分割工具:根據價值將數據分割成多個工作表; 一本工作簿可轉換為多個Excel,PDF或CSV文件; 一列到多列。
  • 跳過粘貼 隱藏/過濾的行; 計數與求和 按背景色; 向多個收件人批量發送個性化電子郵件。
  • 超級過濾器: 創建高級過濾方案並應用於任何工作表; 分類 按星期,日期,頻率等 篩選 用粗體,公式,註釋...
  • 300多項強大功能; 適用於Office 2007-2019和365; 支持所有語言; 在您的企業或組織中輕鬆部署。

點擊 庫工具 > 插入 > 插入空白行和列。 看截圖:

鏡頭插入空白行列1


  每隔第(n)行插入空白行

假設您有一個範圍要每隔一行插入空白行,則可以按照以下步驟快速處理它:

1.選擇要插入空白行的範圍。

2.單擊以應用此實用程序 庫工具 > 插入 > 插入空白行和列.

3。 在裡面 插入空白行和列 對話框中選擇 空白行 插入類型,然後將數字輸入 間隔 您需要的盒子。 看截圖:

射擊插入空白行列3

4。 然後點擊 OK。 一張空白行已插入一個間隔。 查看屏幕截圖:

射擊插入空白行列4 大箭頭 射擊插入空白行列5

  每隔(第n個)列插入空白列

假設您有一系列數據,則需要每隔兩列交替插入2個空白列。 您可以這樣做:

1.突出顯示要插入空白列的範圍。

2。 在裡面 插入空白行和列 對話框,檢查 空白欄 插入類型,並在其中指定數字(2) 間隔 您需要的盒子。 看截圖:

射擊插入空白行列6

3。 然後點擊 OK。 並且每兩列以兩個間隔插入到範圍中。 看截圖:

射擊插入空白行列7


備註:

這個工具支持 復原 (按Ctrl + Z).


生產力工具推薦
以下工具可以極大地節省您的時間和金錢,哪一種適合您?
Office Tab: 在辦公室中使用方便的選項卡,作為Chrome,Firefox和New Internet Explorer的方式。
Kutools for Excel: 超過300種Excel高級功能 2019、2016、2013、2010、2007和Office 365。
Classic Menu for Office: 將熟悉的菜單帶回Office 2007、2010、2013、2016、2019和365,就好像是Office 2000和2003。

Kutools for Excel

上述功能只是Kutools for Excel的300個強大功能之一。

專為Excel(Office)2019、2016、2013、2010、2007和Office 365設計。免費下載和使用60天。

Kutools for Excel的屏幕截圖

btn了解更多      btn下載     btn購買

Say something here...
symbols left.
You are guest
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Triple T · 1 months ago
    Hello to everyone! I have the following issue:
    I have the following data:
    Column A  Column B
    1                  1
    2                  3
    3                  5
    4                  11
    5                  13

    I need a way to automatically get the values from column A and column B into another column(ie., C) which will look like following:

    Column C
    1
    1
    2
    3
    3
    5
    4
    11
    5
    13
    P.S. Every value from column A is followed by the value from column B. Each value is located on the same row!
  • To post as a guest, your comment is unpublished.
    lalitkumarsaini013 · 1 months ago
    आपके द्वारा यहां साझा किया गया लेख शानदार है क्योंकि यह कुछ उत्कृष्ट जानकारी प्रदान करता है जो मेरे लिए अविश्वसनीय रूप से फायदेमंद होगी। इसे साझा करने के लिए धन्यवाद।
  • To post as a guest, your comment is unpublished.
    clarkmegan135 · 2 months ago
    Brockville Real Estate - How To Find Real Estate Property In Brockville

    https://dalemundi.com/ontario/brockville/

    Brockville is the location in Ontario, and also this place has many beautiful and delightful buildings. Along with this, the beautiful view will attract you to this place. Get Brockville Real Estate properties by visiting Dalemundi.com. Here, you can find Brockville Real Estate properties with prices and descriptions. You can also email dalemundi@realestatehut.com for more information. 
  • To post as a guest, your comment is unpublished.
    Valendrakumar Mistry · 3 months ago
    Insert row based on cell value
  • To post as a guest, your comment is unpublished.
    farmtrac 3600 · 1 years ago
    Hi, I appreciate your quality stuff, we look forward to some interesting posts like this!
  • To post as a guest, your comment is unpublished.
    JoelD · 2 years ago
    Hi, I've found the "distinguish differences" feature doesn't always work when the differences come one cell after another e.g.

    A
    B
    C
    D
    D
    D
    E
    E
    E
    F
    G
    H
    H
    H

    It won't spot the differences in A B C and G in the example above. Lines will be inserted after D and E only.
  • To post as a guest, your comment is unpublished.
    rithurawat · 2 years ago
    Very nice post here thanks for it .I always like and such a super contents of these post.Excellent and very cool idea and great content of different kinds of the valuable information's.

    Machine learning training in chennai
    machine learning certification in chennai
  • To post as a guest, your comment is unpublished.
    kavi · 2 years ago
    Such a Great Article!! I learned something new from your blog. Amazing stuff. I would like to follow your blog frequently. Keep Rocking!!
    Blue Prism training in chennai | Best Blue Prism Training Institute in Chennai
  • To post as a guest, your comment is unpublished.
    ganes · 6 years ago
    Sangat bermanfaat sekali
    thankyu