Palm KITT User Manual

YOUR PERSONAL INFORMATION ORGANIZER

TIP

To pencil in an appointment, open the

appointment, select Status, and then select

Te n t a t i v e .

Adding an alarm reminder to an event 1 Create an event, and then select it. 2 Press Edit (left action key). 3 Select Reminder, and then select

Remind Me.

4 Enter the number of minutes, hours,

days, or weeks before the event you would like to receive the alarm.

Type of time units

Number of time units

5 Press OK .

Creating an untimed event

An untimed event, such as a birthday, anniversary, or vacation, does not occur at a particular time. These events appear as banners at the top of your calendar; they don’t occupy blocks of time. For example, “Submit Final Draft” in the screenshot shown here is an untimed event.

DID YOU KNOW

longer than a day.

An untimed event can last

1 Press Start and select Calendar.

2 Press Menu (right action key)

and select New Appointment. 3 Enter a subject (description). 4 Select the starting and ending dates.

CHAPTER

CALENDAR

153

YOUR PERSONAL INFORMATION ORGANIZER

CHAPTER

5 Select All Day, and then select Ye s . 6 Press OK .

Scheduling a repeating appointment 1 Create an appointment or untimed

event, and then select it.

2 Press Edit (left action key). 3 Select Occurs, and then select a repeat

pattern. To create a repeat pattern, select Edit pattern and follow the onscreen instructions.

TIP

To enter a birthday or an anniversary, create an untimed event that repeats every year.

4 Press OK .

Sending a meeting request

You can email meeting invitations to contacts who use Microsoft Office

Outlook

BEFORE YOU BEGIN Create contact

or Outlook Mobile.

entries with email addresses for the people you want to invite to a meeting. You can’t access contact entries without email addresses from your calendar.

1 Create an event, and then select it. 2 Press Edit (left action key). 3 Select Attendees, and then select the

name of the contact you want to invite. To invite other attendees, select Add and select the names.

DID YOU KNOW

Server 2003 with Service Pack 2, you can use your corporate Global Address List to find contact information for an attendee. Select Attendees, press Menu (right action key), and then select Find Online. Enter the name of the attendee and select Find.

If you are using an Exchange

4 Press OK . The next time you synchronize, the

meeting request is sent to the attendees. When attendees accept your meeting request, the meeting is automatically added to their schedules. When you receive their response, your calendar is updated as well.

Marking an event as sensitive

If other people have access to your Microsoft Office Outlook calendar on your computer and you don’t want them to see

154

CALENDAR

YOUR PERSONAL INFORMATION ORGANIZER

an appointment, you can mark that appointment as private to hide it from other Microsoft Office Outlook users.

1 Create an event, and then select it. 2 Press Edit (left action key). 3 Select Sensitivity, and then select one

of the following: Private: Displays the event on your

smartphone and on your computer. Meeting attendees or recipients see “Please treat this as Private” near the top of an open appointment. If you sync with Exchange Server, other users who can access your folders can’t see your private events; they see private events as unavailable time slots.

Pers on al: Displays the event on your smartphone and on your computer. Meeting attendees or recipients see “Please treat this as Personal” near the top of an open appointment.

Confidential: Displays the event on your smartphone and on your computer. Meeting attendees or recipients see “Please treat this as Confidential” near the top of an open appointment.

TIP

If you don’t see an option on the screen, press Down on the 5-way to scroll to other options. For example, when editing an event, you don’t see the Sensitivity option until you scroll toward the bottom of the entry.

4 Press OK .

Organizing your schedule

Use categories to view various types of events.

1 Create an event, and then select it.

2 Press Edit (left action key). 3 Select Category, and then check the

categories that apply to this event. To add a new category, press New

CHAPTER

CALENDAR

155

YOUR PERSONAL INFORMATION ORGANIZER

CHAPTER

(left action key), enter the

category name, and then press OK .

4 Press OK two more times. 5 After you assign events to categories,

press Menu (right action key) and select Filter.

TIP

Wonder why you’re not seeing all the events in your day? Check to make sure that the filter is set to All Appointments.

2 On the General tab, set any of the

6 Select the type of events you want to

view.

following options: 1st day of week: Specifies Sunday or

Monday as the first day of the week for

Deleting an event 1 Highlight the event you want to delete. 2 Press Menu (right action key)

and select Delete Appointment.

3 Select Ye s .

Customizing Calendar 1 Press Menu (right action key)

and select Options.

all Calendar views. Week view: Specifies whether five, six,

or seven days appear in Week View. Show half hour slots: Specifies

whether time slots appear in hour or half-hour increments in Day View and Week View.

Show week numbers: Specifies whether week numbers (1–52) appear in Week View.

3 Select the Appointments tab and set

any of the following options:

156

CALENDAR

YOUR PERSONAL INFORMATION ORGANIZER

Set reminders for new items:

Specifies whether a reminder is automatically added to new events and how long before the event the reminder appears. You can override this setting for individual events.

Show icons: Specifies which icons

appear next to events.

The event has a reminder. The event repeats in a specified

pattern.

The event has a note attached.

A location has been assigned to the

event.

The event is a meeting.

The event is marked private.

TIP

Not all icons appear in all Calendar views.

Send meeting requests via: Specifies

the messaging method used to send meeting requests: email, MMS, or SMS.

4 Press OK .

Tasks

You can use Tasks to remind you of tasks you need to complete and to keep a record of completed tasks.

Adding a task 1 Press Start and select Programs. 2 Select Ta s k s . 3 Press New (left action key).

TIP

You can also add a task by selecting the Tasks entry bar at the top of the task list screen.

4 Enter a description of the task in the

Subject field.

CHAPTER

TASKS

157

YOUR PERSONAL INFORMATION ORGANIZER

CHAPTER

5 Set any of the following:

• Categories: Assigns the task to one

or more categories.

Sensitivity: Marks this task as Normal, Personal, Private, or Confidential.

Notes: Enables you to enter additional text for the task.

6 Press OK .

Checking off a task 1 Select the task you want to check off.

Priority: Specifies the priority level for

this task. Later you can arrange your tasks based on the importance of each task.

Status: Indicates whether the task is now completed.

• Starts: Specifies when the task

begins.

• Due: Specifies the due date for the

task.

• Occurs: Indicates if the task repeats

at regular intervals and how often it repeats.

• Reminder: Sets an alarm for this task

2 Press Edit (left action key). 3 Select Status and select Completed. 4 Press OK .

and indicates when you want to be reminded.

158

TASKS

YOUR PERSONAL INFORMATION ORGANIZER

TIP

You can also mark a task complete by tapping the check box next to the task on the Tasks list.

DID YOU KNOW

Overdue tasks appear in red.

Organizing your tasks 1 In the Tasks list, press Menu

(right action key) and select Filter.

2 Select which tasks you want to view:

All Tasks, Recently Viewed, No Categories, Active Tasks, Completed Tasks, or a specific

category, such as Business or Personal.

3 Press Menu (right action key)

and select Sort By.

4 Select the sort method: Status,

Priority, Subject, Start Date, or Due Date.

Deleting a task 1 Highlight the task you want to delete. 2 Press Menu (right action key)

and select Delete Task.

3 Select Ye s .

Customizing Tasks 1 Go to the Tasks list. 2 Press Menu (right action key)

and select Options.

3 Set any of the following options:

Set reminders for new items:

Automatically adds a reminder to new tasks. The default reminder is set to 8:00 on the morning the task is due. You can override this setting for individual tasks.

Show start and due dates: Displays task start and due dates in the Tasks list.

Show Tasks entry bar: Displays the Tasks entry bar at the top of the Tasks list.

4 Press OK .

Notes

Notes are a great way to capture thoughts, questions, and meeting notes on your Palm Treo 750v smartphone. You can also create

CHAPTER

NOTES

159

YOUR PERSONAL INFORMATION ORGANIZER

CHAPTER

a voice note or add a recording to an existing note.

BEFORE YOU BEGIN To take advantage of

