DISCOVER
×

How to Do a Spreadsheet on Microsoft Word

Updated February 21, 2017

If you want to create a spreadsheet in Microsoft Word, you have two options. You can create a table in Word, or you can link to an Excel spreadsheet. Whichever option you choose depends on what you want to do with your spreadsheet. A Microsoft Word table allows you to perform simple calculations and enter limited data; for more complex calculations and extensive data, create your spreadsheet in Excel and then insert it into Word.

Click on the place in the document where you want to insert the table.

Click "Insert," and then click "Table."

Click the square grid to indicate the table size you would like. Word will insert the table into your document.

Create a spreadsheet in Microsoft Excel.

Select the data in Excel and then press "Ctrl" and "C" to copy the data to the Office Clipboard.

Open Microsoft Word and then click where you want to insert the spreadsheet.

Click "Paste" on the "Home" tab, and then click "Paste Special."

Things You'll Need

  • Microsoft Excel
Cite this Article A tool to create a citation to reference this article Cite this Article

About the Author

Stephanie Ellen teaches mathematics and statistics at the university and college level. She coauthored a statistics textbook published by Houghton-Mifflin. She has been writing professionally since 2008. Ellen holds a Bachelor of Science in health science from State University New York, a master's degree in math education from Jacksonville University and a Master of Arts in creative writing from National University.