Excel 2013 For Dummies
Book image
Explore Book Buy On Amazon

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

About This Article

This article is from the book:

About the book author:

Greg Harvey, PhD, is President of Mind Over Media, an online media company. He has written all editions of Excel For Dummies, Excel All-in-One For Dummies, and Excel Workbook For Dummies. Greg is an experienced educator with a wide variety of interests.

This article can be found in the category: