How to Edit Google Sheets on Your iPad
Google Sheets works great when you’re using your computer, but how well can you edit while using your iPad? When you’re on the go, using a tablet to work on your spreadsheets is incredibly convenient.
In this article, we’re going to elaborate on how to edit and format Google Sheets files using only your iPad.
Editing and Formatting Google Sheets
To make the most of Google Sheets on your iPad, it’s essential to download the latest version of the Google Sheets app from the App Store first.
If you already have it in your device, then it’s best to make sure you’re using the app’s updated version. What you do in a Google Sheets file in terms of editing and formatting can be incredibly diverse.
But there are some simple guidelines that are the basis of every spreadsheet you’re going to work on. Here’s what that will look like in a nutshell:
- Launch your Google Sheets app on the iPad and open a spreadsheet.
- To edit a single cell, you need to tap on it.
- Then, enter the data you want.
- If you need to format the text you’re entering, all you have to do is touch and hold until you see the options panel.
- When you’re done entering data and editing, select “Done”.
That’s what editing in Google Sheets is going to look like more or less. It’s also handy to remember that you have the “undo” and “redo” actions, which are essential for editing in any file, including a Google spreadsheet. You’ll see these actions on the top of your iPad’s screen.
More About Formatting Google Sheets Cells
When you’re working on a spreadsheet on a computer, the toolbar and all the options are easier to find and navigate. On mobile devices, such as iPad, it can be frustrating to figure out where all the functions you’re looking for are.
Besides, the Google Sheets app is always going to have fewer options for editing and formatting than the web version. However, let’s see how to navigate through the formatting in Google Sheets.
- Launch the Google Sheets app and then a spreadsheet file.
- Select a single cell and drag the markers over the cells you want to select.
- Select “Format”.
- Then, select the “Text” tab and choose one of the options.
As in all G Suite files, you’ll be able to choose the formatting of the text (Bold, Italic, Underline) and how you want to align it in the file. You can also choose the “Cell” tab to select how you want to format the cell.
You can pick the color, borders, wrap text, and how to merge cells. Once you’re done with formatting, all you need to do is tap anywhere on the sheet and save all the changes.
Can You Edit Google Sheets in Safari on the iPad?
All Apple products come with the pre-installed default browser Safari. And even though all G Suite tools, like Google Sheets, are most compatible with the Chrome browser, you can use them with Safari too.
However, in the mobile version of Safari, editing, and formatting Google Sheets isn’t possible. So, if you were trying to avoid downloading the Google Sheets app and saving the storage, you’re out of luck.
What you can do, however, is view the spreadsheet. Plus, you can also print it directly or email it to someone. But you should keep in mind that you have to enter drive.google.com URL in the Safari address bar.
That’s because if you choose the sheets.google.com, you’ll be prompted to download the app. Then, all that’s left to do is find the document you want to view, print, or email.
How to Share Google Sheets File on iPad
All of your Google spreadsheets and other Google documents are automatically saved in Google Drive. When you want to share a document, you need to go directly to the Drive and do it from there. Here’s how it’s done:
- Tap on the file you want to share.
- Select the three horizontal dots in the top right corner of the screen.
- From the drop-down menu, select “Share & Export”.
- Select “Add people”.
- Enter the email addresses of the people you want to share the spreadsheet with. You can even write a message.
- Choose whether you want them to “View, Edit, or Comment” on the document.
- Finally, hit the “Send” icon.
Creating the Best Google Spreadsheets
The editing and formatting process in Google Sheets can be as straightforward or as complicated as you make it. If you’re trying to become a Google Sheets pro, you’ll quickly realize that there’s a lot you can do with it.
But for most people, knowing how to tackle the basic principles of Google Sheets editing will be more than enough. And don’t worry if you forgot to save changes, Google Sheets does that for you on its own.
How often do you use Google Sheets? Let us know in the comments section below.