vertical gap in excel
Posted on 2015-01-06
I have a report that is generated automatically and is imported into excel or exported from a database into excel, but either way, it has about 40 columns of data. When it is opened in Excel 2013, there is a gap. all columns AA thru AZ are blank and it picks up after column Z with column BA. is there a setting within Excel that will prevent this “vertical page break” when the number of columns imported exceed 26? After filling columns A thru Z, it skips over the AA-AZ columns and picks up at BA with the remaining columns.