Hi Liam,
Excel gets its list of paper sizes from those defined in the preinstalled printer driver (A0 is not included). And we can not set custom paper size in Excel.
Meanwhile, we welcome and encourage you to share your ideas through Excel User Voice. Understanding your experience helps us to make our product and service better for you and others.
Thanks,
Tina