Really good bakul. I'm using excel since started using computers but its new to me. Thanks.
On Wed, Jul 1, 2009 at 4:57 PM, Bakul Patel <bakulpatel...@yahoo.com> wrote: > Name: Bakul Patel > Tip: Dictionary in excel > > If you want to use dictionary in excel, just press ALT key & click on cell > which has the word. you will get the meaning of the word. > > Cheers, > Bakul > > > > > --- On *Tue, 6/30/09, Ramesh Katta <kr.sap...@gmail.com>* wrote: > > > From: Ramesh Katta <kr.sap...@gmail.com> > Subject: $$Excel-Macros$$ Re: <BEST EXCEL TIP><WEEK # 27><Submit your TIP > here only> > To: excel-macros@googlegroups.com > Date: Tuesday, June 30, 2009, 11:58 PM > > Hi Dear Members, > > Name: Ramesh Katta > Tip: Create chart by pressing F11 function key. > > We can create a chart quickly without having to use the chart button > on the toolbar by pressing the function key F11 whilst inside a range > of data. > > I have attached a workbook for reference just press F11 on data range > to get chart. > > Thanks& Regards > Ramesh Katta > > > > On Tue, Jun 30, 2009 at 6:31 PM, Aindril > De<aind...@gmail.com<http://us.mc337.mail.yahoo.com/mc/compose?to=aind...@gmail.com>> > wrote: > > Name: Aindril De (Andy) > > Tip: Create Validation List from Data in Different Sheet > > > > A lot of times, when creating a validation list, we might want to get the > > data from another sheet in the workbook. But by default, Excel does not > > allow the validation data to be captured from another worksheet. > > To work around this limitation, we have to do the following steps: > > > > 1) Select the range in another sheet that we want to appear in our > > validation list. > > 2) Define a name for the selected range. For e.g. Cont > > 3) Select the area in the other worksheet where you want the validation > list > > to appear. > > 4) Choose the validation type as list. > > 5) In the source, if you try to switch to the other sheet, you will > notice > > Excel is not allowing to do so. > > 6) Type =<Range Name> i.e the range name that we have just defined. > <NOTE: > > donot write the name as it is without the = symbol, otherwise the list > will > > not appear, instead only the name entered will appear> > > 7) Fill the other Validation tabs if required. > > 8) Click OK. > > > > You will notice that the range that you wanted will appear in the list. > > I have also attached a worksheet to desctibe this example. > > Regards, > > Andy > > On Tue, Jun 30, 2009 at 11:32 PM, Sastry > > <brb.sas...@gmail.com<http://us.mc337.mail.yahoo.com/mc/compose?to=brb.sas...@gmail.com>> > wrote: > >> > >> Name: Sastry B > >> Tip: How to use a combo box. (Excel attached for clarity) > >> > >> This must be very useful for all those who are in MNCs and have to show > >> their financial/economic nos. in more than one currency. This comes > >> extremely handy. > >> > >> I have written the core tip in this attachment. You can put more > controls > >> and also can put one sheet for "parameters" where you can change the key > >> nos. > >> > >> regards, > >> Sastry > >> > >> 2009/6/30 Ayush Jain > >> <jain_ayus...@yahoo.com<http://us.mc337.mail.yahoo.com/mc/compose?to=jain_ayus...@yahoo.com> > > > >>> > >>> Dear Members, > >>> > >>> Thanks for your great response in the Week 26 competition. It was > >>> again great learning for the members of the group. > >>> Let us begin week # 27 quiz with the more spirit. This is last chance > >>> for you to be eligible for June month competition.The winner of week # > >>> 26 will be declared soon. Keep watching this Space...... > >>> > >>> Last Date of Submission of tips : 5th July 2009. > >>> > >>> PLEASE NOTE THAT THE TIPS SUBMITTED IN THIS POST WILL ONLY BE > >>> CONSIDERED FOR PRIZES. > >>> DO NOT START NEW THREADS OR POST FOR SUBMISSION OF TIPS. > >>> > >>> You need to submit your name, Subject & the details of tips and > >>> tricks. > >>> DO let me know if you need any clarifications. > >>> > >>> Let me begin by submitting the first tip for this week competition. > >>> > >>> > --------------------------------------------------------------------------------------------------------------------------------------------------- > >>> Name : Ayush Jain > >>> Subject : Skip through your worksheets with a shortcut > >>> Detail : When I'm working on many programs at once (yes, of course I'm > >>> a multitasker — what did you expect?), I use the keyboard shortcut ALT > >>> +TAB to move between open programs. (If you haven't tried this, do so > >>> now — it's a great Microsoft Windows® trick.) > >>> > >>> However, this doesn't work when you're moving between worksheets in > >>> the same workbook. Don't despair; there are a couple of neat little > >>> shortcuts that handle the job quite nicely. > >>> > >>> To move one worksheet to the right > >>> > >>> Press CTRL+PAGE DOWN. > >>> > >>> To move one worksheet to the left > >>> > >>> Press CTRL+PAGE UP. > >>> > >>> Now you can skip through those worksheets with lightning speed and > >>> amaze your friends and coworkers (if they're the type to be amazed by > >>> that sort of thing, of course). > >>> > >>> Who is next ???????????????????? > >>> > >>> > ----------------------------------------------------------------------------------------------------------------------------------------------------- > >>> > > > > > > > > > > > > > > --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---