 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / November 2005Validation Help
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!!!:eek: ) 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!  Signaturenicolebelle First, can't you create a sheet and copy it? If not... Second, can't you copy the rows? :) ************ Anne Troy VBA Project Manager www.OfficeArticles.com > Hi Everybody--i have a 50 +/- tabbed worksheet, I need each worksheet to > have the same headings (there are about 10 headings) underneath each [quoted text clipped - 4 lines] > time and there has got to be an easier way...any help would be greatly > appreciated!! thanks! If you select all sheets all the things you do in one sheet will be done in all the sheets, don't forget to ungroup the sheets when you are done SignatureRegards, Peo Sjoblom > Hi Everybody--i have a 50 +/- tabbed worksheet, I need each worksheet to > have the same headings (there are about 10 headings) underneath each [quoted text clipped - 4 lines] > time and there has got to be an easier way...any help would be greatly > appreciated!! thanks! Duh. Leave it to me to forget the obvious. :) ************ Anne Troy VBA Project Manager www.OfficeArticles.com > If you select all sheets all the things you do in one sheet will be done > in [quoted text clipped - 12 lines] >> View this thread: >> http://www.excelforum.com/showthread.php?threadid=485968 Hi Nicole Click on the first worksheet tab, hold down shift button and click on the last worksheet tab. This will Group them and it will say Grouped at the top of the screen. Now, anything you do to any sheet, will be replicated across all others. When you have finished, click on any single tab to Ungroup them. Regards Roger Govier > Hi Everybody--i have a 50 +/- tabbed worksheet, I need each worksheet to > have the same headings (there are about 10 headings) underneath each [quoted text clipped - 4 lines] > time and there has got to be an easier way...any help would be greatly > appreciated!! thanks! Thank you all so much for the quick responses! I tried highlighting al the tabs, and when i do that I am unable to choose validation of th data pull down menu. I have tried also to copy the validation from on worksheet to another and when i do that, i get a pull down menu but th list is not there and there is some sort of error. ??? What am I doin wrong?? What is the source for the validation list? Maybe you could use a named range, as described here: http://www.contextures.com/xlDataVal01.html > Thank you all so much for the quick responses! I tried highlighting all > the tabs, and when i do that I am unable to choose validation of the > data pull down menu. I have tried also to copy the validation from one > worksheet to another and when i do that, i get a pull down menu but the > list is not there and there is some sort of error. ??? What am I doing > wrong??? SignatureDebra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html nicole You cannot group sheets and create a DV drop-down as you have found out. On sheet1 if you type the list into the dialog box(comma de-limited) you can copy to all the other sheets. OR If you have a named range for the list and use that named range in the list dialog........ =TheList You can copy the DV to all the other sheets. In either case copy the DV cell from first sheet. Select sheet2 then SHIFT + Select last sheet and Paste Special>All>OK>Esc. Gord Dibben Excel MVP >Thank you all so much for the quick responses! I tried highlighting all >the tabs, and when i do that I am unable to choose validation of the >data pull down menu. I have tried also to copy the validation from one >worksheet to another and when i do that, i get a pull down menu but the >list is not there and there is some sort of error. ??? What am I doing >wrong??? :) Great!! that helped me so much...thank you guys...my gigantic matri is really coming along now...but i have another question...how can protect my workbook so that my formatting and printsettings can't b changed by others, I would like to limit those using the workbook t only the drop down lists...is this possible?:confused: Thank again!! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.