| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to limit number of rows and column in worksheet? | Excel Discussion (Misc queries) | |||
| is there a limit to the number of rows a worksheet can have? | Excel Discussion (Misc queries) | |||
| How do I limit the number of rows displayed on a worksheet? | Excel Discussion (Misc queries) | |||
| Is there a limit to the number of rows that can be filtered | Excel Worksheet Functions | |||
| How do I limit the number of rows in an Excel worksheet. | Excel Worksheet Functions | |||
Hybrid Mode
