In Excel you can call last action again and again by pressing F4 Key let supposed you just fill a color in the cell you want other cell to be fill like that just go to that cell and press F4 key it will perform that action again
regards Santosh Bahuguna On Thu, Jul 2, 2009 at 12:02 PM, Rachna Rathod <milika...@gmail.com> wrote: > best tip, > thanks bakul > > 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
