➤ Drag the Plus (+) icon downward as long as you want. ➤ Put your mouse cursor onto the right-bottom corner of the selected cell, you’ll find a Plus (+) icon there. Now, we’ll use the Fill Handle option to autofill the series of numbers starting from 1. In the picture below, a number ‘1’ has been inputted in Cell C5. In our first example, we’ll see the basic use of Fill Handle to autofill a series of numbers. AutoFill a Column with a Series of Numbers If you delete an item, the list updates accordingly, but I haven’t found a way to add numbers.12 Suitable Approaches to AutoFill Numbers in Excel 1. You can do anything to this list that you can do to a normal numbered list because it is a numbered list, with one exception: the list, while easy to format, is fixed. You can change the numbers in the list by restarting the sequence or by specifying a new start number. From the Alignment dropdown, choose Right.In the Number Format field, delete the period character.Right-click anywhere in the list, choose Numbering from the resulting context menu and then choose Define New Number Format. For instance, you can quickly remove the period character following each number and the indention property, as follows: The results is a numbered list and as such, has the same pros and cons. You now have a numbered list, but no table or list items-just numbers. In the resulting dialog, click OK, as the table uses paragraph marks to denote columns by default.In Word 2003, choose Convert from the Table menu, and then select Table To Text. Then, choose Convert To Text in the Data group. With the table selected, click the contextual layout tab.At this point, you have a one-column table with one hundred rows displaying a sequential list of 1 to 100.Ĭonverting the table to text is the last step: In Word 2003, Numbering is on the Formatting toolbar. Click Numbering in the Paragraph group.Select the table by clicking the Table Selector (the small square in the table’s top-left corner that I’ve circled in the figure above).The next step is to number the column, as follows: The resulting table will have one column and one hundred rows. In the resulting dialog, enter 1 in the Number Of Columns field and 100 in the Number Of Rows field.In Word 2003, choose Insert from the Table menu and then choose Table. Then, choose Insert Table from the Table dropdown in the Tables group. Position your cursor where you want the table.First, we need to insert a table with one column and one hundred rows: To illustrate this simple technique, we’ll create a sequential list from 1 to 100. The resulting list is a fixed numbered list, so you’ll have to live with its limitations when you can do so, this method definitely beats most alternative solutions. Then, using Word’s numbering feature, number that column. Instead of working harder than you need to, insert a one-column table with as many rows as necessary to accommodate your list. You can use it that way, but it’ll be more work than it’s worth. It doesn’t work so well if you just want to create a list of sequential numbers. In order words, this field works great if you’re numbering documents, labels, and so on. Word’s SEQ field might come to mind, but that solution is better suited to template-type numbering. If you want a list of just numbers, you have to work a bit harder. Sure, you can create a numbered list quickly enough, but that feature works with additional text – you’re numbering something. If you can create a table, you can create a list of sequential numbers.Ĭreating a sequential list of numbers, in Word, sounds like an intimidating task. A quick way to create a list of sequential numbers in WordĬreating a list of sequential numbers isn't as difficult as it might sound at first.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |