How to Edit Google Sheets on Mobile

This wikiHow teaches you how to open and edit a spreadsheet in Google Sheets on your phone or tablet. Before you get started, you'll want to upload your spreadsheet to your Google Drive if you haven't already done so. You'll also need the Google Sheets app, which you can download for free from the App Store or Play Store.

[Edit]Steps

[Edit]Opening the Spreadsheet

  1. Upload the spreadsheet to Google Drive. If you made the spreadsheet yourself or someone else shared it with you, you can skip this step, as the file is already in your Google Drive. If you haven't already installed Drive, you can download it from the Play Store (Android) or App Store (iPhone/iPad). Then, use these steps to upload the spreadsheet:
    Edit Google Sheets on Mobile Step 1.jpg
    • Tap the + at the bottom-right corner and select Upload.
    • Tap Browse.
    • Select your spreadsheet to upload it.
  2. Open Google Sheets. It's the icon with a green sheet of paper and a white table inside.
    Edit Google Sheets on Mobile Step 2.jpg
    • If you haven't already installed Google Sheets on your phone or tablet, you can get it for free from the Play Store (Android) or the App Store (iPhone/iPad).
    • If you're not already signed in, tap SIGN IN at the bottom-left corner to log in with your Google account.
  3. Tap the folder icon. It's in the bar at the top of the screen. This opens the "Open a file" menu.
    Edit Google Sheets on Mobile Step 3.jpg
  4. Tap . This takes you to your Google Drive.
    Edit Google Sheets on Mobile Step 4.jpg
    • If you received an email or notification that someone shared a Google Sheets file with you, tap Shared with me to view shared files. You can also tap the link in the message you received from the person sharing the file to open it in Sheets.
  5. Tap the spreadsheet to open it. This opens the spreadsheet for editing.
    Edit Google Sheets on Mobile Step 5.jpg
    • You can close the spreadsheet at any time by tapping the back button at the top-left corner.
    • Any changes you make to the spreadsheet while editing will save automatically.

[Edit]Editing a Cell

  1. Double-tap a cell. This opens the keyboard and allows you to edit or enter data.[1]
    Edit Google Sheets on Mobile Step 6.jpg
    • You can also tap the cell once and tap the pencil icon at the bottom-right corner to open the cell for editing.
  2. Type into the cell. If you want to enter a value, just type it right into the cell. If you want to enter a formula, type it into the "fx" bar above the keyboard.
    Edit Google Sheets on Mobile Step 7.jpg
  3. Format text inside your cell. To change the way the text looks while editing a cell, tap and hold the text you want to format, and then choose one of the formatting options at the bottom of the screen.
    Edit Google Sheets on Mobile Step 8.jpg
    • Tap the B to make the text bold.
    • Tap the underlined A to select a text color.
    • Tap one of the sets of horizontal lines to align the text in the desired position.
    • Tap the tilted paint can to select a cell background color.
    • For additional options, tap the A at the top to expand the formatting panel at the bottom of the screen. See the Formatting Cells method for more information on the formatting options.
  4. Tap the checkmark to close the keyboard. This returns you to the primary spreadsheet view.
    Edit Google Sheets on Mobile Step 9.jpg

[Edit]Formatting Cells

  1. Select the cells you want to format. If you want to add special formatting to one or more cells, such as colors and text styles, you'll need to select the cells first. To do this, tap one cell you want to format, and then drag one of the blue dots at its corner to highlight all cells you want to format.
    Edit Google Sheets on Mobile Step 10.jpg
  2. Tap the at the top. This opens the formatting menu at the bottom.
    Edit Google Sheets on Mobile Step 11.jpg
  3. Use the options on the tab to format text. Here you can:
    Edit Google Sheets on Mobile Step 12.jpg
    • Make the text bold, italicized, underlined, and/or strike-through.
    • Tap one of the alignment options (the horizontal lines) to left-align, right-align, or center the text.
    • Use the options with horizontal lines and arrows to align the text to the top, middle, or bottom of each cell.
    • Scroll down to adjust the font size, text color, font face, and rotation.
  4. Use the options on the tab to format the cell(s). This tab is to the right of the Text tab at the top of the menu panel. Here you can:
    Edit Google Sheets on Mobile Step 13.jpg
    • Tap Fill color to apply a color to the background of the selected cells.
    • Tap Borders to customizes the lines around each cell.
    • Choose to wrap text in each cell.
    • Merge the existing cells into a single cell.
    • Adjust the number format (for dates, times, currencies, etc.) and decimal places.

[Edit]References

[Edit]Quick Summary

Comments

Popular Posts