I try to insert an excel spreadsheet into Word and it cuts off some of the
rows. I tried changing the scaling under page setup (in excel) to 70% and
this worked one time but not again. Is there an easy way to do this that is
consistent every time? I don't know if there is another way to scale down the
data I am trying to copy and paste into word.

Once you have the spreadsheet object embedded in the Word doc, double-click
on it and then drag the borders to include as many rows/columns as required.
Note that an embedded object in Word must fit on a single page. If your
spreadsheet is bigger than than, you must copy it in Excel and then
paste-link it as a Word table. See linking and embedding in Word help.
--
Ted