Browse » Home
Wednesday, July 11, 2012
How to Make a Spreadsheet in Word
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.