How do I limit the number of rows in an Excel worksheet.
Rather than over 65,000 rows being available when I open a new worksheet, how
can I limit the number of rows to, say, 200 without having to highlight rows 200 through 65,000 and hide them? |
You cannot do away with the unused rows or columns. A worksheet has 256
columns and 65536 rows. You can hide the rows and columns you don't want to see. Select them and FormatHide. You already knew that<g Alternative.........You may want to try setting the Scroll Area. This setting will not remain after closing the file. Place a code line in the Workbook open event to set it each time when you open the workbook. Right-click on the Excel Logo left of your "File" on menu. Select "View Code" and paste the following in there. Save the workbook and close/re-open to see the scrollarea fixed to the range A1:Y200 Private Sub Workbook_Open() Sheets("Sheet1").ScrollArea = "A1:Y200" End Sub Adjust to your sheetname and range. Gord Dibben Excel MVP On Wed, 3 Nov 2004 16:49:02 -0800, laforge27 wrote: Rather than over 65,000 rows being available when I open a new worksheet, how can I limit the number of rows to, say, 200 without having to highlight rows 200 through 65,000 and hide them? |
All times are GMT +1. The time now is 10:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com