0
How do you create a list on Excel from 0 to 100 101 to 200 201 to 300 etc all the way until 10000?
Wiki User
∙ 9y ago
There are different ways to do that. If you type 1 into the first cell and in the cell under it, so if your cell was A1 that would be A2, you would type the following formula:
=A1+1
You could then drag that down to row 10000. Obviously that is a difficult way when it comes to dragging. A better way would be to type 1 into the first cell in a column. Then select the entire column by clicking on its header. Then use the Fill Series facility. On versions of Excel up to 2003, it is on the Edit menu. On newer versions of Excel it is in the Editing section of the Home Tab. In each case, choose Fill and then Series. You then need to set a step value of 1 and the Stop value as 10000. Then click OK and your list from 1 to 10000 will have been created.
Wiki User
∙ 9y ago
Add your answer:
Earn +20 pts
How Can you Create a Rebar cutting List?
You can create a Rebar cutting list by using a software program such as Microsoft Excel or Google Drive. Use the table to create a cutting list for Rebar.
How can you start studying computer Excel?
Microsoft has some excellent free Excel tutors available. See related links for list of Excel subjects available. Recommend you start with the tutor entitled: "Get to know Excel 2007: Create your first workbook"
How do you create a drop down list in Excel 2007?
If it is a form control, the right click on it and select it. Then press the delete key. In 2007 select the formulas tab, select "name Manager". A list will display. Select the item to remove and then select delete. All reference is gone. For ones created by using the Data Validation option, on the top menu click "Data" and find "Data Validation" which will open a dialog box with the dropdown settings. Find the "Clear All" button and click it. This procedure can be followed if the dropdown list is added using the "Data Validation" process.
What does daverage do in Excel?
It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.It calculates an average from a database list in Excel, using specified criteria.
Can I create a query in Excel 2003 where the date is most recent and another number is most recent and you can choose from a list for the third category?
no
What can Microsoft Excel do to you?
It allows you to create balance sheets, enter the data needed to calculate taxes, list people's names, and dates for organization, and a lot more.
What is used in Excel to create a drop down menu for frequently used terms?
Enter your list of items in a column.Click in the cell or range where you want to add your drop-down menu.Set the cell validation condition to list and select the list of items you created.In Excel 2007, you will find the Data Validation button on the Data Tab of the menu ribbon in the Data Tools section.
What is a list of commands that you can choose from in excel?
Menu
How do you get on Microsoft Excel?
If you have already bought and downloaded the Microsoft Office tools, you access them by clicking 'Start' in the bottom left-hand corner of your screen, then scrolling through the programs list until you see 'Microsoft Office'. When you scroll over it, a drop down list will appear. Click 'Microsoft Office Excel'.
How do you take a long list of items and put them on an Excel sheet or a Google Doc so that they line up in columns?
It depends upon the source of the list. Try to "highlight" and "copy" the list into Excel.
How does a company create a mailing list database?
A mailing list database can be created in a variety of ways depending on what type of software the company is using in their office. Microsoft Office has several products available for creating a mailing list, and it can be done with programs such as Microsoft Word, Excel or Access.
What do Ribbon commands include?
Ribbon command include almost everything that you might want to do with Excel, such as setting the font and controlling the appearance of the font. Ribbon commands also let you create charts and graphs, import and export data, format cells, and more.