all the sync features available in the Notes application, install the desktop synchronization software from your Windows Mobile Getting Started Disc.

Creating a note 1 Press Start and select Programs. 2 Select Notes . 3 Press New (left action key). 4 Do one of the following:

5 Press OK .

Creating a voice note 1 Press Start and select Programs. 2 Select Notes . 3 To add a voice recording to an existing

note, open the note to which you want to add the recording.

4 If the voice note controls are not visible

at the bottom of the screen, press Menu (right action key) and select View Recording Toolbar.

5 Tap the Record icon.

Voi ce note controls

• Type the text with the keyboard.

• Write the text with the stylus.

• Draw a sketch with the stylus,

6 Speak into your smartphone’s

microphone or hold it close to another sound source.

crossing at least three ruled lines.

160

NOTES

YOUR PERSONAL INFORMATION ORGANIZER

7 When you have finished recording, tap

the Stop icon. A Recording icon appears in the note or note list, depending on where you recorded the note.

8 Press OK .

DID YOU KNOW

notes within a single note.

TIP

To play a recording, select the voice note in the Notes list or open the note containing the recording and tap the Recording icon. Tap the controls at the bottom of the screen to control playback and volume.

You can add several voice

Creating a note from a template 1 Go to the Notes list. 2 Select the Show list in the upper-left,

and then select Te m p l a t e s . 3 Open the template you want to use. 4 Enter the information. 5 Press OK . 6 Rename the note and move it to the

appropriate folder. See Organizing your

notes for details.

TIP

To create a new template, open the note you want to save as a template. Press Menu (right action key) and select Rename/Move. Select Name, and then enter a name for the template. Select the Show list, and then select Template. Press OK.

Organizing your notes

You can rename your notes, move notes to another folder, and move notes between your smartphone and an expansion (storage) card.

1 Go to the Notes list and highlight a note

you want to move.

2 Press Menu (right action key)

and select Rename/Move.

3 Select Name, and then enter a new

name for the note.

4 Select Folder, and then select the folder

in which you want to store the note.

5 Select Location, and then select Main

memory or Storage Card.

6 Press OK .

CHAPTER

NOTES

161

YOUR PERSONAL INFORMATION ORGANIZER

CHAPTER

TIP

To create a new folder, go to the Notes list, select the Show list in the upper-left, and then select Add/Delete. Select New, enter a name for the folder, and then press OK.

3 Set any of the following options:

Default mode: Makes the default entry

mode either Writing or Typing. The default is Typing; if you change it to Writing, you can write notes directly on

Deleting a note 1 Go to the Notes list and highlight the

note you want to delete.

2 Press Menu (right action key)

and select Delete.

3 Select Ye s .

Customizing Notes 1 Go to the Notes list. 2 Press Menu (right action key)

and select Options.

the screen using the stylus. Default template: Specifies the default

template for new notes. Save to: Indicates the default location

where new notes are stored. Record button action: Specifies what

happens when you press the Side button to record a voice note while in another application: whether the Notes application opens or whether you stay in the current application.

4 Press OK .

162

NOTES

Your Microsoft Office tools

Your smartphone enables you to take your office with you— including your Microsoft Office files. With Microsoft Office, you can carry, create, view, and edit Microsoft Word and Excel files directly on your smartphone. You can also view, carry, and manage PowerPoint files on your smartphone. You can keep updated copies of the files on both your smartphone and your computer so that you can work on them in the most convenient location any time.

Benefits

• Manage Word, Excel, and

PowerPoint files on your smartphone

• Improve productivity by taking

important docs, spreadsheets, and presentations with you

CHAPTER

In this chapter

Synchronizing your Microsoft Office files. . . . . . . . . . . . . . . . . . . . . 165

Word Mobile . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 165

PowerPoint Mobile. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 171

Excel Mobile. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 172

YOUR MICROSOFT OFFICE TOOLS

Synchronizing your Microsoft Office files

You can edit files on your computer or on your smartphone and then synchronize your files with your computer. To synchronize Microsoft Office files with your computer, you must set the Files sync option; see Setting synchronization options. The files are stored in your Files folder on your computer.

