Edit an Excel spreadsheet on a tablet

Office Training Center > Office 365 scenario-based training > Me and my docs

Back to previous page Go to next page

With Office 365 and Excel on your tablet, you can edit a spreadsheet from wherever you are. Watch the video to see how this works using Excel for iPad, and scroll down to see how to perform this task across a variety of devices.

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Try it!

The following procedure describes how to perform this task using Excel for iPad. However, you can use another device as well. See Specific "how to" instructions for your device.

To edit a spreadsheet using Excel on an iPad
  1. Begin with your spreadsheet open in Excel for iPad.

  2. Tap Edit.

  3. To edit the contents of a cell, tap to select that cell, and then type your entry. Tap the green checkmark to enter your edited text.

  4. To clear entries from multiple cells, select a cell by tapping and holding it, and then drag to select additional cells. Then, in the context menu that appears, choose Clear.

  5. When you're done editing, save and close the file.

Specific "how to" instructions for your device

To edit a spreadsheet using Excel on your computer or tablet
  1. Begin with your spreadsheet open in Excel 2016 on your computer.

    If the file is in read-only mode, enable editing. And, if you see a security warning, choose Enable Content.

  2. To edit the text in a cell, select that cell, and then type your entry. Then press Enter.

  3. To clear entries from multiple cells, select a cell by clicking (or tapping) and holding it, and then drag to select additional cells. Then, either right-click (or tap your selection), and then choose Clear Contents (or Clear).

  4. When you're done editing, save and close the file.

To edit a spreadsheet using Excel on your Mac computer
  1. Begin with your spreadsheet open in Excel 2016 for Mac on your computer.

    If the file is in read-only mode, enable editing. And, if you see a security warning, choose Enable Content.

  2. To edit the text in a cell, select the cell, and then type an entry in that cell. Press Enter to enter your text in the cell.

  3. To clear entries from multiple cells, select a cell by clicking and then drag to select additional cells. Then, press CTRL+B.

  4. When you're done editing, save and close the file.

To edit a spreadsheet using Excel on your Android phone or tablet
  1. Begin with your spreadsheet open in Excel for Android phones or tablets.

  2. Tap Edit.

  3. To edit the contents of a cell, tap to select that cell, and then type your entry. Tap the green checkmark to enter your edited text.

  4. To clear entries from multiple cells, select a cell by tapping and holding it, and then drag to select additional cells. Then, in the context menu that appears, choose Clear.

  5. When you're done editing, save and close the file.

To edit a spreadsheet using Excel on your iPad or iPhone
  1. Begin with your spreadsheet open in Excel for iPad.

  2. Tap Edit.

  3. To edit the contents of a cell, tap to select that cell, and then type your entry. Then, tap the green checkmark.

  4. To clear entries from multiple cells, select a cell by tapping and holding it, and then drag to select additional cells. Then, in the context menu that appears, choose Clear.

  5. When you're done editing, save and close the file.

To edit a spreadsheet using Excel on your Windows Phone
  1. Begin with your spreadsheet open in Excel for Windows Phone 10 on your Windows Phone.

  2. To edit the contents of a cell, tap to select that cell, and then in the formula bar, type your entry. Press Enter.

  3. To clear entries from multiple cells, select a cell by tapping and holding it, and then drag to select additional cells. Then, tap the ellipses and choose Clear Contents.

To edit a spreadsheet using Excel Online on your device
  1. Begin with your spreadsheet open in your browser on your device.

  2. Choose Edit Workbook > Edit in Excel Online.

  3. To edit the contents of a cell, select that cell, and then type your entry. Press Enter to enter your text in the cell.

  4. To clear entries from multiple cells, select a cell by clicking (or tapping) and holding it, and then drag to select additional cells. Then, in the ribbon, choose Clear > Clear Contents.

When you edit a spreadsheet in Excel Online, your changes are saved automatically.

Additional resources

Top of module

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×