ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I reset the last cell of a worksheet? (https://www.excelbanter.com/excel-discussion-misc-queries/83736-how-do-i-reset-last-cell-worksheet.html)

VLP

How do I reset the last cell of a worksheet?
 
How do I reset the last cell of a worksheet to shorten the docuemnt?

Ron Coderre

How do I reset the last cell of a worksheet?
 
Generally, you must delete the unwanted rows and/or columns and save the
workbook. (On older Excel versions you may also need to close/reopen)

Here are more specific instructions:
http://www.contextures.com/xlfaqApp.html#Unused

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"VLP" wrote:

How do I reset the last cell of a worksheet to shorten the docuemnt?


Dave Peterson

How do I reset the last cell of a worksheet?
 
Debra Dalgleish shows techniques to reset that last used cell:
http://contextures.com/xlfaqApp.html#Unused

VLP wrote:

How do I reset the last cell of a worksheet to shorten the docuemnt?


--

Dave Peterson

askgail

How do I reset the last cell of a worksheet?
 
Ron, thank you so much, I have been trying to figure this out forever!
--
thanks,
askgail


"Ron Coderre" wrote:

Generally, you must delete the unwanted rows and/or columns and save the
workbook. (On older Excel versions you may also need to close/reopen)

Here are more specific instructions:
http://www.contextures.com/xlfaqApp.html#Unused

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"VLP" wrote:

How do I reset the last cell of a worksheet to shorten the docuemnt?


askgail

How do I reset the last cell of a worksheet?
 
Thanks, this group is a great source.
--
thanks,
askgail


"Dave Peterson" wrote:

Debra Dalgleish shows techniques to reset that last used cell:
http://contextures.com/xlfaqApp.html#Unused

VLP wrote:

How do I reset the last cell of a worksheet to shorten the docuemnt?


--

Dave Peterson



All times are GMT +1. The time now is 07:38 PM.

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