How To Stop Excel Adding Rows. A workaround could be to add a second header row that, for the cells with long texts only displays the last 30 characters or so. Press alt + f11 to open a microsoft visual basic for application window.

Step 1, locate the excel file that you need to work on. Not the answer you're looking for? Hide the first header row and freeze row 2.