Monday, July 2, 2018

Use Excel Mobile for Windows Phone

Use Excel Mobile for Windows Phone

Want to review and make changes to a spreadsheet someone sent you in email? Or maybe even create a new Microsoft Excel workbook while you're away from your computer? With Microsoft Excel Mobile you can do this and more right from your phone. To get started, go to the Office Hub.

Workbook opened in Excel Mobile

To open an Excel workbook

  1. In the App list, tap Office Office icon .

  2. Do one of the following:

    • In Places, tap the place that the workbook is in, and then tap the workbook. It can be in any of these places—on your phone, in email, on OneDrive, on a Microsoft SharePoint 2010 or later site, or on a SharePoint Online site, which is available with Microsoft Office 365.

    • Flick to Recent, and tap a workbook you recently opened.

    • Tap Search Search icon . In the Search box, start typing the workbook name, and then tap the workbook when you see it.

      Notes: 

      • Excel Mobile doesn't support all the features and functions that are found in Microsoft Excel 2010 or later. If a workbook has content that's not supported, you can still open the workbook. The unsupported content won't be displayed though, and you might not be able to edit the workbook on your phone. If a function isn't supported, the calculated value will still appear in the cell, but you won't be able to edit the workbook on your phone. To learn more, see this Microsoft Support article about what content is supported in Excel Mobile.

      • Looking for a workbook you already opened from email? Just flick to Places, tap Email, and then tap the workbook.

      • To use workbooks stored on OneDrive, a Microsoft account must be set up on your phone. For more info about saving and syncing documents on OneDrive, see Sync documents with OneDrive.

      • To learn about using workbooks that are on a SharePoint or SharePoint Online site, see Work with documents on SharePoint.

      Tips: 

      • If you have a workbook you use a lot, you can pin it to Start. In the Office Hub, flick to Recent, tap and hold the workbook, and then tap Pin to start.

      • To view different parts of the worksheet, you can zoom in and out by pinching and stretching your fingers.

To create and save a new Excel workbook

  1. In the App list, tap Office Office icon .

  2. Flick to Recent, tap New New document icon > Excel, or tap one of the Excel templates.

  3. After you make changes, tap More More icon > Save.

  4. Type a name in the File name box, and then tap the Save to list > OneDrive or Phone > Save.

To enter numbers and text

  1. In a workbook, tap a cell in the worksheet where you want to add a number or text, and then tap the formula bar next to Function Function icon .

  2. Type a number or text, and then tap Enter Enter icon .

  3. To enter a number or text in another cell, tap the cell, and then type.

  4. When you're done entering data, press the Back Back button button on your phone so the keyboard doesn't display.

  5. To delete the content in one or more cells, do one of the following:

    • To delete the contents in one cell, tap the cell that has the text or numbers you want to delete, tap the text or numbers in the formula bar to select the content, and then tap Delete Delete icon > Enter Enter icon .

    • To delete the contents of more than one cell, tap a cell, drag the circles to select the range of cells, and then tap More More icon > Clear contents. Tap a cell.

  6. To undo the last change you made, tap More More icon > Undo. Tap a cell.

  7. To redo the last change you undid, tap More More icon > Redo. Tap a cell.

To calculate numbers quickly (AutoSum)

You can use AutoSum to calculate the sum, average, maximum, minimum, and number of values in a range of cells.

  1. In a worksheet, tap the first empty cell after a range of cells that has numbers or tap and drag to select the range of cells you want to calculate.

  2. Tap AutoSum AutoSum icon .

Note: To use a function in a formula to calculate numbers, tap the cell that you want to add the function in, and then tap Function Function icon next to the formula bar. Choose the function you want to use from the list, tap and drag or type to enter the values, text, or cell references to use, and then tap Enter Enter icon . For more info about using formulas and functions in Excel, see Overview of formulas on the Microsoft Office website.

To sort numbers

  1. In a workbook, tap the first cell in the range of cells you want to sort, and then drag the bottom circle to the last cell in the cell range you want to sort.

  2. Tap Sort Sort icon > Sort by > column you want to sort by, and then do one of the following:

    • To sort numbers from highest to lowest, tap Sort order > Descending.

    • To sort numbers from lowest to highest, tap Sort order > Ascending.

  3. Tap Done.

Note: To add another column to sort by, tap More options > Then by > the next column you want to sort by > Sort order > Ascending or Descending > Done.

To switch between worksheets or charts in a workbook

  1. In a workbook, tap Sheets Sheets icon .

  2. Tap the worksheet or chart you want to view.

To add a comment

  1. Tap a cell in the worksheet where you want to add a comment.

  2. Tap More More icon > Comment. Type your comments. (If this is the first time you're adding a comment, you'll be asked to enter a user name so that other people will know who edited the workbook. You can change your user name later by tapping Settings Settings icon in the App list, flicking to Applications, and then tapping Office > User name.)

  3. Tap outside the comment box to stop commenting.

  4. To view the comment, tap the cell with the comment in the worksheet.

  5. To delete the comment, tap the cell with the comment, tap More More icon > Delete comment.

To find a specific word or number

  1. In a workbook, tap Find Search icon .

  2. Type the word or number you want to find, and then tap Enter Enter icon .

  3. Tap Next Next icon to find the next occurrence.

  4. Tap anywhere in the worksheet to stop searching.

To send a workbook in email

  1. In the App list, tap Office Office icon .

  2. Do one of the following to find the workbook you want to send:

    • For a workbook you already opened, flick to Recent.

    • Flick to Places and tap the place that the workbook is in.

    • Tap Search Search icon and search for the workbook.

  3. Tap and hold the workbook, tap Share, and then tap the email account name.

  4. Add the recipient and any other information to your email, and then tap Send Send email icon .

No comments:

Post a Comment