Hand Held Products 7900 manual Creating an Excel File, Tips for Working in Pocket Excel

Creating an Excel File

To create a new file, tap Start > Programs > Pocket Excel > New. A blank workbook appears. If you’ve selected a template for new workbooks in the Options dialog box, that template appears with appropriate text and formatting already provided.

If your workbook contains sensitive information, you can protect it with a password. To do so, open the workbook, tap Edit, and then Password. Every time you open the workbook, you will need to enter the password, so choose one that is easy for you to remember but hard for others to guess.

Tips for Working in Pocket Excel

•View in full-screen mode to see as much of your worksheet as possible. Tap View and then Full Screen. To exit full-screen mode, tap Restore.

•Show and hide window elements. Tap View and then tap the elements you want to show or hide.

•Freeze panes on a worksheet. First select the cell where you want to freeze panes. Tap View > Freeze Panes. You might want to freeze the top and left-most panes in a worksheet to keep row and column labels visible as you scroll through a sheet.

•Split panes to view different areas of a large worksheet. Tap View > Split. Then drag the split bar to where you want it. To remove the split, tap View > Remove Split.

•Show and hide rows and columns. To hide a hidden row or column, select a cell in the row or column you want to hide. Then tap Format,> Row or Column > Hide. To show a hidden row or column, tap Tools > Go To, and then type a reference that is in the hidden row or column. Then tap Format > Row or Column > Unhide.

For more information on using Pocket Excel, tap Start > Help.

12 - 16 Rev D Dolphin® 7900 Series User’s Guide