Automatic formatting of a workbook

**cozzielex** · 01-02-2010, 06:25 PM

I am creating an alphabetical workbook and I want to know is there a simple way to automatically follow the headings and cell formats on all of the sheets.
Thanks

**rwgrietveld** · 01-02-2010, 07:12 PM

Sure there is a simple way. Make a template.

If you would like a current WB to be adjusted, VBA is required and we need to know what exacly you would like the code to do.

**cozzielex** · 01-03-2010, 11:16 AM

Thanks for your reply. I'm doing an alphabetical inventory for my library 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.
Happy New Year to all!

**martindwilson** · 01-03-2010, 11:28 AM

just select all sheets then fill in your first one -titles /width /formats all the others will be the same

**cozzielex** · 01-03-2010, 12:40 PM

thanks Martin thats what I'm looking for, but where do I find "select all sheets"?

**martindwilson** · 01-03-2010, 12:42 PM

right click any tab the option should be there

**cozzielex** · 01-03-2010, 01:28 PM

Brilliant Martin, that's done the trick! thanks for your help.
Now whilst I have your attention (and since you clearly know a trick or two), if I have 10 authors called Smith on one sheet and my first entries are for W.Smith, is there a quick way to re-arrange them into alphabetical order in the same way as I can with 'view' in an ms folders directory so that A.Smith will automatically go first?
Thanks