|
|
|
|
Home Page
Tip of the Day
CE Top News Stories
CE Personal Productivity Solutions
CE Enterprise Productivity Solutions
Business Solutions Journal
Contact Us
Past Tips About...
| Pocket PowerPoint | World Clock | Calender |
| Pocket Excel | ||
| Misceleaneous tips |
Pocket Excel Tips
Past Pocket Excel tip of the day from:
APR.-23/99
How can I delete a worksheet from a Microsoft Pocket Excel file?
APR.-22/99
How can I add a new worksheet into a Microsoft Pocket Excel file?
APR.-21/99
How can I change the name of worksheet in a Microsoft Pocket Excel file?
APR.-20/99
How can I view a different worksheet in a Microsoft Pocket Excel file?
APR.-19/99
How can I sort a list of data into alphabetical order in a Microsoft Pocket Excel file?
APR.-16/99
How do I delete a cell from a Pocket Excel worksheet?
APR.-15/99
How do I insert a new cell into a Pocket Excel worksheet?
APR.-14/99
How do I format a cell in a Pocket Excel worksheet?
APR.-13/99
How do I change the font size of text in a Pocket Excel worksheet?
APR.-10/99
How do I resize a column in a Pocket Excel worksheet?
APR.-9/99
How do I add up data in Pocket Excel?
APR.-8/99
What types of data can I enter into a Pocket Excel file?
APR.-6/99
How do I create a Pocket Excel file?
APR.-5/99
What does Pocket Excel allow me to do?
Tips -Apr. 23/99
How can I delete a worksheet from a Microsoft Pocket Excel file?
If you need to delete a worksheet from a Microsoft Pocket Excel workbook, tap Format>Sheet>Modify Sheets. Then select the name of the worksheet that you want to remove and tap the Delete button in the Modify Sheets dialog box.
A confirmation message appears on the screen asking you to confirm your selection. To delete the worksheet, tap the Yes button.
Back to top
Home
Tips -Apr. 22/99
How can I add a new worksheet into a Microsoft Pocket Excel file?
If you need to add a new set of data into a Microsoft Pocket Excel workbook, you can create a new worksheet. To do this, first tap Format>Sheet>Insert and a new worksheet will appear. Here is the new worksheet I have created.
Back to top
Home
Tips -Apr. 21/99
How can I change the name of worksheet in a Microsoft Pocket Excel file?
Changing the name of a worksheet in a Microsoft Pocket Excel file can make it a lot easier you to find the data you need when you need it. To change the name of worksheet, tap Format>Sheet>Rename and the Rename Sheet dialog box will appear, as shown in the screenshot below. Then type the new name of the worksheet in the Sheet name field before tapping the OK button.
Back to top
Home
Tips -Apr. 20/99
How can I view a different worksheet in a Microsoft Pocket Excel file?
Every Microsoft Pocket Excel file comes with three worksheets for you to input and view data. To view a different worksheet within the file, tap Format>Sheet>Modify Sheets, and the following dialog box will appear.
Then highlight the worksheet you want to view and tap the OK button.
You can also view another worksheet by tapping the sheet name button at the bottom of the screen, as shown in the screenshot below. Tap the name of the worksheet you want to view on the menu that appears.
Back to top
Home
Tips -Apr. 19/99
How can I sort a list of data into alphabetical order in a Microsoft Pocket Excel file?
If, for example, you have written down a list of the names of attendees participating in a training course, you may need to sort them into alphabetical order for easy searching and filing. This task is easy to do using the Sort option in Pocket Excel.
First highlight the names that you wish to sort by selecting them with your stylus, as shown in the screenshot below. Please note that Pocket Excel only sorts data in columns; you cannot sort data by rows.
Then tap Tools>Sort and the Sort dialog box will appear as shown in the following screenshot. The Sort dialog box automatically selects the columns of cells that you highlighted and automatically sorts the data in Ascending Order. If you want to sort the data in Descending Order, simply tap the Ascending check box.
Once you have set the parameters for your Sort tap the OK button, and the data will be automatically sorted, as shown in the screenshot below.
Back to top
Home
Tips -Apr. 16/99
How do I delete a cell from a Pocket Excel worksheet?
To delete a cell, first select the cell that you want to remove by tapping on it with your stylus. Then tap Format>Delete Cells to show the Delete Cells dialog box, as shown in the screenshot below.
Finally, select the appropriate radio button to determine how you want the cell to be deleted from the worksheet, before pressing the OK button.
Tips -Apr. 15/99
How do I insert a new cell into a Pocket Excel worksheet?
From time to time, it may be necessary to add a new cell into a Pocket Excel worksheet in order to enter more data.
To insert a new cell, tap Format>Insert Cells to display the Insert Cells dialog box, as shown in the screenshot below. Then select the appropriate radio button to determine how you want the cell to be inserted into the worksheet, before pressing the OK button.
Back to top
Home
Tips -Apr. 14/99
How do I format a cell in a Pocket Excel worksheet?
Another way of highlighting data or headings in your Pocket Excel worksheet is to format the cells by changing the background color. To do this, first select the cell(s) you wish to format by tapping on it with your stylus. Then tap Format>Cells and the Format Cells drop down menu will appear. You should then select the Border and Fills button, as shown in the screenshot below.
From the Format Border & Fills drop down menu you can choose which border lines you want to format, the color of the Borders, and the color of the Fills. The Sample Box will show what the cell(s) you have selected will look like. Once you have determined the format of the cell(s), press the OK button. The cells you have selected will be formatted automatically.
Back to top
Home
Tips -Apr. 13/99
How do I change the font size of text in a Pocket Excel worksheet?
Changing the size of a font can be a good way of highlighting particularly important text within a spreadsheet. To do this, first select the cell containing the text you wish to format by tapping on it with your stylus. Then tap Format>Cells and the Format Cells drop down menu will appear, as shown in the screenshot below.
From the Format Cells drop down menu, tap on the Font button. Then you can select the Font type, size and color that you require. You can also decide whether you want the text to be Bold, Italic, or Underlined. Once you have determined the format of the text, press the OK button. The text in the cell you have selected will be automatically formatted.
Back to top
Home
Tips -Apr. 10/99
How do I resize a column in a Pocket Excel worksheet?
On many occasions you will need to resize a column in a Pocket Excel worksheet so that you can read the contents of the cells better or accommodate a larger font size.
The easiest way to resize a column is to select the column by tapping on the top cell with your stylus. Then tap on the line on the right side of the column, hold the stylus down, and drag the line until the column is the size you want it to be. When you tap the line, the cursor will turn into a double-headed arrow, as shown in the screenshot below.
Another way to resize the column is to first select the column, and then tap Format>Column. The drop-down menu lets you determine the Width of your column or even to Autofit the column to fit your text. You can also choose to Hide or Unhide the column as well.
Back to top
Home
Tips -Apr. 09/99
How do I add up data in Pocket Excel?
To add up data in a Pocket Excel spreadsheet, first enter the numeric values that you wish to add into the cells in a column or row, as shown in the screenshot below.
The select the cell below the numerical values (in this case B6) by tapping it with your stylus, and tap the AutoSum button located on the top of the screen next to the Currency ($) button. The formula appears in the Formula Bar at the top of the worksheet; in this case it is =SUM(B3:B5).
Then tap the check mark button, and the answer appears in the cell you have selected, as shown in the screenshot below.
Back to top
Home
Tips -Apr. 08/99
What types of data can I enter into a Pocket Excel file?
Pocket Excel allows you to add a wide variety of data types into your file, including text, numbers, currencies, percentages, dates, and times. More detailed information is provided in the table below:
| Data Type | Description |
| Text | -You can enter up to 255 characters
of text into a single cell. -The program automatically justifies the text on the left side of the cell. |
| Numbers | -You can enter numeric values of up to 15 digits. -The program automatically justifies the numbers on the right side of the cell. |
| Currencies | -You can format a cell for currency by selecting the cell and tapping the currency button, which is labeled with a $. -The program automatically justifies the currency amount on the right side of the cell. |
| Percentages | -You can enter a percentage by typing a number followed by the % sign (eg 50%). -Alternatively, you can format the cell as a percentage and then enter a decimal value (eg 0.5). |
| Dates | -You can enter dates by using the - or / character to separate the month, date, and year (eg 11/09/65 for 9 November 1965). |
| Times | -You can enter time by the 12-hour and 24-hour clocks. -If you enter time by the 12-hour clock, you need to type am or pm after the time (eg 6:00 pm). -If you enter time by the 24-hour clock you need to type a colon between the hour and minutes value (eg 18:00). |
Back to top
Home
Tips -Apr. 06/99
How do I create a Pocket Excel file?
To create or open a Pocket Excel File on your Handheld PC, tap on the Pocket Excel icon on your Windows CE desktop or tap Start>Programs> Office> Pocket Excel, as shown in the screenshot below.
Then a blank new Pocket Excel workbook will appear. You can either create your new spreadsheet using this blank workbook or select a preformatted template by tapping File>New>Workbook from Template, as shown in the illustration below.
Pocket Excel offers a choice of three pre-formatted template files: Amortize, Expense Report, and Mileage Log. In addition, you may want to create your own template files, perhaps using standard company formats. Tips on how to create and use Pocket Excel template files will be posted on the Windows CE Business Solutions Home Page at a later date.
Back to top
Home
Tips -Apr. 05/99
What does Pocket Excel allow me to do?
Like Microsoft's Excel program, Pocket Excel is spreadsheet application that allows you to calculate your expenses, log your mileage, and manage other types of numerical and financial business data. Pocket Excel comes bundled with all Windows CE Handheld PC and Handheld PC Professional devices, but not with Palm-size PCs.
Pocket Excel files are compatible with Excel files on your PC, so when you transfer them to your computer using ActiveSync they will automatically be converted to the standard .xls format. Similarly, when you synchronize an Excel file to your Handheld PC, it will automatically be converted to Pocket Excel (.pxl) format.
Back to top
Home
Tips -Apr. 02/99
How do I change the name of a Palm-size PC Note Taker file?
One of the most irritating features of the Note Taker application is that it doesn't give you the option to decide the name of a file when you save it. Instead, it names the file automatically using the words on the first line of the document, so you can end up with a list of files with bizarre names like "Here is a list" and "No 188" as I have here:
One solution is to write in a title on the first line of your file, but often you don't have time do this. After all, Palm-size PCs are designed for jotting down notes on the fly, not creating fancy documents. The other solution is to save the file under another name using the Save As feature.
To do this, tap File>Save As, and the following dialog box will appear. Tap in the new file name using either the soft keyboard or Jot Handwriting Recognition application, and then press the OK button.
If you want to change the file type to a .txt or rtf. file or save the file in a different location, you can tap the Options button and the following dialog box will appear.
If you want to create new folder for the file, or save the file in a different folder, tap the Create In button and the following dialog box will appear.
Back to top
Home