Limit the size of the spreadsheet
Posted by Ian on November 17, 2001 12:36 AM
Hi, this is probably a simple task for you guys but it is driving me mad, I hope someone can help.
I have just transfered to Excel from Lotus 123, so am new to this, hence the question.
I have a spreadsheet, showing 365 days, in order to record holidays and sickness. When scolling down the spreadsheet, it goes beyond row 365, in fact right down to 65000 (ish). I have tried to delete the rows after 365, I've tried hiding them (big mistake).
My question is, how do I limit the spreadsheet to the number of rows I need?