To copy a file from your computer to your smartphone, open My Computer or Windows Explorer on your computer, copy the file into the Mobile Device folder, and then sync.

Word Mobile

You can create and edit documents and templates and save them as DOC, RTF, TXT, and DOT files. You can also edit Microsoft Office Word documents and templates that you create on your computer. However, keep in mind that

some of the information and formatting may be lost when you save the document on your smartphone.

DID YOU KNOW

you can view the file using Picsel PDF Viewer. Press Start, select Programs, and then select

PDF Viewer.

If you have a PDF file (.pdf),

The following features are not supported in Word Mobile:

• Backgrounds.

• Bidirectional text.

• Document protection.

• Metafiles.

• Artistic page borders. Lined page

borders are supported.

• Password-protected files. Remove

password protection on your computer before opening the file on your smartphone.

• Shapes and text boxes.

• Smart tags.

CHAPTER

SYNCHRONIZING YOUR MICROSOFT OFFICE FILES

165

YOUR MICROSOFT OFFICE TOOLS

CHAPTER

The following features are partially supported in Word Mobile:

• Picture bullets. Regular bullets are

supported.

• Revision marks. Documents appear as

though all revisions were accepted; if the document is saved, revision marks are lost.

• Table styles. Some or all of the

formatting is lost if the document is saved.

• Underline styles. Unsupported styles

are mapped to one of the four supported styles: regular, dotted, wavy, or thick/bold/wide.

• Legacy Pocket Word files. You can open

PSW files, but if you edit a file, you need to save it in DOC, RTF, TXT, or DOT format.

• Footnotes, endnotes, headers, and

footers.

• Lists. Indented lists are mapped to the

closest indentation level supported by Word Mobile.

• Page breaks. Although not displayed, all

page breaks, except a break placed at the end of a document, are retained in the document.

Creating a document 1 Press Start and select Programs. 2 Select Word Mobile . 3 Press New (left action key). 4 Enter the text of the document. 5 Press OK to save the file. When you

save a new document, it is automatically named after the first

several words in the file. The following features are not supported on your smartphone, but they remain in the file so that when you open the file on your computer, they appear as expected:

• Fonts and font sizes. Original fonts are

listed on your smartphone and are mapped to the closest font available.

Opening an existing document 1 Press Start and select Programs. 2 Select Word Mobile . 3 In the document list, select the

document you want to open.

WORD MOBILE

166

YOUR MICROSOFT OFFICE TOOLS

TIP

To zoom in or out, press View, select

Zoom, and then select the zoom level.

Creating a document from a template 1 Go to the documents list. 2 Select the Show list in the upper-left,

and then select Te m p l a t e s . If you don’t see Templates in the Show list, select

More Folders to access this folder.

3 Open the template you want to use and

enter the information.

4 Press OK . 5 Rename the document and move it to

the appropriate folder. See Organizing your documents for details.

TIP

To create a new template, open the document you want to save as a template. Press Menu and select Rename/Move. Select Name, and then enter a name for the template. Select the Show list, and then select Template. Press OK.

Finding or replacing text in a document 1 Open the document containing the text

you want to find.

2 Press Menu (right action key)

and select Edit > Find/Replace.

3 Select Find what and enter the text you

want to find.

4 (Optional) Check the Match case box

to find text that matches the capitalization in the text you entered step 3.

5 (Optional) Check the Match whole

words only box to find only full words

that match the text you entered in step 3.

6 Select Find to locate the first instance

of the text you entered in step 3, or select Replace and enter the replacement text.

7 Select Next to find the next instance of

the text, or select Replace to replace it. To replace all instances of the text, select Replace All.

8 When you see a message that the

search is done, press OK .

Moving or copying text 1 Open the document containing the text

you want to move or copy.

CHAPTER

WORD MOBILE

167

YOUR MICROSOFT OFFICE TOOLS

CHAPTER

2 Highlight the text you want to move or

copy.

3 Press Menu (right action key)

