Features worth highlighting include the following:
-
Support for formulas
-
Creating various charts
-
Ability to copy and paste special (formulas, values and formats)
-
Sorting data
-
Switching between sheets
-
Supporting freeze pane
-
Viewing the entire worksheet in one screen
Creating a new worksheet
To open Excel Mobile, select Start > Office Mobile > Excel Mobile or Start > Programs > Office Mobile > Excel Mobile if the program is not in your Start menu.
You’ll see a list of all your Excel spreadsheets, regardless of which folder they have been saved in. To create a new spreadsheet, select New at the bottom of the screen. A blank worksheet will appear with the top left cell highlighted for entry.
Inserting and formatting content in Excel Mobile
You can immediately start entering data into the cells or select the bottom right function drop-down list to select a common function. To insert cells, a chart, a symbol or a function, or to define a name, simply select Menu at the bottom of the page, and then choose Insert.
Formatting cells
To format cells, a chart, rows or columns, or to modify sheets, select Menu at the bottom of the page, and select Format. You’ll find options to format the cells, chart, row or column, or modify the sheets.
Editing a Worksheet
A number of editing tools are at your disposal in Windows Mobile 6. From the Edit menu, you can paste special, fill, clear, delete, find and replace, go to cells, and select all.
Creating a chart
To create a chart, first select the data to be used in the chart. Open the soft keyboard by selecting the keyboard icon at the bottom of the screen. Use the stylus to select one corner cell. Select Shift, and then select additional cells. Or you can tap and drag the stylus over the range of cells you want included in the chart.
Next, select Menu > Insert > Chart. A wizard will come up and guide you through the rest of the process. Several chart types are available (Column, Bar, Line, Pie, XY Scatter and Area). Five steps are required to complete the wizard.
Don’t hesitate to stop by or give us a call with any document you’d like to create or edit.
