+ Reply to Thread
Results 1 to 3 of 3

Insert Interval Title Rows Into A Range In Excel

  1. #1
    Registered User
    Join Date
    09-26-2017
    Location
    Singapore
    MS-Off Ver
    2013 mac
    Posts
    2

    Insert Interval Title Rows Into A Range In Excel

    Hi, how do i insert a title row in interval (say about a title row in every 20 interval rows) into an existing data sheet. Please help. Thank you

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Insert Interval Title Rows Into A Range In Excel

    One way would be to number all the rows in a helper column, say 1-nnn, then add as many new title rows as you need and number their rows 20.1, 40.1, 60.1...etc. Then select everything and sort using the helper column as the key.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Insert Interval Title Rows Into A Range In Excel

    maybe this: rows to repeat at top
    https://support.office.com/en-us/art...0-cedd1fec6da3

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Can Excel automatically insert the column header as the axis title?
    By galaxytraveler42 in forum Excel Charting & Pivots
    Replies: 11
    Last Post: 09-20-2013, 06:17 AM
  2. deleting rows with interval (dynamic range)
    By flunzy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-23-2013, 08:24 AM
  3. loop through rows for match insert blank rows with title
    By reeyu in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-27-2012, 07:34 AM
  4. [SOLVED] Insert Rows In Range - Excel 2010
    By amonty78 in forum Excel General
    Replies: 2
    Last Post: 05-30-2012, 10:06 AM
  5. Replies: 2
    Last Post: 07-21-2006, 05:10 AM
  6. How to insert superscripted value in Y-axis title of excel sheet
    By kapatia in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 06-18-2006, 03:20 PM
  7. [SOLVED] Excel macro to insert blank rows at a ever-changing interval
    By KnightRiderAW in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-12-2006, 02:55 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1