Section 5B: Increasing Your Productivity 249
Productivity
Deleting Cells, Rows, and Columns
1. Open the workbook containing the elements you want to delete.
2. Highlight the area you want to delete.
3. Press Menu (right softkey) and select Edit > Delete Cells.
4. Select how you want to remove the elements:
䡲 Shift cells left: Deletes the highlighted cells and moves all cells on the
right one column to the left.
䡲 Shift cells up: Deletes the highlighted cells and moves all cells below
them up.
䡲 Entire row: Deletes the entire row in which the highlighted cells are
located, and moves all rows below it up.
䡲 Entire column: Deletes the entire column in which the highlighted cells
are located, and moves all columns on the right one column to the left.
5. Press OK .
Did You
Know?
Excel Mobile adjusts formulas to reflect the new cell locations. However,
a formula that refers to a deleted cell displays the #REF! error value.
Tip:
To delete a workbook, go to the workbook list and highlight the
workbook you want to delete. Press Menu and select Delete. Select Ye s to
confirm.
To Next Page
Loading...
