Download Article
Download Article
You can use the Google Sheets mobile app to create, edit, and view spreadsheets on your Android, iPhone, or iPad. You'll just need to install the Google Sheets app from the App Store or Play Store, which makes it possible to open spreadsheet files in an editable format. This wikiHow article will show you how to open and edit a spreadsheet in the Google Sheets app on your phone or tablet.
Steps
-
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:
- Tap the + at the bottom-right corner and select Upload .
- Tap Browse .
- Select your spreadsheet to upload it.
-
Open Google Sheets. It's the icon with a green sheet of paper and a white table inside.
- 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.
Advertisement -
Tap the folder icon. It's in the bar at the top of the screen. This opens the "Open a file" menu.
-
Tap My Drive . This takes you to your Google Drive.
- 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.
-
Tap the spreadsheet to open it. This opens the spreadsheet for editing.
- 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.
Advertisement
-
Double-tap a cell. This opens the keyboard and allows you to edit or enter data. [1] X Research source
- You can also tap the cell once and tap the pencil icon at the bottom-right corner to open the cell for editing.
-
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.
-
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.
- 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.
-
Tap the checkmark to close the keyboard. This returns you to the primary spreadsheet view.
Advertisement
-
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.
-
Tap the A at the top. This opens the formatting menu at the bottom.
-
Use the options on the Text tab to format text. Here you can:
- 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.
-
Use the options on the Cell 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:
- 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.
Advertisement
Expert Q&A
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
Advertisement
Tips
Submit a Tip
All tip submissions are carefully reviewed before being published
Thanks for submitting a tip for review!
About This Article
Article Summary
X
1. Upload the spreadsheet to Google Drive.
2. Open Google Sheets.
3. Tap the folder icon.
4. Tap My Drive
.
5. Tap the spreadsheet.
6. Double-tap a cell to edit it.
7. Tap the A
button at the top to open format options.
Did this summary help you?
Thanks to all authors for creating a page that has been read 55,777 times.
Advertisement
