Hi Everybody--i have a 50 +/- tabbed worksheet, I need each worksheet to have the same headings (there are about 10 headings) underneath each heading i have my drop down list (validations) that people need to choose from. i need to format my whole gigantic worksheet like this, but right now am only doing it 1 at a time (which is taking forever!!! ) Does anybody know how to do this?? this is my first time and there has got to be an easier way...any help would be greatly appreciated!! thanks!