79 Grid Alignment

From KiwiCodes-wiki
Jump to: navigation, search


Welcome to this demonstration on Bonus Tools – 79 Grid Alignment. This tool allows you to bulk align Grid 2D extents between Views.

  1. To run the tool, navigate to the Bonus Tools Tab and select Grid Alignment.
  2. Sheet and View Manipulation

    79 Grid Alignment

  3. The Grid Alignment dialog will appear.
  4. 79 Grid Alignment

    Note: The dialog when opened will display all the saved From and To View maps within the grid; at the bottom right is the total count in the grid. Within grid you can see the From View, To View and Select.

  5. Click Add to add a Row.
  6. You add Rows and map between From Views and To Views.


    From View To View

  7. Select a From View.
  8. 79 Grid Alignment

  9. Select a To View.
  10. 79 Grid Alignment

  11. Add as many Rows as you want.
  12. 79 Grid Alignment

  13. You select the Rows and click the Delete Selected or Updated Selected button.
    1. To select the Rows you can either; tick the check boxes individually or highlight the rows using standard mouse drag and control key operations and click Select Selected button.
    2. Note: the Total selected is updating.

    3. or click Select All button to select all Rows in the grid.
    4. or click Select None button to deselect all Rows.
  14. Click Update Selected.
  15. 79 Grid Alignment

  16. Two dialogs will appear, one with the overall results and another with a break-down.
  17. 79 Grid Alignment

  18. Grid Alignment also allow you to Export the Grid to a CSV file to bulk add Rows, then Import from Excel to load the Rows into the Grid.
  19. Export to Excel

Thank you for viewing this demonstration on Bonus Tools - Grid Alignment.