Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula to use when number of rows changes dynamically | Excel Worksheet Functions | |||
Selective deletion of rows containing certain text. | Excel Worksheet Functions | |||
Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
Deletion of rows where a value is satisfied | Excel Worksheet Functions | |||
Adding Rows to Master Sheet | New Users to Excel |