and select Copy to copy the text, or select Cut to move the text.

4 Open the document where you want to

insert the text and position the insertion

5 Select the Ty p e list, and then select the

format in which you want to save the file.

6 Select the Location list, and then select

whether you want to store the file on your smartphone or an expansion card.

7 Select Save. point where you want the text to appear.

5 Press Menu (right action key)

and select Paste.

Saving a copy of a document

NOTE If a document was previously saved

on a computer, any unsupported formatting may be lost when you save the file.

1 Open the document you want to copy. 2 Press Menu (right action key)

and select File > Save As.

3 Select Name and enter a new name for

the file.

4 Select the Folder list, and then select

the folder where you want to save the file.

Formatting text

1 Open the document you want to

format.

2 Highlight the text you want to format.

3 Press Menu (right action key)

and select Format > Font.

4 Set any of the following options for the

highlighted text:

Font: Specifies the typeface. Font color: Specifies the color. Size: Specifies the point size. Bold: Indicates whether the text

appears normal or thick. Italics: Indicates whether the text

appears upright or slanted. Underline: Indicates whether the text

appears with an underscore.

WORD MOBILE

168

YOUR MICROSOFT OFFICE TOOLS

Highlight: Indicates whether the text appears with a yellow highlight.

Strikethrough: Indicates whether the text appears with a line through it.

5 Press OK to return to the document.

Formatting paragraphs and lists

1 Open the document you want to

format.

2 Position the insertion point in the

paragraph you want to format.

3 Press Menu (right action key)

and select Format > Paragraph.

4 Set any of the following options:

Alignment: Aligns the text with the left,

right, or center of the paragraph. List: Creates a bulleted or numbered

list. Indentation: Changes the paragraph

margins.

• Left: Sets the left margin for the

entire paragraph.

• Right: Sets the right margin for the

entire paragraph.

• Special: Lets you indent the first line

or set a hanging indent.

• By: Sets the size of the Special

indentation.

5 Press OK to return to the document.

TIP

You can also use the Formatting toolbar to create a list and to align text. To indent text in lists, you must use the Formatting toolbar.

Checking spelling in a document

1 Open the document you want to check. 2 Press Menu (right action key) and

select To o l s > Spelling. To check the spelling of specific text, highlight it before you select the Spelling command.

3 If an unknown or misspelled word is

encountered, do one of the following:

• Select the correct word in the list if

the word is spelled incorrectly.

• Select Ignore if the word is spelled

correctly.

• Select Add to add a new word to the

spelling dictionary.

CHAPTER

WORD MOBILE

169

YOUR MICROSOFT OFFICE TOOLS

CHAPTER

Organizing your documents

You can rename your documents, move your documents to another folder, and move your documents between your smartphone and an expansion (storage) card.

1 Go to the documents list. 2 Highlight a file. 3 Press Menu (right action key)

and select Rename/Move.

4 Select Name, and then enter a new

name for the document.

5 Select the Folder list, and then select

the folder you want to move the document to.

6 Select the Location list, and then select

Main memory or Storage card. 7 Press OK . 8 Select the Show list in the upper-left,

and then select the folder you want to

view. 9 Select the Sort By list in the upper-right,

and then select the sort method.

TIP

To create a new folder, go to the documents list, select the Show list in the upper-left, and then select the Add/Delete tab. Select New, enter a name for the folder, and then press OK.

TIP

When you go to a folder, you can easily search your documents by sorting by type.

Deleting a document 1 Go to the documents list. 2 Highlight the document you want to

delete.

3 Press Menu (right action key)

and select Delete.

4 Select Ye s .

Customizing Word Mobile 1 Go to the document list. 2 Press Menu (right action key)

and select Options.

3 Set any of the following options:

Default template: Sets the default

template for new documents. Save to: Sets the default location

where new documents are stored.

WORD MOBILE

170

YOUR MICROSOFT OFFICE TOOLS

Display in list view: Sets the types of

files that appear in the documents list.

4 Press OK .

PowerPoint Mobile

