ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Unable To Reset Extents Of Spreadsheet (https://www.excelbanter.com/excel-discussion-misc-queries/75801-unable-reset-extents-spreadsheet.html)

SteveG

Unable To Reset Extents Of Spreadsheet
 
I have a spreadsheet with a number of sheets in it that I am unable to
resent the last used field in. If I press END-Home it takes me to
BW/65536 where the last used field is BW/101. Any ideas on how to fix
this would be appreciated.

I can send the file to anyone who is willing to help fix this.

Steve


Dave Peterson

Unable To Reset Extents Of Spreadsheet
 
Debra Dalgleish shows techniques to reset that last used cell:
http://contextures.com/xlfaqApp.html#Unused

SteveG wrote:

I have a spreadsheet with a number of sheets in it that I am unable to
resent the last used field in. If I press END-Home it takes me to
BW/65536 where the last used field is BW/101. Any ideas on how to fix
this would be appreciated.

I can send the file to anyone who is willing to help fix this.

Steve


--

Dave Peterson


All times are GMT +1. The time now is 05:03 PM.

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