← Bluetooth Settings

Word Mobile →

Excel Mobile

October 22nd, 2007 | Uncategorized
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.

0 comments ↓

There are no comments yet...Kick things off by filling out the form below.

Leave a Comment