When I go to print one of the worksheets in my workbook Excel is detecting 1,726 pages (through the bottom of the sheet, i'm assuming). Now, the cell borders have been manually turned on (instead of opting to "print gridlines"), because I need to have one of my column borders hidden (turning 2 of the columns into a visual single column, but 2 for sort purposes). Additionally, I have data validation in a couple of the columns on the sheet. Otherwise, I can think of nothing that would be forcing the cell population all the way down the sheet (there are 2 pages worth of data, populated).
I've tried selecting all rows to the bottom of the sheet and clearing contents. I've played with different worksheets in the same workbook and don't seem to be having the same issue in other sheets. If I turn off the cell lines, only two pages of data are detected. When I turn those lines back on I've got 1,000+ again.
Any thoughts on the soure of this problem and how to overcome it?
Thank you!
elise
I've tried selecting all rows to the bottom of the sheet and clearing contents. I've played with different worksheets in the same workbook and don't seem to be having the same issue in other sheets. If I turn off the cell lines, only two pages of data are detected. When I turn those lines back on I've got 1,000+ again.
Any thoughts on the soure of this problem and how to overcome it?
Thank you!
elise