limit number of rows in worksheet from 6000+ to 600

  • Thread starter Thread starter Samsky2174
  • Start date Start date
S

Samsky2174

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DGET only limited to 1000 Rows, but I need 8000 rows for DGET funt 1
How to change the number of rows in a worksheet. 2
Linking to a Variable Number of Rows - XP/07 4
Worksheet(s) open to last used row 5
How delete to end of file; comp keeps adding rows; over 3000! 1
Sum of different value in different worksheet & cell number 2
In Excel need to have a sub worksheet inserted into each row 2
Excel 2003 - Relocating an entire row of from one worksheet to ano 2

Back
Top