The settings you applied dictate the page sizing, it doesn't force your tables and graphs into those sizings... So if you have the A4 settings in the layout properties, you need to make sure your tables and graphs fall between those measurements. If you have a matrix table which once populated goes over the page width then it will go into another page. However this will export as just 1 page in excel.