Worksheet Shortcuts

MIMIC includes several Worksheet shortcuts. Users can copy and paste rows using keyboard shortcuts, or use the Worksheet right-click menu to copy, paste, insert or delete a row. Users can also reposition rows using keyboard shortcuts, and synchronize the Column and Time Unit columns.

Copy/Paste Options, Right-Click Menu and Repositioning Rows

MIMIC users can use either the keyboard or the right-click menu to copy and paste a row. Users can also use the right-click menu to insert or delete a row.

  • To copy/paste a Worksheet row using keyboard shortcuts, users select a row, and select Ctrl+C from the keyboard to copy, and then Ctrl+V to paste the row. The row pastes below the selected row.

  • To copy/paste a Worksheet row using the right-click menu, users select a row, right-click and select Copy, and then right-click again and select Paste. The row pastes below the selected row.

  • To insert or delete a row using the right-click menu, users select a row, then right-click and select Insert or Delete. MIMIC inserts a new row above the selected row.

    Users can also insert or delete a row by clicking the Insert Row button or the Remove Row button on the Worksheet toolbar.

  • To reposition or re-order a row, users can select any cell within the row, and then use the Ctrl + the Up Arrow/Down Arrow to move the row accordingly.

Synchronization of Columns and Time Units

Symbols may contain different Column and Time Units entries. Users can set or synchronize all rows in a worksheet to have the same Column or Time Units entries.

Users can only synchronize the Column and Time Units entries in MIMIC.

For example, a worksheet contains symbol and information for HO (row 'A') and for NG (row 'B'). The Time Units for HO are set to Daily and the Time Units for NG are set to Weekly. In this example, users can set or synchronize the Time Units entries to Daily or Weekly for both Worksheet rows.

  • To synchronize the Column entry, in a Worksheet column, select the Column entry, then right-click and select Set all Columns to X, where X represents the setting, such as Close or Bar.

  • To synchronize the Time Units entry, in a Worksheet column, select the Time Units entry, then right-click and select Set all Time Units to X, where X represents the setting, such as Daily or Weekly.

  • To synchronize the Chart Type entry, in a Worksheet column, select the Chart Type entry, then right-click and select Set all Chart Types to X, where X represents the setting, such as Line or Bar.