Re: moving to end of sheet

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Debra Dalgleish (dsd_at_contexturesXSPAM.com)
Date: 02/07/04 

Date: Fri, 06 Feb 2004 21:52:51 -0500

There are instructions here for resetting the used range:

   http://www.contextures.com/xlfaqApp.html#Unused

Rick wrote:
> I know that "ctrl-end" should take me to the end of a
> work***. Sometimes, however, it takes me beyond the
> last row where data is entered, sometimes many blank rows
> beyond. I've tried deleting those blank rows, making sure
> there is nothing hidden inthose rows, no conditional
> formatting, etc., but that doesn't work. If I cut and
> paste the rows with data into a new ***, that works
> (i.e., "ctrl-end" takes me to the last cell with data in
> it). Is there a way to do this without the cut and paste
> workaround? Thanks. 

-- 
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
Quantcast