In this video, learn the first step in working with a spreadsheet, adding text or numbers to cells and then formatting them. Also, see how to format the font, size, and style of text as well as how to format numbers as currency.
- [Instructor] To get started with the Excel app, let's make a basic spreadsheet, fill in some text and format it. So I need to tap the plus button up in the top right corner to create a new spreadsheet. In this menu, I need to choose where I want to save it. I'm just going to stick with one of my recent locations. Then I need to choose a template, as a starting point. Let's stick with just the normal blank workbook template. And now I've got a good place to start. So, each individual cell can contain text, numbers or other information. To type something into a cell, you just need to double tap on it.
So in this cell I'm going to type in the word January. When you're finished typing, you can tap the red X to cancel, or the green check mark if you want to keep it. So, I'll tap the green check mark. Now, in row one, I want to have all of the months listed. And here's a nice shortcut for that. With the cell selected, you can tap on the cell again, to bring up these onscreen controls. And I want to use the Fill command. You'll see when I tap that, the circles on the corners of the cell will change to squares. Now, I can grab the square in the bottom right corner and drag it down, or to the right.
I want to drag it to the right, and you can see it will fill in all of the months. I want to drag it all the way over here to fill in December. And it was only able to do that because the app could recognize an identifiable pattern there. Okay, so next let's go over to Column A, and I'm going to double tap on A2. And I want to fill in the names of some products, starting with the fleece vest. This spreadsheet is going to have some sales numbers for these products that my company sells. Now, this time, instead of hitting the green check mark, I'm just going to tap the return key on the onscreen keyboard.
That will jump me down to the next cell and I can just continue typing. So in this next cell I'm going to type in the name of the next product, hit Enter, and continue on. Now, I'm only going to put in a few of these. And we're going to finish up with the Travel mug here in this cell. And now that I'm finished with these names, I can tap the green check mark to finish that off. Okay, so my next step is to fill in sales numbers in all of the cells in between these rows and columns. So I'm just going to tap on one of these, type in the number that I want, then I can hit Return, or tap on another cell, and fill in the next number.
But you don't want to sit here and watch me fill in all these numbers, so let's skip forward in time. Okay, so I finished typing in all the numbers. I'll tap the green check mark, and now I have all the data I need in this spreadsheet. Next, I want to see how we can format text in a spreadsheet. First, what you could do is tap to select a cell, then you'll need to go to the Home ribbon. So, on the phone I'm going to use the vertical ribbon, make sure I'm in the Home ribbon, and then I've got a bunch of options here for formatting. So, for example, if I wanted to make this text bold, I could tap on the Bold button, and it does it right there.
You can do that for an individual cell, or you can select an entire row or column. So, I'm going to tap on the number one to select the entire row one. Then, when I mark it as bold, it bolds everything in that row. Let's do another change. I'm going to set the font color to blue. And you can see it applies to that entire row. You can do that with columns, as well. You can also select a range of cells. So, if I tap on one cell here, where I've got numbers, then I'll grab the little circle in the bottom right corner of that cell, I can expand the selection, because I want to format all of these numbers at the same time.
So, scrolling through the Home ribbon, we've got some options. I want to use the alignment tools to center the numbers in these cells, that looks a little better. But what I really want to look at are the options for number format. So, I'll tap on that. And there are a bunch of different settings you can have for numbers. What I want is currency. I could just tap on that, or I could tap the arrow on the right and choose the specific currency formatting, including the currency symbol that you want to use. But I want to just do the basic currency formatting, so I'm going to tap the Back button here and simply tap Currency.
And you can see it formats all of those numbers at the same time. All right, so I'm going to stop there. This is a good start to filling out some basic information and formatting text in a spreadsheet.
- Exploring Office on an Android phone or tablet
- Creating and editing documents in Word
- Building spreadsheets in Excel
- Working with Excel formulas
- Creating presentations in PowerPoint
- Sharing files in Office for Android
- Working with Outlook calendar and email
- Managing notebooks in OneNote
- Messaging in Microsoft Teams