Copy or Move Data

Contents of a cell can be copied by two methods: one method is using the keystrokes Ctrl-C (copy) then Ctrl-V (paste), the other is by selecting Copy and Paste from the action list menu. To move data use Ctrl-X (cut) then Ctrl-V (paste) or use Cut and Paste from the list menu. The SKB will only allow text or values to be copied but only into appropriate destination field types. (Text cannot be copied into cells expecting integers).

How do I?

• Copy or move contents of a cell.

   

  1. Click in the cell to copy. (The cell's background will change to blue).

  

  2. Press CTRL+C to capture the data to copy or right click to display the action list menu then select cut to move data or copy to copy data.

  

  3. Go to the location where the data is be moved or copied. Click in the destination cell. (The cell's background color will change to blue to indicate it has been selected).

  

  Note: Text cannot be copied or moved into a cell expecting integers, but integers can be moved or copied into text fields.

  4. Press CTRL+V or right click to display action list menu then select paste.

  

  5. The cell's content is moved or copied.

  Data can be copied from excel spreadsheets. Just perform the copy steps in excel and the paste steps in the SKB.

  6. Click  to save changes.

• Copy or move a range of cells.

   

  1. Click in the upper left cell and drag to the end cell of the range to move or copy. (The background of the cells will change to blue).

  

  2. Press CTRL+C to capture the data to copy or right click to display the action list menu then select cut to move data or copy to copy data.

  

  3. Go to the location of where the data is to be moved or copied. Click the first cell (upper left corner) of where the contents are to be copied. (The background of that cell will turn blue).

  Single Cell Method:

  

   

  Same Range Method:

  

  Note: To copy into different tables, just open the associated folder and select the cell location. Text cannot be copied or moved into a cell expecting integers, but integers can be moved or copied into text fields.

  4. Press CTRL+V or right click to display the action list menu then select paste.

  

  5. The contents are copied.

  

   

  6. Click    to save changes.

• Copy or move the contents of single or multiple columns.

   

  1. Click on the column header or click and drag on the column headers to copy. (The background of the column (s) will change to blue).

  

   

  

  2. Press CTRL+C to capture the data to copy or right click to display the action list menu then select copy.

  

  3. There are two ways to choose the copy location:

  1. Click on the first column where the copy operation is to start. (The background of that column will turn blue).

  

  2. Click and drag the same number of columns captured to be copied. (The columns background will turn blue).

  

  Note: To copy into different tables, just open the associated folder and select the cell location.

  4. Press CTRL+V or right click to display the action list menu then select paste.

  

  5. The column (s) are pasted.

  

  Note: Text cannot be copied or moved into a cell expecting integers, but integers can be moved or copied into text fields.

  6. Press Enter to accept the paste.

  7. Click  to save changes.

• Copy or move the contents of single or multiple rows.

   

  1. Click on the row number or click and drag the row numbers to copy. (The background of the row (s) will change to blue).

  

   

  

  2. Press CTRL+C to capture the data to copy or right click to display an action list menu then select copy.

  

  3. There are two ways to choose the copy location:

  1. Click on the first row number where the copy is to start. (The background of that row will turn blue).

  

  2. Click and drag the same number of rows captured to be copied. (Their backgrounds will turn blue).

  

  Note: Row headers are not copied, only the data is copied.

  4. Press CTRL+V or right click to display action list menu then select paste.

  

  5. The contents are copied.

  

  Data can be copied from excel spreadsheets. Just perform the copy steps in excel and the paste steps in the SKB.

  Note: Text cannot be copied or moved into a cell expecting integers, but integers can be moved or copied into text fields.

  6. Press Enter to accept paste.

  7. Click  to save changes.

• Copy part of a cell's contents.

  To copy part of a cell contents:

  1. Double Click on the cell to copy. A cursor will appear in the cell.

  

  2. Click and drag inside the cell to highlight the content to copy. (The data to be copied will outline in blue).

  

  3. Press Ctrl-C to capture the data.

  4. Go to the destination location and click where the contents are to be copied. (The destination cell background will change to blue).

   

  Note: Text cannot be copied or moved into a cell expecting integers, but integers can be moved or copied into text fields.

   

  5. Press CTRL+V to copy the data.

  

   

  6. Press Enter to accept the copy.

   

  7. Press  to save changes.

• Copy the contents of one cell into multiple cells.

  To copy contents of a single cell to multiple cells

  1. Click on the cell to copy. (The cell's background will change to blue).

  

  2. Press CTRL+C to capture the data to copy or right click to display an action list menu and then select cut to move data or copy to copy data.

  

  3. Click and drag to highlight the destination cells. (The cell backgrounds will change to blue).

  

  Note: Text cannot be copied or moved into a cell expecting integers, but integers can be moved or copied into text fields.

   

  4. Press CTRL+V or right click to display action list menu then select Paste.

  

   

  5. The content of the source cell is copied into the destination cells.

  

  6. Press Enter to accept paste.

  7. Click  to save changes.