Easy Excel 2003 question that I'm having a hard time trying to figure out (SEMI-SOLVED)

[her209]

Say in Excel, you create fill a worksheet with 1000 rows, 2 columns of data. Place the cursor at cell A1. If you press Ctrl+End, it takes you to the bottom of the list, cell B1000. Now lets say you clear the bottom 500 rows of data by highlighting the 500 rows and right-clicking and selecting Clear Contents. Now if you put the cursor again at the A1 and press Ctrl+End again, it still takes you to cell B1000.

How do you set it so that Excel knows the bottom of the list is B500?

Grrr...

 

[IHateMyJob2004]

Warning: You are using a Microsoft program.

You might have to delete the cells entirely by highlight rows 501-1000, right clicking and then deleting them.

You might not have saved your file. That might do it. And if it doesn't do it, close excel and reload the file. See what happens.

 

[her209]

Originally posted by: IHateMyJob2004
Warning: You are using a Microsoft program.

You might have to delete the cells entirely by highlight rows 501-1000, right clicking and then deleting them.

You might not have saved your file. That might do it. And if it doesn't do it, close excel and reload the file. See what happens.

The delete does nothing for me also.

 

[her209]

Hmmm, this is interesting... I saved the file and reopened it and it now knows where the bottom is.

Grrr... damn Microsoft.