Excel - Line Every

Last updated: 2022-08-30

Overview

This tool places a bottom line border every X number of rows for the selected range.

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 add a bottom row border every X lines.
2. In the box next to the Line Every button, enter the number of rows to space the placement of the bottom border line.
   1. If the last row of the selected range should also include a bottom border, check the Include Last box .
3. WisDOT Civil 3D Tab > Formatting panel > Line Every
4. A bottom border will be placed every X rows, starting the count from the first row in the selection. All previously placed border formatting will be removed from the selected range.