With PowerPoint Mobile, you can open and view slide show presentations created on your computer. Many presentation elements such as slide transitions, animations, and URL links are also supported. Microsoft features not supported on your smartphone include the following:

• Notes written for slides

• Rearrangement or editing of slides

• Files created in PPT format earlier than

Microsoft PowerPoint ‘97

• HTML files in HTM and MHT formats

TIP

To copy a file from your computer to your smartphone, open My Computer or Windows Explorer on your computer, copy the file into the Mobile Device folder, and then sync.

Office PowerPoint®

Playing a presentation

NOTE If a presentation is set up as a timed

slide show, the slides advance automatically. Presentations pause during zooming.

1 Press Start and select Programs. 2 Select PowerPoint Mobile . 3 In the presentation list, highlight the

presentation you want to play.

4 Press Center . 5 Do any of the following:

• Press Right to advance to the next

slide or Left to view the previous slide.

• Press Menu (right action key),

select Go to Slide, and select the slide you want to view.

• Select Next or Previous to play

animations.

• Press Menu (right action key),

select Zoom In, and then select to zoom in or to zoom out. To scroll within the current slide, tap and drag the slide. To return to the slide show, select .

CHAPTER

POWERPOINT MOBILE

171

YOUR MICROSOFT OFFICE TOOLS

CHAPTER

• Press Menu (right action key)

and select End Show.

Loop continuously: Advances to the first slide after playing the last slide in a presentation.

Setting presentation playback options

6 Press OK .

1 Open the presentation for which you

TIP

want to change the settings.

2 Press Menu (right action key)

and select Show Options.

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

continuously boxes.

3 On the Orientation tab, select the

orientation you want. To select the orientation that best fits your smartphone’s screen, select Default.

4 Select the Playback tab, and check the

Override playback options for all files

box.

5 Set any of the following options:

Show without animation: Tur ns o f f

builds and other animations. Show without slide transition: Turn s

off transition effects between slides. Use slide timings, if present: Enables

the timings recorded with each slide in a presentation. If a presentation is set up as a timed slide show, the slides advance automatically. Presentations pause during zooming.

Excel Mobile

With Excel Mobile you can create and edit workbooks and templates on your smartphone. You can also edit workbooks and templates that you create on your computer. However, keep in mind that you may lose some of the information and formatting when you save the workbook on your smartphone.

Note the following formatting considerations:

• Alignment: Vertical text appears

horizontal.

• Borders: Appear as a single line.

EXCEL MOBILE

172

YOUR MICROSOFT OFFICE TOOLS

• Cell patterns: Patterns applied to cells

are removed.

• Fonts and font sizes: The original font

is listed on your smartphone and mapped to the closest font available. Original fonts reappear on your computer.

• Number formats: Microsoft® Office

Excel® 97 conditional formatting is displayed in Number format.

• Formulas and functions: Unsupported

functions are removed, and only the returned value of the function appears. Formulas containing the following are also converted to values:

• An array or array argument, for

example, =SUM({1;2;3;4})

• External link references or an

intersection range reference

• References past row 16384 are

replaced with #REF!

• Protection settings: Most protection

features are disabled but not removed. However, password protection is removed. You must remove the password protection in Microsoft Office

Excel on your computer before opening the file on your smartphone.

• Zoom settings: Worksheet-specific

zoom settings are not retained. The zoom setting applies to the entire workbook.

• Worksheet names: Names that refer to

other workbooks, arrays, array formulas, or intersection ranges are removed from the name list, causing those formulas to be resolved as “#NAME?” All hidden names are not hidden.

• AutoFilter Settings: AutoFilters that

cause rows to be hidden are supported. Use the Unhide command to display hidden rows. Other AutoFilters are removed, but you can use the AutoFilter command in Excel Mobile to perform similar functions.

• Chart Formatting: All charts are saved

as they appear in Excel Mobile. Unsupported chart types are changed to one of these supported types: Column, Bar, Line, Pie, Scatter, and Area. Background colors, gridlines, data labels, trend lines, shadows, 3D effects, secondary axes, and logarithmic scales are turned off.

