I'm not much of a techy blogger. I've got gadget joy and geek joy but I can't seem to summon up the tech joy to talk about packages, downloads and script. But I break that silence with a rant about Word. Well.. it's about excel too... and functions.
There's lots of little things I can do on excel that I can't do on word and stuff I do in word and can't in excel. For example: I can hide blocks of information in excel. Fantastic but if I want to do the same in Word I can't.
But why not use excel to create the sheet of information, I hear you ask? the people I work with don't like excel and think it's just for numbers and get all worried if something other than numbers appear in a spreadsheet.
There's not a download available to upgrade that kind of thinking!
Any suggestions on how to gently lead people into the light or force word to behave as if it's excel?
I'm pleased to report that the exact thing you're looking for is in fact possible... and easy!
In Word, click Insert -> Object... and scroll down to Microsoft Excel Worksheet (there's chart, too). Voila - a fully functional and editable Excel spreadsheet which displays cleanly in Word.