Using lists in Microsoft Office Live Workspace, you can easily set up a row and column format that meets your needs. This article provides instructions for navigating through a list, as well as for cutting, copying, and pasting text in a list.
Navigate from cell to cell in a list
To quickly navigate to a cell that you want to modify, use the arrow keys. Or press TAB on your keyboard to move your cursor through each cell in a row from left to right. If the cursor is in the last cell in a row, press TAB to move it to the first cell in the next row of your list. To move your cursor through each cell in a row from right to left, press SHIFT + TAB.
For additional keyboard shortcuts for lists, see the Accessibility article.
Remove or restore text in a cell
-
In Office Live Workspace, navigate to the list that you want to modify.
-
Select the text in the cell that you want to modify. On the toolbar, click Cut
, or press CTRL+X. Your selected text is removed from the cell and added to the clipboard.
-
To restore the text, place your cursor where you want to add the text. On the toolbar click Paste
, or press CTRL+V.
Copy and paste text within a list
To copy and paste text in a row or a column:
-
In Office Live Workspace, navigate to the list that contains the text that you want to copy.
-
To select text in a row, click the far left cell in the row that you want to copy. To select multiple rows, press CTRL and select the far left cell in each row that you want to copy.
-
To select text in a column, place your cursor above the top cell in the column that you want to copy, and click the four-tipped arrow that appears. To select multiple columns, press CTRL and click the four-tipped arrow for each column that you want to copy.
-
On the toolbar, click Copy, or press CTRL+C to copy the selected row or column.
-
On the toolbar, click Paste
, or press CTRL+V. Pasted row text appears in a new row at the bottom of the list. Pasted column text appears in a new column to the far right of the list.
Copy text in a list and paste it to another document
-
In Office Live Workspace, navigate to the list containing the content that you want to copy.
-
To select a row, click the far left cell in the row that you want to copy. To select multiple rows, press CTRL and select the far left cell in each row that you want to copy.
-
To select a column, place your cursor above the top cell in the column that you want to copy, and click the four-tipped arrow that appears. To select multiple columns, press CTRL and click the four-tipped arrow for each column that you want to copy.
-
On the toolbar, click Copy, or press CTRL+C to copy the selected row or column.
-
Place your cursor in another document where you want to add the text from your list. Press CTRL+V to paste the selected text.
You can also export your entire list to a Microsoft Office Excel spreadsheet. To learn more, see Export list content to an Excel spreadsheet.
Copy text from another document and paste it into a list
You can save yourself time by copying data from another document into your list.
-
In the document, select the text that you want to copy, right-click, and then click Copy. Alternatively, press CTRL+C.
-
In Office Live Workspace, in the list that you want to modify, do one of the following:
-
To add your copied text to a cell in the list, select the cell and click Paste, or press CTRL+V. The pasted text appears in the selected cell.
-
To add your copied text to a row in the list, click Paste, or press CTRL+V. Pasted text from another document always appears in the last row of the list, even if you have selected another row.
-
To add your copied text to a column in the list, select a column by placing your cursor above the top cell of a column, and click on the four-tipped arrow that appears. Press CTRL+V. Pasted text from another document always appears to the far right of the list, even if you have another column location selected.
Note: You can only insert data into a list that is of the same data type that was originally specified for that column in the list. For example, you cannot insert text into a column in a list that is set up with a data type for numbers or dates. For more information about setting up column data types, see Add or modify columns in a list.
Undo and repeat your last action
If you change your mind about adding or deleting text in your list, you can undo your action. Immediately after you make a change that you want to undo, on the toolbar, click Undo
, or press CTRL+Z. Your last action is reversed.
If you want to repeat your last action, on the toolbar click Repeat
, or press CTRL+Y. Your last action is repeated.
Note: You cannot use the Undo or Repeat buttons after you have added or deleted columns, changed the data type for a column, or sorted, resized, or changed the order of columns.