Moving cell values in a worksheet

Use the pointer to select a horizontal or vertical range of cells in a worksheet.

Select Cut, Copy, Paste from the right-click menu, Edit menu, or in the toolbar.

Cut moves the values in the cells to the clipboard.

Copy copies the values in the cells to the clipboard.

Paste pastes the values in the clipboard into cells, starting with the currently selected cell.

Or move the cursor over the lower right corner of the selected block of cells and, when the cursor changes to a four-arrow sign, drag the block of cells to the new location.

Editing data values in worksheets

Click in a cell and edit the content directly in the cell or in the field above the worksheet.

If you want the same value in multiple adjacent cells, enter that value in the first cell and then drag the lower right corner of the selection box until the block of desired cells is selected. When you release the mouse button all of the selected cells will have the entered value.

Note:If you are unexpectedly unable to edit a cell value, try double-clicking in the cell or selecting the cell and then using the field above the worksheet to enter the data.

Replacing a cell value with a new value

Select Edit > Replace.

In the Find field, type the text or number to be replaced.

In the Replace With field, type the text or number to replace the search value entered in the Find field.

Check the Replace All box to replace all instances of the value in the Find field. Unchecking the Replace All box only replaces the first instance of the search value.

Undoing and redoing actions

Select Edit > Undo to undo the last worksheet action.

Select Edit > Redo to redo the last worksheet action.

Note:The Undo and Redo functions have no effect on any part of Phoenix other than worksheets.