Select a specific Row

  • Thread starter Thread starter elaine
  • Start date Start date
E

elaine

Hello,

Does anyone knows how I could select/jump to a specific row?

ie. I just open a file contains more than 5000th row of data, and i
would like to jump to the 700th row, is there a way to do that?

Thanks.
Elaine.
 
Press the F5 key (or Edit | GoTo) then enter A700 in the box and click
OK.

Pressing the <Page Down> key can also move you more quickly down the
sheet, rather than <down-arrow> or scrolling.

Hope this helps.

Pete
 
Type the name of the cell to jump to in the "name box" next to the
formula bar (e.g. A700)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word VBA for deleting Selected Row 0
Excel Help to copy information from one row at a time to another sheet 1
Inserting a Copied Row inside a table 6
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Excel JUMP FROM SEARCH BAR TO RESULT 3
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Filter out rows based on the value of a cell 4
Open and Jum to specific cell 6

Back
Top