HP Glisten manual Enter and edit data, Open and view an Excel spreadsheet

Open and view an Excel spreadsheet

1.Press Start , tap Office Mobile > Excel Mobile.

2.In the program file list, tap the file that you want to open.

NOTE: Excel Mobile does not fully support some features, such as formulas and cell comments. Some data and formatting may be lost when you save the workbook on your device.

TIP: To change the size of the display, tap View > Zoom, and then tap a percentage.

Enter and edit data

Enter a value or text in a cell

1.Tap the cell in which you want to enter a value or text.

2.Enter the value or text, and then press the Enter key.

NOTE: To enter text, you may have to tap keyboard to display the on-screen keyboard.

TIP: To quickly edit cell contents, tap the cell and replace or edit the text or value. To undo an edit, tap Menu > Undo Typing.

Edit a value or text in a cell

1.Tap the cell that contains the data that you want to edit, and then tap anywhere in the formula bar (fx), near the top of the screen.

2.Use the left or right arrow keys on the on-screen keyboard or tap to position the insertion point next to the characters you want to edit, and then do any of the following:

●To delete characters, tap Delete on the on-screen keyboard, or select them and then tap Menu > Cut.

●To insert characters, tap where you want to insert them, and then enter the new characters.

●To replace specific characters, select them, and then enter the new characters.

3.To enter your changes, tap the Enter button on the on-screen keyboard.

Enter a sequence of values automatically

You can save time entering data by filling data into adjacent cells automatically. For example, with Autofill you can quickly fill cells with repetitive data such as numbers or repeated text. Autofill takes the content of the first cell in the selected row or column and copies it down or across the rest of the selection.

1.Select both the range that contains the data that you want to reference and the adjacent destination cells.

2.Tap Menu > Edit > Fill.

3.In Direction list, tap the direction you want.

4.In Fill type list, tap Series.

80 Chapter 16 Use productivity tools