How to Use Spreadsheets in Google Documents

Video Transcript

"MAN: Before I move on and show you some of the more advanced features of this Google Spreadsheet, I just want to go over some of the basics of working in the spreadsheet and with the cells down here. If you've ever worked with Excel or OpenOffice or--like Numbers on a Mac, you kind of have an idea of how a spreadsheet program works. And Google Spreadsheet is pretty similar in a lot of ways to that. But let me just show you to adjust the width of a column, you can just click on the edge and drag it. And to do multiple columns, you select them and then the one you're dragging, both columns will go to the length of that one when you finish. So I've got multiple and selected A and B, but it will reduce it back to the--A back to the link I dragged B to, and that applies for rows as well. Just selecting multiple rows, I just shift or I can click and drag, that kind of thing. If I got some text here and I want to copy it in rows below, I can just kinda drag it down, and it will copy it. Another cool way to copy besides using the--just--instead of just like cutting this and copying it somewhere else, I can do a drag and copy by mousing over until I get the little hand, and then I click and you see it has a little gray box and then you just cut it from right here and move it to over here. So it's a really quick way to avoid having to cut it or copy and cut it and then paste it somewhere else. Some other stuff, you can add a sheet just like you can in Excel. So I have this spreadsheet and then I can add a sheet and now we have two spreadsheets in the same saved spreadsheet, if that makes sense like two sheets. And that's how they refer to them as a sheet in the spreadsheet. And just to move them around, I can change the order of this by clicking on the little drop down and then you'll have a Move Left or Move Right if they're more over here. Rename it, Duplicate it and Delete it. And one last thing about basics, when you start a Google document it automatically saved it, the first words that you wrote at the top of the document, that is not the case here on Google spreadsheets. So what I want to do is when I start, I want to go ahead and save it as soon as possible 'cause otherwise you're editing an unsaved document and if for some reason your Internet crashed or your computer crashed, you might lose it so you want to save it. And once you save it and give it a name, you'll see the names up here and I can change the name by clicking on it. But once you actually save it for the first time, Google start autosaving very frequently so you don't have to worry about when your computer does--if your computer does crash or your Internet crashes or something 'cause it's going to autosave a lot. One last thing I want to talk about is I'll just talk about the basics of using your work area here in Google Spreadsheet is the Merge across which you just want to select the number of cells you want to merge and then you can merge them by clicking Merge across. And now you can see they are merged across like this and [INDISCERNIBLE] separate it. So you can do this to kinda customize your worksheet and you can actually go back and just break them apart. So those are just some basics of using Google Spreadsheet."