Need Auto Formatting Software

**robes63** · 06-21-2011, 12:12 AM

Hi

Sorry if i'm asking this question in the wrong place but i'm running out of options

I work with alot of excels where i need to either print them or convert to other formats such as PDF. The problem i face is that most of the time they need to be formatted before printing. This can be quite tediuos when dealing with a 100 of more spreadsheets.

I am hoping to find a software that can do this formatting automatically in multiple batches with options for page size output while still making the spreadsheets readable.

I have come across a few programs that can convert excel to PDF but they don't handle the sizing of the rows and columns very well.

does anyone know of a program that gives good results?

Regards

**royUK** · 06-21-2011, 01:50 AM

Excel 2010 has a built-in pdf writer, Saveas & file type *.pdf

If your workbooks need to be saved in a specific format then use Templates

**robes63** · 06-22-2011, 02:02 AM

Hi Thanks Roy

Templates only work on new spreadsheets correct? the problem i have is that i get files that are created by a number of different people created in many different ways and i only need to change the print layout for each file so was looking for a software that could do this instead of having to do it manually.

Regards