Resolved Automatically formatting a workbook in Excel 2007

I'm doing an alphabetical inventory for my library using Excel 2007 and I want 26 identical sheets with the following columns and width:-
Author (20)
Title (40
Remarks (50)
Date (default)
I will be creating other similar inventories for some other collections (I'm old enough to make it worthwhile), and rather than manually editing each sheet, I want to know is there a labour saving feature in excel 2007 which allows me to copy my first sheet's format to the other 25.
I don't know anything about macros or VBA and early traces of Alzheimers makes it difficult for me to get too complicated, thats actually the reason I need something simple.
I don't know if I'm the only one but I find the new excel a bit intimidating for beginners.
Anyway, if anyone has any advice I'd be obliged.

 

cozzielex,

See if this web site is what you are looking for,
http://www.datapresentation.com/

 

Thanks for your response Mate and your time. I downloaded the suggested programme and just to show you what a duffer I am, I couldnt work out how to use it! One of the components wouldn't install because the file type (sto) wasn't recognized. Anyway I'm the last person on the planet without a credit card so I cant buy online.
What I was really hoping was that somewhere in the various ribbons at the top lies some simple answer to what I'm looking for.
By the way it's freezing here in kent,UK I just hope its warmer there in Indiana. For some reason that sounds like a place where you should be basking around the pool supping ice cold buds! (or maybe I'm just getting mixed up with that other place!)

 

Not warm at all in Indiana, USA - it's cold and snow on the ground. Can't wait for spring.
We have Polar Bear clubs in the US and those people are nuts. Jumping in freezing water
on New Years Day.

 

Thanks guys. Polar Bear clubs eh?....I must have definitely got the wrong place!

 

Answer Found!
just in case anyone else is tyring to do this for the first time:-
Before formatting the first sheet, right click the sheet tab and click on 'select all sheets' then do the formatting and all the sheets will be the same. Thanks guys for your input.