Microsoft Excel is well-suited to the task of building and editing a roster of any kind. Rosters are lists, usually of people's names, for a particular class, team, project or other group that requires an organised set of data. Excel creates spreadsheets of rows and columns. This grid layout makes it particularly effective for creating rosters. A user may easily build their own roster, or use any of the many pre-built Excel roster templates that are available from Microsoft for free. Regardless of your chosen route, creating a roster in Excel is relatively straightforward.
- Skill level:
- Moderately Easy
Other People Are Reading
Things you need
- Microsoft Excel
Open Excel. A new blank spreadsheet file is created automatically.
Consider the headers you will need. Example: For a classroom roster, you may need a column for first name, last name, major (if applicable) and additional columns for each of the major grades offered during a school term. Excel offers up to 256 columns for use as headers.
Type the headers required for your roster in row 1, starting with column A and moving to the right through columns B, C and more. For example, in cell A1, type "First Name." In cell B1, type "Last Name." Continue this process until you have created all the headers you need. You can always add more later, if necessary.
Enter the data into the roster. Simply type the data into the appropriate cells under the column headings, using one row for one person. For example, in row 2, type an individual's first and last names and other data as structured by the column headers.
Save the file using the "File" menu's "Save" option. You can open this file at any time and update the roster with any necessary data.
Build Your Own
Open a Web browser.
Visit the Microsoft Office online templates website (See References 1).
Perform a search for "roster." All the templates for Microsoft Excel and other programs will be listed.
Click on any Excel roster template to download the free spreadsheet layout.
Open the downloaded template and edit the roster with the names in your group, team, class or other organisation.
Use an Excel Template
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for