Mystillery Lab Report 3 |
Copy Medical Examiner data to your own spreadsheet
You can easily copy your Medical Examiner clipboard to a spreadsheet of your own, which you can then sort any way you like for a reading log.Alternate method
- Open your Medical Examiner clipboard.
- Click the left-most cell of the top entry - this will be an author name.
- Hold the SHIFT key and click the right-most cell of the bottom line - the Toe Tag count. This should select the entire table.
- COPY the table to your computer's clipboard.
- Open your own spreadsheet, either your own file or a Google sheet works.
- Click the upper left cell.
- PASTE. This should paste the entire contents into individual cells.
- If the PASTE operation just squished everything into that one cell, use the alternate method below.
- Open your Medical Examiner clipboard.
- Count the rows/columns of data in the Medical Examiner clipboard.
- Click the left-most cell of the top entry - this will be an author name.
- Hold the SHIFT key and click the right-most cell of the bottom line - the Toe Tag count. This should select the entire table.
- COPY the table to your computer's clipboard.
- Open your own spreadsheet, either your own file or a Google sheet works.
- Click the upper left cell.
- Hold the SHIFT key and click the bottom right cell of the identical range, using your row/column count. This should select the entire empty range.
- PASTE. This should paste the entire contents into individual cells.