ExcelBanter - excel 2000 worksheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - excel 2000 worksheet (https://www.excelbanter.com/excel-worksheet-functions/65638-excel-2000-worksheet.html)

Donna 12589

excel 2000 worksheet

In a workbook with multiple sheets one sheet says it is 84 pages long but
there is only 1 page of data. What is causing that?

dalymjl

Quote:

Originally Posted by Donna 12589

In a workbook with multiple sheets one sheet says it is 84 pages long but
there is only 1 page of data. What is causing that?

I'd say there is a value in one of the cells way down the sheet. Try selecting all the rows beneath your one page of data and press "delete". You'll probably need to scrool down several hundred rows to be sure you've selected the mischevious cell.

All times are GMT +1. The time now is 10:37 PM.