I have previously posted about using CutePDF to create pdfs from Excel sheets. There is another way, but it takes a few clicks and it only works in Excel 2010 and later versions. (It may work in Excel 2007 but I have taken that version off my PC so I can’t test it.)
Close All Icon
If you have a lot of files open and you want to close them all and still leave Excel open you can add this icon to the Quick Access toolbar.
See this post if you are not sure about using the Quick Access Toolbar.