In cell A1 enter the following formula:.This method uses a formula and results in numbers without applying a custom format to the cells. And, best of all, they are still numbers so you could do math with them, if necessary.Ī couple of ExcelTips subscribers suggested a second method to get sequential numbers with a trailing period. Your numbers should now all appear just fine with a trailing period. In the Type box enter the following: 0"." (the digit 0 followed by a period enclosed within quote marks).The Number tab of the Format Cells dialog box. The dialog box changes so you can enter a custom format. If the Number tab is not displayed, select it. Excel displays the Format Cells dialog box. Click the small icon at the bottom-right of the Number group.Use AutoFill to create your sequence of 150 cells, numbered 1 through 150.The first is to stick to numbers (which AutoFill can work with) and apply a custom format to the cells in order to add the period. There are at least three potential solutions. And, unfortunately, entering a number (1) followed by a period places a text string (1.) in the cell. It does OK if you are working with well-established sequences, such as the alphabet or days of the week, but it is downright stupid when it comes to most other text values. The AutoFill will only work without the trailing period, but she wants the period there.Īs Iana has discovered, AutoFill doesn't do a great job on figuring out how to "increment" text. Now that you have all those numbers typed out, we can move on to formulas, as you learn how to add up in Excel.Iana wants to AutoFill a column of sequential numbers as "1.", "2.", etc., through "150.". When you're done, your spreadsheet will look like this: To complete the numbers for the rest of the week, enter the following under each heading: Your spreadsheet will then look like this one:.Press the Enter key again to jump down to cell B6 Press the enter key on your keyboard, and the active cell will jump down to cell B5 Click inside cell B4, and enter the number 1.Your spreadsheet should then look something like ours below: In cell A9 of you spreadsheet enter the words Day Totals.In cell A5 we chose Twix, and in cell A6 Bounty. You can enter anything you like, but we've gone for Mars Bars. Click inside cell A4 and enter the name of a chocolate bar.Now that we've got a heading for the spreadsheet, as well as the days of the week, we can enter a few chocolate bars. We'll use AutoFill on a column of numbers, shortly. Excel will now complete the days of the week:Īnd that's all there is too it! AutoFill can be a handy tool to use, when you want to complete a known sequence like days of the week, months, and even formulas.When your cursor is in the H3 cell, let go of the left mouse button.Drag your mouse all the way to cell H3, as in the following image:.When you can see the AutoFill cursor, hold down your left mouse button and drag to the right.The image on the left shows the normal white cross the image on the right, the black cross, tells you AutoFill is available: The mouse pointer will change to a black cross, as in the images below.Position your mouse pointer to the bottom right of the B3 cell.In other words, Excel will do it all for us. You can use something called AutoFill to complete a known sequence like days of the week. Fortunately, you don't have to type them all out. The days of the week are going to be entered on Row 3 of our spreadsheet, from cell B3 to cell H3. Excel AutoFillĬlick inside cell B3 of your spreadsheet, and type Monday, as in the image below: You'll now see how to use the AutoFill feature of Excell to quickly enter the days of the week. You have a title in cell A1, but nothing else. Your spreadsheet from the previous section should look like this one:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |