How to Make a Spreadsheet in Word

Setting up a table is the best way to make a spreadsheet in Microsoft Word. There are many options available for customizing tables in Word so that you can create any type of spreadsheet that you need for any purpose. All you have to do is set up the table, format it to fit your needs and enter data, and you will have a professional-looking spreadsheet in Word. Use the information below to make a spreadsheet in Microsoft Word 2003 or Word 2007.

Difficulty: Easy

Instructions

Making a Spreadsheet in Word 2007

1. Click on the "Insert" tab once you have your Word 2007 document open.

2. Click on the little arrow below "Table" in the "Tables" section. Select "Insert Table."

3. Choose the number of rows and columns that you want the spreadsheet to include, and click "OK."

Making a Spreadsheet in Word 2003

4. Select "Insert Table" from the Table menu on the top toolbar with your document open.

5. Choose the number of rows and columns that are needed.

6. Click "OK" and the spreadsheet will be placed in your document.

Formatting the Spreadsheet in Word 2007 or 2003

7. Add a title at the top of the spreadsheet that clearly explains what data is contained in the spreadsheet. Bold the title.

8. Set up column headings a couple of rows down from the title. Center and bold the column headings.

9. Enter data into the spreadsheet. Be consistent when entering data. For example, enter all text in all caps or in title case--do not enter some text in all caps and others in title case. The more consistent you are when creating the spreadsheet, the more professional it will look.

10. Merge cells, if needed. To do this in both Word 2007 and 2003, highlight the cells that you want to merge. Right-click and select "Merge Cells."

11. Split up cells, if necessary. Click in the cell that you want to split and then right-click. Select "Split Cells." A box will open up. Choose how many rows or columns that you want to split the cell into. Click "OK."

12. Add or delete rows and columns within the spreadsheet. Right-click where you want to add or delete cells. Select either "Insert" or "Delete Cells" depending on what you want to do.

[jerryb1]

on 3/29/2009 Grand idea for those who wish to present data to people who are not apt to understand or be exposed to spread sheets. OR, in a format that will defy change.