CHAPTER

EXCEL MOBILE

173

YOUR MICROSOFT OFFICE TOOLS

CHAPTER

The following features aren’t supported in Excel Mobile and are removed or modified when you open a workbook on your smartphone:

• Hidden, dialog, and macro sheets

• VBA modules

• Tex t boxe s

• Drawing objects and pictures

• Lists

• Conditional formats and controls

• Pivot table data (converted to values)

6 Repeat steps 4 and 5 to enter the

remaining info.

7 Press OK to save the file. When you

save a new workbook, it is automatically named and placed in the workbook list.

Creating a workbook from a template 1 Go to the workbook list. 2 Select the Show list in the upper-left,

and then select Te m p l a t e s .

3 Open the template you want to use and

enter the information you want to include in the template.

DID YOU KNOW

you can view the file using Picsel PDF Viewer. Press Start, select Programs, and then select

PDF Viewer.

If you have a PDF file (.pdf),

4 Press OK . 5 Rename the workbook and move it to

the appropriate folder. See Organizing your documents for details.

Creating a workbook 1 Press Start and select Programs. 2 Select Excel Mobile . 3 Press New (left action key).

TIP

To create a new template, open the workbook you want to save as a template. Press Menu and select Rename/Move, and then enter a name for the template. Select

Folder, and then select Template. Press OK.

4 Highlight a cell where you want to enter

text or other info.

5 Enter the info in the cell, and then press

Enter .

EXCEL MOBILE

174

YOUR MICROSOFT OFFICE TOOLS

Viewing a workbook

TIP

To copy a file from your computer to your smartphone, open My Computer or Windows Explorer on your computer, copy the file into the Mobile Device folder, and then sync.

1 Press Start and select Programs. 2 Select Excel Mobile . 3 In the workbook list, select the

workbook you want to view.

4 Press View (left action key), and

then select any of the following: Full Screen: Shows as much data as

possible on the screen. To return to the normal view, select Restore in the upper-right.

Zoom: Sets the magnification level so that you can easily read the worksheet.

Sheet: Lets you switch to a different worksheet.

DID YOU KNOW

worksheets by selecting the sheet list at the bottom of the screen.

You can also switch

Split: Divides the window into two scrollable areas. To move the split bar, tap and drag it. To remove the split bar, select View > Remove Split.

Freeze Panes: Locks rows and columns so they remain visible while you scroll. Highlight the cell at the juncture you want to lock before you select this command. To unlock the rows or columns, select View > Unfreeze

Panes. To o l b a r : Indicates whether the toolbar

appears onscreen. Status Bar: Indicates whether the

status bar appears onscreen. Show: Indicates whether headings and

scroll bars appear onscreen.

TIP

To jump to a cell or region, press Menu and select Edit > Go To. Select Cell reference or name and enter the target cell info or select Current region. Select OK.

CHAPTER

EXCEL MOBILE

175

YOUR MICROSOFT OFFICE TOOLS

CHAPTER

Calculating a sum 1 Press View (left action key) and

select To o l b a r .

2 Highlight the cell where you want to

insert the sum.

TIP

To insert a symbol, place the insertion point where you want the symbol. Press Menu and select Insert > Symbol. Highlight the symbol you want to insert, and then select

Insert.

3 Select . 4 Tap and drag the stylus across the cells

you want to add.

5 Press Enter .

TIP

For simple calculations, use the Calculator

(see Calculator

Inserting a function 1 Open the workbook where you want to

insert the function.

Entering a formula 1 Highlight the cell where you want to

enter the formula.

2 Enter equals sign ( = ) followed by any

values, cell references, name references, operators, and functions.

Examples:

• =(B4/25)+100

• =Revenue-Expenses

3 Press Enter .

2 Press Menu (right action key)

and select Insert > Function.

3 Select the Category list, and then

select the type of function you want to insert.

4 Select the Function list, and then select

the specific function you want to insert.

5 Select OK.

EXCEL MOBILE

176

+ 56 hidden pages