Print preset

Hi.
Here's what I would like Excel to do, one way or the other:

1. Automatically fit the column width to the content for all columns
2. Page Layout - Print titles - Mark the first 9 rows of the sheet to be repeated at top when printing.
3. Make the orientation "Landscape"
4. Make tha margins "Narrow"
5. "Fit all columns on one page"
5. Make sure we're only printing on one side of the paper
Rows to repeat on top.jpgPrint settings.jpg

Is this even possible? I've only made some batch-files, using MS-DOS-commands/Command prompt,
in addition to creating some Photochop actions/macros (record actions to repeat), so I'm not really into
the whole macro/VBA-universe. Some pointers on how to do this - or even better, if someone out there
would see it as a challenge and help me create such a macro, that would be just great.

Any help will be greatly appreciated.

Best regards

Stig M.

I just learned that this can all be achieved by recording a macro in Excel itself... just the way I've done in Photoshop, so, it's been solved