Home |
Search |
Today's Posts |
#1
|
|||
|
|||
End of File
We have XP and Office 2000 on a lovely farm in Kingston Seymour, just outside
Clevedon, North Somerset, England. In Excel I occasionally lose the bottom of the document and doing Ctrl End takes me to line 65536 or column IV. Once saved the document is huge. I have searched for any text around this area, but there is nothing there. I have deleted the columns to the right of my text and all the rows to the v v bottom of document, but cant seem to clear this. The only way is to copy the active rows and columns, paste them in a new tab, re-format etc etc and delete the tab. Is there any way of resetting the end of document to the end of my active columns and rows. Any help would be appreciated xJane |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening a file with code without a set file name | Excel Discussion (Misc queries) | |||
Opening a file with code without a set file name | Excel Discussion (Misc queries) | |||
Locating a file in excel with a partial file name. | Excel Discussion (Misc queries) | |||
Locating a file in excel with a partial file name. | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |