Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
why excel sometimes goes to maximum row?
I have 2 xls, I have named them big and small.
They contain the same information but the size is very different for example the big file is 2,128K the small file is only 40K When I open the big file, and hit the end <CTRL and END key, it goes to row 66529, the small file is row 36. Actual row with input information is only 36. the rest are blanks. In the small xls, all I did was delete the unused lines from the big xls. Is there any function in xls than can remove these unused rows? In what scenario does xls goes into the last cell of the page? how can this be avoided. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
why excel sometimes goes to maximum row?
Hi MW,
Take a look here, http://www.contextures.com/xlfaqApp.html#Unused HTH Martin "MW" wrote in message ... I have 2 xls, I have named them big and small. They contain the same information but the size is very different for example the big file is 2,128K the small file is only 40K When I open the big file, and hit the end <CTRL and END key, it goes to row 66529, the small file is row 36. Actual row with input information is only 36. the rest are blanks. In the small xls, all I did was delete the unused lines from the big xls. Is there any function in xls than can remove these unused rows? In what scenario does xls goes into the last cell of the page? how can this be avoided. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
why excel sometimes goes to maximum row?
I have read alot of discussion on file size - and also tried out the macro
from http://www.contextures.on.ca/xlfaqApp.html#Unused are they any tools that can scan existing xls in a folder and remove the unused rows automatically? or perhaps when we attached the xls in an email? or something that would prompt the user upon saving the xls to delete away these unused rows? "MW" wrote: I have 2 xls, I have named them big and small. They contain the same information but the size is very different for example the big file is 2,128K the small file is only 40K When I open the big file, and hit the end <CTRL and END key, it goes to row 66529, the small file is row 36. Actual row with input information is only 36. the rest are blanks. In the small xls, all I did was delete the unused lines from the big xls. Is there any function in xls than can remove these unused rows? In what scenario does xls goes into the last cell of the page? how can this be avoided. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
why excel sometimes goes to maximum row?
Hi MW,
are they any tools that can scan existing xls in a folder and remove the unused rows automatically? or perhaps when we attached the xls in an email? I haven't heard of them, but that means little, maybe try in the programming group. or something that would prompt the user upon saving the xls to delete away these unused rows? That's just proper staff training. (not meant to sound flippant) Sorry I can't be more helpful. Martin "MW" wrote in message ... I have read alot of discussion on file size - and also tried out the macro from http://www.contextures.on.ca/xlfaqApp.html#Unused are they any tools that can scan existing xls in a folder and remove the unused rows automatically? or perhaps when we attached the xls in an email? or something that would prompt the user upon saving the xls to delete away these unused rows? "MW" wrote: I have 2 xls, I have named them big and small. They contain the same information but the size is very different for example the big file is 2,128K the small file is only 40K When I open the big file, and hit the end <CTRL and END key, it goes to row 66529, the small file is row 36. Actual row with input information is only 36. the rest are blanks. In the small xls, all I did was delete the unused lines from the big xls. Is there any function in xls than can remove these unused rows? In what scenario does xls goes into the last cell of the page? how can this be avoided. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maximum Rows in Excel... | Excel Discussion (Misc queries) | |||
Excel should have 200,000 rows maximum | Setting up and Configuration of Excel | |||
Excel Maximum size ? | Excel Discussion (Misc queries) | |||
what is maximum row length in excel | Excel Discussion (Misc queries) | |||
Maximum no of rows in Excel | Excel Worksheet Functions |