Me and my docs

Edit an Excel spreadsheet on an iOS device

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

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.

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.

Want more?

Basic tasks in Excel Online

Collaborate with others on a workbook

Office 365 install and setup - Help

You can edit a spreadsheet on an iOS device by using the Excel app.

Here I have my budget workbook open on my iPad. Right now, it’s in read-only mode.

I want to make a few changes, so I’ll tap Edit.

First, I’ll update the title of the file.

I’ll tap this green checkmark to accept the change.

I want to enter new values in the quantity and cost columns, but I don’t want to delete the formulas in the cells. So, I’ll clear the entries instead.

That way, my formulas will still work when I enter new quantities and costs later.

And I’ll add a note to one of the items.

Well, that’s enough for now.

My changes are saved automatically so all I need to do is close the file.

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×