Office Mobile

Applies to: Windows Mobile 5.0 Pocket PC Windows Mobile 5.0 for Pocket PCs offers mobile versions of familar Microsoft Office applications. Office Mobile extends your ability to remain productive while out of the office.

Use Office Mobile

Create a folder

Delete a folder

In the Word Mobile, Excel Mobile, PowerPoint Mobile, and Notes programs, you may want to delete a folder that you no longer use.

Rename a folder

Move a file or note

Note

In the file or note list, the storage card symbol is displayed next to the names of files saved on a storage card.

Create a file

In the Word Mobile and Excel Mobile programs, you can easily create documents and workbooks.

Note

When you save a new file, by default, a document is named after the first several words in the file while a workbook is named Book1, Book2, and so on. To name the file with a meaningful name, tap Menu > File > Rename/Move and enter the name you want.

Rename a file

Locate a file

Note

If you don’t see the file you want in the program file list, you may need to open File Explorer and navigate to the appropriate folder or use Search to locate the file.

Tips

To show all items in the file list, tap All Folders. You can also find a note by searching for a word located in a note.

Create a template

Tip

You can also create a new template by copying an existing one to the Templates folder.

Find or replace text or data

Word and Excel select the first instance of the text in the document and display buttons that allow you to find the next instance or replace the text, as desired.

Tip

To limit your search to specific cells in Excel, select the cells before tapping Menu > Edit > Find/Replace.

Automatically save files on a storage card

Note

In the file or note list, the storage card is displayed next to the names of files saved on a storage card.

Create a document or workbook by using a template

Templates help you save time and ensure consistency by allowing you to focus on the content rather than the format of an item.

Save a copy of a document or workbook

Important note

If the Word document or Excel workbook was previously saved on a PC, data and unsupported formatting may be lost when you save the file.

To quickly create a copy of a document or workbook, open Word or Excel. In the file list, tap and hold the file you want to copy, and tap Create Copy.

Tips

To cancel all unsaved changes you made to the document or workbook, tap Menu > File > Revert to Saved instead of Save As.

Set the default template

When you create a file or note in the Word Mobile, Excel Mobile, and Notes programs, the Blank [file type] template is used by default. If there is another template you use frequently, you may want to set that template as the default.

Note

If you created your own template, it must be located in the Templates folder and in your device’s main memory to be available for selection as a default template.

View files by type in the file list

Zoom in or out

In the Word Mobile and Excel Mobile programs, you can zoom in to take a closer look at a smaller area of your document or zoom out to see more of the document at a lower magnification.

Open a file

There are several ways to open an item such as a Word Mobile document, an Excel Mobile workbook, a picture, a note, or a PowerPoint Mobile presentation.

Notes

If the Word document or Excel workbook was previously saved on a PC, data and unsupported formatting may be lost when you save the file.

You can have only one document, workbook, or note open at a time. When you open a second item of the same type, the first one is saved and closed automatically.

Use PowerPoint Mobile

Applies to: Windows Mobile 5.0 Pocket PC

With PowerPoint Mobile, you can open and view slide show presentations created on your PC. Whether the presentation is opened from an e-mail message, downloaded from a file share or the Internet, copied to the device via a storage card, or obtained by synchronizing with your PC, slide shows created in *.ppt and *.pps format with PowerPoint ‘97 and later can be viewed on your device.

Many presentation elements built into the slide shows, such as slide transitions and animations, will play back on the device. If the presentation is set up as a timed slide show, one slide automatically advances to the next. Links to URLs are also supported.

The following PowerPoint features are not supported:

Work with slideshows

Start a slide show presentation

Stop a slide show presentation

Change the slide show orientation

You can view a PowerPoint Mobile presentation in portrait and in right-handed or left-handed landscape orientations.

Tip

Tap Default to view the presentation in the orientation that best fits the size and shape of the device screen.

Set slide show playback options

You can override some of the playback options stored in a PowerPoint presentation.

Tip

To turn the presentation into a continuously looping slide show, select both the Use timings, if present and the Loop continuously check boxes.

Navigate between slides

If a presentation is set up as a timed slide show, one slide will advance to the next automatically. However, if the presentation is not timed or you simply want to go to another slide out of sequence, you can do that easily in a PowerPoint Mobile presentation.

Notes

If you have zoomed in to see a slide in more detail, you cannot navigate to another slide until you zoom out.

Tapping Next or Previous may play an animation on a slide rather than navigate to another slide.

Tip

Simply tap the current slide to go to the next one.

Zoom in and out in a slide

Zoom in to see a portion of a slide in more detail and zoom out to see the entire slide again.

Note

If the presentation is set up as a timed slide show, the presentation will pause during zooming.

Tip

To view content that is not visible on the device screen during zooming, simply tap the slide and drag it up, down, or to either side until the content is visible.

Word Mobile

Applies to: Windows Mobile 5.0 Pocket PC

You can create and edit documents and templates in Word Mobile and save them as .doc, .rtf, .txt, and .dot files. You can edit Word documents and templates created on your PC. You can also open and edit Pocket Word (*.psw) documents; however, if you edit a file, you need to save it as a .doc, .rtf, .txt, or .dot file.

