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.

limit number of rows in worksheet from 6000+ to 600
 

Hi,

This is happening because cells beyond 6000 may be carrying some formatting.
Therefore, go to row 601 and press Ctrl+Shift+down arrow and delete all the
rows. Do the same for columns.

This should solve your problem.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Samsky2174" wrote in message
...
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.

limit number of rows in worksheet from 6000+ to 600
 

And, be sure to SAVE your workbook when you do it.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ashish Mathur" wrote in message
...
Hi,

This is happening because cells beyond 6000 may be carrying some
formatting. Therefore, go to row 601 and press Ctrl+Shift+down arrow and
delete all the rows. Do the same for columns.

This should solve your problem.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Samsky2174" wrote in message
...
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.