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
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
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.
maybe this: rows to repeat at top
https://support.office.com/en-us/art...0-cedd1fec6da3
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks