LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default limit number of rows in worksheet from 6000+ to 600

The worksheet i am working with has over 6000 rows.. I need it to be about
600, but deleting them doesn't work; it goes on to infinity. how do I limit
the number of rows in the worksheet permanently? it's annoying becausethe
scroll bar is super tiny and all of my information is at the top.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to limit number of rows and column in worksheet? Hrishi Excel Discussion (Misc queries) 1 June 6th 07 01:36 PM
is there a limit to the number of rows a worksheet can have? Debi Excel Discussion (Misc queries) 2 May 22nd 06 02:47 PM
How do I limit the number of rows displayed on a worksheet? cms31 Excel Discussion (Misc queries) 4 December 8th 05 06:20 PM
Is there a limit to the number of rows that can be filtered W Paul Excel Worksheet Functions 3 March 8th 05 03:41 AM
How do I limit the number of rows in an Excel worksheet. laforge27 Excel Worksheet Functions 1 November 4th 04 01:42 AM


All times are GMT +1. The time now is 08:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"