updated row comes at the top

Is there any way to get the update rows (on the same sheet, which consist of
over one thousand lines of data) at the top? For instant, if I add a comment
on line 561, save & close it and if re-open it, that row 561 pop up at the
top?
Any help will be highly appreciated.
Thanks

--
Message posted via http://www.officekb.com

Why not setup a button to insert a new Row 2, and add your data to the row you need it to be?

Rows cannot appear out of sequence, the 561st row is the 561st row, it cannot appear first.

--

Originally Posted by Fam via OfficeKB.com

Is there any way to get the update rows (on the same sheet, which consist of
over one thousand lines of data) at the top? For instant, if I add a comment
on line 561, save & close it and if re-open it, that row 561 pop up at the
top?
Any help will be highly appreciated.
Thanks

--
Message posted via http://www.officekb.com

Wherever your cursor is on that worksheet when you save the file (say at the bottom of the data) is where the worksheet opens next time.

If you press Ctrl & End together (and then hold down Ctrl and the required arrow keys if necessary), you should navigate to the last entry very quickly