How to Move Through Records in the Data Form in Excel 2013

Excel 2013 allows you to move through the records you have created in the data form. You can use the scroll bar to the right of the list of field names or various keystrokes to move through the records in the database until you find the one you want to edit or delete.

  • To move to the data form for the next record in the data list: Press ↓, press Enter, or click the down scroll arrow at the bottom of the scroll bar.

  • To move to the data form for the previous record in the data list: Press ↑, press Shift+Enter, or click the up scroll arrow at the top of the scroll bar.

  • To move to the data form for the first record in the data list: Press Ctrl+↑, press Ctrl+PgUp, or drag the scroll box to the very top of the scroll bar.

  • To move to a new data form immediately following the last record in the database: Press Ctrl+↓, press Ctrl+PgDn, or drag the scroll box to the very bottom of the scroll bar.

    Keystrokes or Scroll Bar Technique Result
    Press ↓ or Enter or click the down scroll arrow or the Find Next button Moves to the next record in the data list and leaves the same field selected
    Press ↑ or Shift+Enter or click the up scroll arrow or the Find Prev button Moves to the previous record in the data list and leaves the same field selected
    Press PgDn Moves forward ten records in the data list
    Press PgUp Moves backward ten records in the data list
    Press Ctrl+↑ or Ctrl+PgUp or drag the scroll box to the top of the scroll bar Moves to the first record in the data list
    Drag the scroll box to almost the bottom of the scroll bar Moves to the last record in the data list
blog comments powered by Disqus
Advertisement

Inside Dummies.com