Join Nick Brazzi for an in-depth discussion in this video Introducing the Google Sheets app, part of Google Docs and Sheets on iOS First Look.
In this movie we're going to look at the Google sheets app. Which allows you to work with the spreadsheets that you have stored on Google drive. This app works very similar to the Google docs app. All of the file creation, editing, and management features are the same. So lets take a look at some of the features that are unique to spreadsheets. So of course I"m goit to start by launching the sheets app. And I'm going to skip this. I'll just hit Get Started. Now if this were the first time you were using any of the Google Apps you would have to log in.
But one really cool thing about using all of the Google Apps is once you've logged into one of them you're logged into all the others. So I'm just going to confirm that this is the account that I want to use. And I'm already logged in. I'm going to opt into the error reporting for Google. I'll just hit Yes I Agree. And here I am looking at a list of all of my spreadsheets. But notice that that's it. It's just spreadsheets. No docs or any other types of files are here. Just spread sheets. So I can sort and even search like I did in the docs app.So if I go into the search field and I search for obstacles, and it narrows the list of my spread sheets down to only the files that have the word obstacle somewhere in the document.
I'm going to go ahead and hit cancel. You can see I have the same sorting options. And of course, I can switch to Preview mode or List mode just like I could in the docs app. All of the file details work the same as well. So if I hit the little i button, I can remove a file, rename it, share the file, all of that stuff. Let me go ahead and close this. But the really interesting stuff is editing a spreadsheet. So, I'm going to go ahead and open up this spreadsheet. We get a couple pop-up windows here. Now, I specifically chose this spreadsheet because it has some advanced features inside of it.
There's charts and graphs and stuff like that. At this time, the app does not support some of these features. So if you get a message like this, you can just hit OKay and just be aware that you're not going to have everything in the document that you might see on Google Drive on your computer. I also see a little Welcome screen and if I swipe through this, its going to walk me through some of the editing features. Just to make sure you know how everything works, but we're going to talk about these here anyway. So I'm just going to hit got it, so the first thing I want to put out is this spread sheet has two tabs on it.
So I can flip between these two tabs, just by taping on the different tabs. And you can see I'm getting that warning again; because this pivot table is not really going to work in the app. So I'm going to hit Okay. I can add new tabs by hitting the little plus button and I can rename those tabs just by hitting this little arrow here. I can rename it or I can delete it. I'm just going to delete it and hit OKay. For now, I just want to focus on this first tab. As you're looking at your spreadsheet, you can zoom in and out, using the pinch gesture.
So I can zoom out there to see everything. Or I might zoom in a little closer just to frame it up to make it easier for me to read what's on here. Of course, I can scroll up and down however I like. Now, I can select any cell to change its formatting. So if I just tap on a cell, that cell is selected. And I get all of my formatting options up here at the top. There are normal formatting options like. Bold, italics, underline, stuff like that. I can also change the alignment of the text in this cell so I could center it in the cell.
I'll put that back to left. Or I can use this option to align it to the top, middle, or bottom, of the cell. I'm going to tap out of this. And I'm just going to hit Undo until I get this text back to how it was when I started. There we go. Now, if I go into the Fonts option, of course I can change which font this text appears in. We'll take a step back. I can change the size of that text by tapping this plus, and minus, button here.
You can see now that that text is bigger. I'm going to go back in. I'm going to tap the minus to make it smaller again. But this is also the panel where you're going to get background and text color. So sometimes you want to change the background color of a cell. You can do that right here. So I'll highlight this one in yellow. That's what I usually do when I want to bring my attention to edit something later. I can also format cells. So I'm going to select one of these cells here which has a $ value in it. One very important thing to do in a spreadsheet is format how numbers are displayed.
This number is formatted as currency. But I can easily change that. I just hit the cell's button. And I get all of my formatting options here. I'm going to dive a little deeper into format. And you can see here's where we can change all these different numbering format options. So maybe I wanted this to be just a simple number. I can set that. Now the $ sign goes away. If I wanted this as a percent, I could change that. Now in this case I do want to just go ahead and go back to currency, so I can select that one.
Now, editing information in a spreadsheet is a little more complex than editing a doc. So lets take a look at how you can select and make changes to the text inside of these cells in the spreadsheet. Now as we've seen, if you just tap on a cell, that cell, is selected. This is what we did to change the formatting. Now I could select multiple cells, by tapping on a cell, like this, and then grabbing the selection handles. And stretching that selection down. And I can even select cells to the left or right. Let me go back to just a chunk of cells here.
And of course, I can do the things that we did before. I can change the formatting. I can change the font. I could highlight all of these as yellow, if I wanted, all at the same time. So, if I select a range of cells, I can make formatting changes to them all together. So, a single click selects the cell. But, if I want to change the content of a cell, I need to double-tap on that cell. So, I'm going to double tap on this cell. And now, I can edit it. And I get this formula bar, down here at the bottom, and this is where I can change the contents of the cell.
So maybe I just want to change this to yellow. And when I'm done editing the contents of that cell, I just hit the check box. So that's how you edit the contents of the cell, you double tap on it. If I select a cell, wait for just a moment and then tap on it a second time. This is where you get your options for cut, copy, paste, and clear. So if you want to copy, and paste, the contents of a cell, this is how you would do that. So, a quick double tap. To edit the contents of a cell. But a tap, pause, and another tap will let you do copy, cut, paste, all that stuff.
Now, of course, I can select and edit individual cells. But you can also select entire rows, or columns. So if I were to just tap on one of the row numbers here, that entire row is selected. You can see, I can copy, paste. I can even insert to add. Extra rows. So now I've added an empty row here. I'm going to undo that. Another cool thing is that I can drag across multiple rows to select several at a time. Now I can change the formatting for all of these cells.
If I want to insert more than one row, say I want to insert maybe four rows. What I can do is, I can drag across to select four rows. And now this option Insert changes to Insert for, before or after. I can also choose to delete all of these four rows at the same time. So if I insert four rows before,. There we go. So, if you want to insert eight rows, you just select any eight rows, and then do the insert. I'll undo this as well.
Finally, spreadsheets just wouldn't be complete without formulas. I can add a formula to any cell, and let's do that, I'm just going to add a new row down here at the bottom. I'm going to tap on this new cell I've placed down at the bottom of all these numbers. And to insert a formula, all you need to do is edit that cell. Remember, double tap. And then you're going to type in the equals sign here in the formula bar, and then type out the rest of your formula. Now you can learn all about how formulas work by watching the Google Drive Essential Training course or even the Excel Essential Training course.
For now, let's just add a good, old sum formula, to add up all the $ amounts in this spreadsheet. So I've already typed in the equal sign. And I'm going to type in the command for sum. And within parentheses I'm going to type in the range of cells that I want to add together. Some I'm going to do everything in column E from rows 7 to 44. 7 to 44, would be all of our $ values. So, I'm going to do. E7:E44, close the parentheses, hit the check box, and now I've got a sum total of all of the values in the range that I selected.
So that's just one simple formula, and of course, when I'm done editing this document, I can hit. The Check button to save it. And I can hit the X to exit it. And again I can create a new spreadsheet just by hitting the Plus button up here at the top. I'll give it a name, hit Create and begin with a fresh spreadsheet. I'll go ahead and jump out of this. And, of course, I have all of my sharing options inside of the file details on any of these spreadsheets.
So that's the Google Sheets app. You can quickly create and edit spreadsheets all on your iPad and iPhone.