Excel - Repeat Selection Every

Last updated: 2022-10-31

Overview

This tool inserts the selected range every X number of rows. The replications reference back to the original range so changes to the original are reflected to each instance.

Usage

The WisDOT Excel Add-In must be installed prior to running the tool.

1. In Excel, select the range of cells you wish to insert every X lines.
2. In the box next to Repeat Selection Every , enter the number of rows to insert the selected range.
3. WisDOT Civil 3D Tab > Formatting panel > Repeat Selection Every
4. The selected range will be inserted every X rows, starting the count from the last row in the selection.