When you close a newly created document, it is automatically named after the first several words in the document and placed in the Word Mobile document list. You can easily rename the document with a more meaningful name and move it to another folder or a storage card.

Work with text

To work with text in your Word Mobile documents, use the following procedures.

Format text in a document

Create a list in a document

Tips

You can also use the Formatting toolbar to add bullets or numbers to text. To show the toolbar, tap View > Toolbar. A check mark appears next to Toolbar when the toolbar is visible.

You can also use the Formatting toolbar to increase or decrease the indentation in lists.

Align text in a document

You can center text, or align it to the right or left.
Tip

You can also use the Formatting toolbar to align text. To show the toolbar, tap View > Toolbar. A check mark appears next to Toolbar when the toolbar is visible.

Indent paragraphs in a document

Tip

To indent text in lists, you must use the Formatting toolbar. To show the toolbar, tap View > Toolbar. A check mark appears next to Toolbar when the toolbar is visible.

Move or copy text in a document

In Word Mobile, you can easily move, copy, and paste text within a document and between documents.
Note

Word Mobile does not support moving or copying pictures.

Tip

To select all text in a document, tap Menu > Edit > Select All.

Check spelling in a document

Tips

To check the spelling of specific text, select it, tap and hold, and tap Spelling.

To add a new word to the spelling dictionary, simply tap Add in the menu containing the list of suggested words.

Excel Mobile

Applies to: Windows Mobile 5.0 Pocket PCNot only can you edit Excel workbooks and templates created on your PC, you can create and edit workbooks and templates on your device with Excel Mobile.

Edit

Adjust column widths and row heights

 
TipTo specify an exact column width and row height, tap and hold the column or row, tap Format Cells and enter the measurements on the Size tab.
 

Copy and paste data

You can copy data from one cell to another in an Excel Mobile workbook by using the Copy and Paste commands on the shortcut menu. In addition, you can do the following:
TipTo preserve memory, Paste is limited to an area of 127 rows by 31 columns. To copy information into more rows or columns, reduce the amount of information copied at one time and perform the copy and paste procedure multiple times.
 

Delete cells, rows, or columns

 
NoteExcel Mobile keeps formulas up to date by adjusting references to the shifted cells to reflect their new locations. However, a formula that refers to a deleted cell displays the #REF! error value.
 

Fit rows and columns to data

 
 
 
 

Format numbers and text

You can easily format numbers in an Excel Mobile workbook by assigning a numeric category such as number, currency, date, or fraction to a cell. You can also format text by changing the font type, size, or color, applying bold or italic formatting, and underlining text.
 

View

Adjust the view of a worksheet

In an Excel Mobile workbook, you can display and hide window elements such as scroll bars, view two areas of a worksheet and lock rows or columns in one area by splitting or freezing panes, and use the full screen to see as much data as possible.
 

Go to a cell or region

 
NoteThe current region is defined as the block of filled-in cells that includes the currently selected cell or cells. The region extends in all directions to the first empty row or column.

Tip

To go to a specific cell, you can also enter the cell reference in the name box and then tap Enter.

 

Hide and display rows and columns

 

Calculate

Automatically calculate values

You can quickly calculate the largest number, smallest number, average number, and sum of the numbers in a selected range of values.
 

Automatically enter a sequence of values

 
Note
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.Tip
To preserve memory, Fill is limited to an area of 127 rows by 31 columns. To copy information into more rows or columns, reduce the amount of information copied at one time and perform the fill procedure multiple times.
 

Automatically add values

 
Note
Any time you change a value in the cells you originally selected to add, the sum will be updated.
 

Enter a formula

 

Enter a value or text in a cell

Note
To enter text, you may need to tap Input to display Input panel.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 in x.
 

Filter data in a worksheet

 
Note
The data in the top row of the selected cells or range of cells will not be filtered. The row should contain column headings.Tips
To turn off AutoFilter, tap Tools > AutoFilter.
To display all rows again, tap All in the filter list in each of the selected columns.
 

Insert a function

 
Tip
To learn about a function, review the information provided in the description area below the Function list.
 

Insert a symbol

 
Tips
If you select a different font or subset, a different set of symbols displays.
To use Microsoft Wingdings or Microsoft Webdings that are available on your PC, connect your device to your PC and open ActiveSync. Copy the Wingdings.ttf and Webdings.ttf files from the Font folder on your PC to the My Windows Mobile Device /Windows/Fonts folder in the ActiveSync window. For more information, see ActiveSync Help on the PC.
 

Worksheets

Insert a worksheet

An Excel Mobile workbook contains three worksheets by default. You can easily add more sheets if you need them to help organize your data.
 

Delete a worksheet

You can delete a worksheet you no longer need from your workbook.
 

Rename a worksheet

Worksheets are named Sheet1, Sheet2, and so on, by default. You can easily rename the worksheets with meaningful names.
 

Move a worksheet

You can easily change the order of sheets in your Excel Mobile workbook.
 

Switch to another Worksheet

 
 

Sort data in a worksheet

You can sort data in ascending order (A-Z, or 0-9) or descending order (Z to A, or 9 to 0).
Tip
To undo a sort, tap Menu > Undo Sort.
 

Insert cells, rows, and columns

 
Note
Excel Mobile keeps formulas up to date by adjusting references to the shifted cells to reflect their new locations.