Compaq iPAQ H3000 manual Microsoft Money, Tips for Working in Pocket Excel

Page 71

Tips for Working in Pocket Excel

Note the following when working in large worksheets in Pocket Excel:

•View in full-screen mode to see as much of your worksheet as possible. Tap View then Full Screen. To exit full-screen mode, tap Restore.

•Show and hide window elements. Tap View then tap the elements you want to show or hide.

•Freeze panes on a worksheet. First select the cell where you want to freeze panes. Tap View then Freeze Panes. You might want to freeze the top and leftmost panes in a worksheet to keep row and column labels visible as you scroll through a sheet.

•Split panes to view different areas of a large worksheet. Tap View then Split. Then drag the split bar to where you want it. To remove the split, tap View then Remove Split.

•Show and hide rows and columns. To hide a hidden row or column, select a cell in the row or column you want to hide. Then tap Format, then Row or Column, then Hide. To show a hidden row or column, tap Tools, then Go To, then type a reference that is in the hidden row or column. Then tap Format, then Row or Column, then Unhide.

For more information on using Pocket Excel, tap then Help.

Microsoft Money*

* Available for English operating systems only.

Use Microsoft Money to easily enter and view your financial transactions, check your account balances, and track your investments. If you are using Microsoft Money on your computer, you should synchronize first so that you won’t have to enter your accounts and other required information on your iPAQ H3000 by hand. Before you can synchronize, you will need to run the Setup program found in the MSMoney folder under Extras on the ActiveSync CD. The first time you synchronize, all Microsoft Money information on the iPAQ H3000 will be replaced with information from your computer. If you do not use Microsoft Money on your computer, Microsoft Money on the iPAQ H3000 can still be used to help organize your finances, but you will not be able to synchronize the financial information with your computer.

Companion Programs 5-7

Image 71

Contents Ipaq H3000 Pocket PC IPAQ H3000 Pocket PC Reference Guide Table of Contents Microsoft ActiveSync Microsoft Pocket Outlook Appendix B Character Recognizer B-1 Appendix C Regulatory Notices C-1 Welcome Getting StartedWhere to Find Information Customer Registration Symbols and ConventionsHow to Transfer Palm-size PC Data Front Panel Components Basic SkillsInformation, see Getting Conected Bottom Edge Components Mation, see Reset the iPAQ H3000 and ClearCradle and AC Adapter Power source Recharging the BatteryTo view the Expansion Pack properties Compaq iPAQ Expansion Pack SystemTo add a Compaq iPAQ Expansion Pack To insert a CompactFlash card Compaq iPAQ CF Card Expansion PackTo remove a Compaq iPAQ Expansion Pack To remove a CompactFlash card Guidelines for Using CompactFlash CardsStylus Today Screen Programs Infrared CalendarContacts InboxNavigation Bar and Command Bar Notifications Pop-up MenusEnter Information on Your iPAQ Typing Using the Input PanelTo select typed text To type with the soft keyboardTo use Character Recognizer To select writing Writing on the ScreenTo write on the screen Tap Tools then Recognize To convert writing to textOr, tap the word you want to use To select a drawing Drawing on the ScreenTo create a drawing To create a recording Recording a MessageCustomize Your iPAQ H3000 Adjusting SettingsFind Information Description Setting a PasswordCally adjusts the recording volume Tap , Settings, then PasswordTo add a program to the Start menu Adding or Removing ProgramsTo add programs Tap Remove Programs on the System tab Using File Explorer on your iPAQUsing ActiveSync on the computer To remove programsTap , Settings, System, then Power PowerTo display the Power control panel To set the power off timerTo set the backlight to reverse Adjusting the BacklightTap , Programs then QStart To adjust the backlight time-outQStart Tap , Programs then QMenu QUtilities and QMenuTask Management Self Test File ExplorerTo read the Self Test log file on your computer Contrast Controlling VolumeTap , Settings, System, then Sounds & Reminders Backing up Data to a CF Card Backup and Restore DataTo perform a backup Saving ContactsTap Restore from CF To restore a backup onto your iPAQ Pocket PCMicrosoft Activesync 2Microsoft ActiveSync Microsoft Pocket Outlook Calendar Scheduling Appointments and Meetings To create an appointment Using the Summary Screen To schedule a meeting Creating Meeting RequestsTap to see additional phone num- bers and e-mail addresses Contacts Tracking Friends and ColleaguesTo create a contact 8Microsoft Pocket Outlook Tasks Keeping a To Do List To create a task Microsoft Pocket Outlook 12Microsoft Pocket Outlook To create a note Synchronizing E-mail Messages Connecting Directly to an E-mail ServerInbox Sending and Receiving E-mail Messages Select the service and folder you want to display Using the Message List16Microsoft Pocket Outlook To compose an e-mail message Composing E-mail MessagesFolder behavior with ActiveSync Managing E-mail Messages and FoldersPocket Word Companion Programs2Companion Programs Typing Mode Writing Mode Recording Mode Drawing ModePocket Excel Tips for Working in Pocket Excel Microsoft MoneyTo navigate within Microsoft Money Getting StartedTo create a new account Using the Account Register Entering Transactions Entering and Tracking Investments Windows Media Player for Pocket PC Using Windows Media Manager for Pocket PCWhat is Packaged Content? Microsoft Reader Using the Playlist ManagerReading a Book Using the LibraryGetting Books on Your iPAQ H3000 Using Reader Features Getting Maps on Your iPAQ H3000 Installing Pocket StreetsPocket Streets Removing a BookClick Create Map For Pocket Streets on the Tools menu Creating Map and Pushpin Files for Your iPAQ H3000Viewing Maps Favorite Links Pocket Internet ExplorerMobile Favorites Folder To save iPAQ H3000 memory Mobile FavoritesTo create a mobile favorite To sign up for AvantGo Using AvantGo ChannelsChannels Use Pocket Internet Explorer Using Mobile ChannelsTo view mobile favorites and channels Automatically To browse the WebGetting Connected Tap , Programs, then Infrared Receive Transfer Items Using InfraredTo send information To receive informationTap New connection Connect to an ISPTo create a modem connection to an ISP Connect to Your Network To create a modem connection to a network To create an Ethernet connection to a network Connect Directly to an E-mail Server To set up a e-mail serviceEnd a Connection Inbox Sending and Receiving E-mail Messages in Chapter Get Help on ConnectingResetting the iPAQ Tips and TroubleshootingReset the iPAQ H3000 and Clear Memory Clearing memory Shorten auto-suspend time Battery Loses PowerUse external power whenever possible Turn off notification light If You Forget Your PasswordIf You Run Out of iPAQ H3000 Memory Turn off sounds you don’t needStorage memory Program memory Screen Freezes or Responds SlowlyScreen is Blank Screen is DarkSlow or No Response Infrared IR Connection ProblemsScreen is Hard to Read Inaccurate Response to Stylus TapsCan’t dial out Modem Connection ProblemsConnection is unreliable Can dial out but can’t make a proper connectionCable Connection Problems Network Connection ProblemsRoutine Care Routine MaintenanceBattery Guidelines Shipping Guidelines Travel GuidelinesInternational Travel Character Recognizer Appendix b2Character Recognizer Character Recognizer 4Character Recognizer Regulatory Agency Identification Numbers Regulatory NoticesCables Federal Communications Commission NoticeModifications European Union Notice Battery WarningCanadian Notice Avis CanadienPower Cords System Specifications Hardware SpecificationsOperating Environment Physical Specifications