Keeping a whole table on one page

I have a MS Word 2010 document with many small tables. I would like to prevent those tables from breaking up over pages. I know it is possible to prevent a single row to break up. But I would like the following:

1. How can I prevent a table from breaking up over several pages?
2. How can I do this for one or several tables at the time, instead of setting it per row?

Solution 1:

Yes you can. Highlight the entire table by clicking the icon with the arrows at the top left of the table. Then click Paragraph Properties from the toolbar and tick Keep with Next.

Solution 2:

Another option is to "special" paste the Excel information into the Word document as a picture. This allows you to resize the entire table to fit on a single page. Drag a corner of the table-picture to ensure the ratio of the sides to the top and bottom stay the same. The drawback is that a reader can't copy your table into Excel and do more with it nor can they add columns or rows in Word. I like to do this when I want to ensure someone won't mess with my numbers, but still might want to edit the wording.