Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
VLP
 
Posts: n/a
Default How do I reset the last cell of a worksheet?

How do I reset the last cell of a worksheet to shorten the docuemnt?
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre
 
Posts: n/a
Default 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?

  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default 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
  #4   Report Post  
Posted to microsoft.public.excel.misc
askgail
 
Posts: n/a
Default 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?

  #5   Report Post  
Posted to microsoft.public.excel.misc
askgail
 
Posts: n/a
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
resetting last cell jagdish.eashwar Excel Discussion (Misc queries) 11 March 31st 06 02:06 AM
Name a worksheet tab from cell in worksheet Ken King Excel Worksheet Functions 1 March 17th 06 10:34 PM
Conversion of Cell Contents into a Functional Worksheet name ? GMJT Excel Worksheet Functions 1 August 21st 05 04:59 PM
update cell in other worksheet based... mwrfsu Excel Worksheet Functions 0 August 19th 05 05:22 PM
macro help thephoenix12 Excel Discussion (Misc queries) 4 July 15th 05 05:57 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"