User's Manual

Chapter 2 — Windows Mobile Version 5.0
CN30 Mobile Computer User’s Manual 41
Creating a Workbook
Use Excel Mobile to create workbooks, such as expense reports and mileage
logs. To create a new file, tap Start > Programs > Excel Mobile > New. A
blank workbook appears. Or, if you have selected a template for new work-
books in the Tools > Options dialog box, that template appears with appro-
priate text and formatting already provided. You can open only one
workbook at a time; when you open a second workbook, save the first. You
can save a workbook you create or edit in a varietyof formats, including
Excel Mobile (.PXL) and Excel (.XLS). You can also save a workbook as a
template by moving the workbook to the Templates folder.
Excel Mobile contains a list of the files stored on your CN30 Mobile Com-
puter. Tap a file in the list to open it. To delete, make copies of, and send
files, tap and hold a file in the list. Then select the appropriate action from
the pop-up menu.
Excel Mobile provides fundamental spreadsheet tools, such as formulas,
functions, sorting, and filtering. To display the toolbar, tap View > Toolbar.
Cell contents appear here as you enter them.
Zoom button.
AutoSum button.
Format button.
Note: If your workbook contains sensitive information, you can protect it
with a password. To do so, open the workbook, tap Edit > Password.Every
time you open the workbook, enter a password, preferably one that is easy
for you to remember but hard for others to guess.
Tips for Working in Excel Mobile
Note the following when working in large worksheets in Excel Mobile:
• View in full-screen mode to see as much of your worksheet as possible.
Tap View > Full Screen.To exit full-screen mode,tap Restore.
• Tap View > Zoom and select a percentage so that you can easily read the
worksheet.
• 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 mightwanttofreeze the top and left-
most panes in a worksheet to keep row and column labels visible as you
scroll througha sheet. Tap View > Unfreeze Panes to undo this process.
• Split panes to view differentareas ofa large worksheet. Tap View > Split.
Then drag the split bar to where you want it. To remove the split, tap
View > Remove Split.