ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   End of File (https://www.excelbanter.com/excel-discussion-misc-queries/37485-end-file.html)

Jane at Amitec

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

Roger Govier

Hi Jane
Well, here on a rainy day on a farm on the banks of the River Usk,
Monmouthshire ........
try taking a look at
http://www.contextures.com/xlfaqApp.html#Unused


--
Regards
Roger Govier
"Jane at Amitec" <Jane at wrote in message
...
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 can't 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





All times are GMT +1. The time now is 08:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com