#1   Report Post  
Old October 7th 05, 05:44 PM
Stephen Howe
 
Posts: n/a
Default On deletion of rows

Hi

Say I open a spreadsheet up that has 2000 rows, 3 columns

I delete rows 100-1900 (not clear them, they really are deleted). So 200
rows left

I would expect the keystroke "Ctrl-End" to take me to cell 200C.
It does not. Instead I end up on cell 2000C.
Somehow, Excel has retained the knowledge of the old position and not
updated itself to the new end position.How do I get Excel to update its
knowledge of the bottom-rightmost cell?

Using Excel 2000, 9.0.4402, SR-1

Thanks

Stephen Howe



  #2   Report Post  
Old October 7th 05, 05:59 PM
Ken Wright
 
Posts: n/a
Default

Delete all rows/columns below and to the right of your data - then save the
file, close and reopen.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"Stephen Howe" <stephenPOINThoweATtns-globalPOINTcom wrote in message
...
Hi

Say I open a spreadsheet up that has 2000 rows, 3 columns

I delete rows 100-1900 (not clear them, they really are deleted). So 200
rows left

I would expect the keystroke "Ctrl-End" to take me to cell 200C.
It does not. Instead I end up on cell 2000C.
Somehow, Excel has retained the knowledge of the old position and not
updated itself to the new end position.How do I get Excel to update its
knowledge of the bottom-rightmost cell?

Using Excel 2000, 9.0.4402, SR-1

Thanks

Stephen Howe




  #3   Report Post  
Old October 7th 05, 06:02 PM
bj
 
Posts: n/a
Default

try saving, closing, and reopening
if you haven't reopened it, it still sees 2000 as the max row it has been to.

"Stephen Howe" wrote:

Hi

Say I open a spreadsheet up that has 2000 rows, 3 columns

I delete rows 100-1900 (not clear them, they really are deleted). So 200
rows left

I would expect the keystroke "Ctrl-End" to take me to cell 200C.
It does not. Instead I end up on cell 2000C.
Somehow, Excel has retained the knowledge of the old position and not
updated itself to the new end position.How do I get Excel to update its
knowledge of the bottom-rightmost cell?

Using Excel 2000, 9.0.4402, SR-1

Thanks

Stephen Howe





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
formula to use when number of rows changes dynamically confused Excel Worksheet Functions 3 August 17th 05 03:55 PM
Selective deletion of rows containing certain text. Colin Hayes Excel Worksheet Functions 9 June 15th 05 10:41 PM
Hiding Rows if the linked rows are blank KG Excel Discussion (Misc queries) 9 May 18th 05 02:32 AM
Deletion of rows where a value is satisfied Larry Wallis Excel Worksheet Functions 1 February 22nd 05 01:41 PM
Adding Rows to Master Sheet Excel Newbie New Users to Excel 1 December 23rd 04 11:56 PM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017