Export From Grids Lesson


In this lesson  you will learn how to export data from a grid.


Steps:

  1. To demonstrate how to export from a grid we will use the Address Book Inquiry screen.  The principles in this lesson, however, apply throughout the system.

    Step 1
  2. Click the State of Nebraska link.

    Step 2
  3. Click the Address Book link.

    Step 3
  4. Click the Address Book Inquiry link.

    Step 4
  5. Click the Find button.

    Step 5
  6. The grid populates with information, and this information is what we will export.

    Step 6
  7. Click the Tools button.

    Step 7
  8. Click the Export Grid Data menu.

    Step 8
  9. In the Export Options window you can choose which type of document you would like to export to. 

     

    In this lesson we will be exporting to a new Excel Workbook.

    Step 9
  10. The Define Cell Range window allows you to dictate what information from the grid you want to export (either all the information or a specific range).  In this lesson we are going to select a specific range.

    Step 10
  11. Click the Range option.

    Step 11
  12. Click the A1 cell.

    Step 12
  13. Click the F9 cell.

    Step 13
  14. The cells populate in the Starting Cell and Ending Cell ranges.

    Step 14
  15. Click the Continue button.

    Step 15
  16. An Excel document opens with the exported data which you can sort and filter.  You can also save this file to your computer.

    Step 16

You have successfully completed this lesson.

Table of Contents  Start Topic