HI, Name - Harmeet Tip - Calculate formula using F9 Detail : Lets say you have a formula : *=IF(MONTH(B1)>9,YEAR(B1)+1,YEAR(B1))* in order to calculate partial formula you need to select desired formula like this: *=IF(MONTH(B1)>9,YEAR(B1)+1,YEAR(B1))* Then press *F9, *it will convert the formula to value. Then press Ctrl+Z to revert the change (If required)
Benefit - For long formulae user can verify the result for subformula of main formula. For explanation see attached screenshot......... On Fri, Jun 19, 2009 at 1:20 AM, Harmeet Singh <harmeet.hew...@gmail.com>wrote: > HI, > > Name - Harmeet > Tip - Define name range using shortcut key *(Ctrl+Shift+F3) *& see defined > names *(Ctrl+F3)* > Detail - Please see attached file > > Regards, > Harmeet > > On Thu, Jun 18, 2009 at 3:55 AM, Harmeet Singh <harmeet.hew...@gmail.com > > wrote: > >> HI, >> >> Name - Harmeet >> Tip - Switching between tabs >> Detail - Please see attached file >> >> Regards, >> Harmeet >> >> >> >> On Mon, Jun 15, 2009 at 8:11 PM, Ayush <jainayus...@gmail.com> wrote: >> >>> >>> Dear Members, >>> >>> Thanks for your great response in the Week 24 competition. It was >>> great learning for the members of the group. I was delighted with the >>> response of members on this initiative. The winner of week # 24 will >>> be declared soon. Keep watching this Space...... >>> >>> Let us begin week # 25 quiz with the more spirit. >>> >>> Last Date of Submission of tips : 21st June 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 : Format all the worksheets in a workbook >>> Detail : If you need to format all the worksheets in a workbook the >>> same way, you can hold down the Shift or Control button and select the >>> worksheets. Now that you have the worksheets selected, you can change >>> things like cell or page properties that will apply to all the >>> worksheets selected. After you're done, click on an inactive worksheet >>> (if you've selected all the worksheets) or click on an unselected >>> worksheet (if you did not select all the worksheets) to release the >>> hold. >>> >>> Who is next ???????????????????? >>> >>> >>> >>> >> >> >> -- >> Thanks & Regards, >> >> Harmeet Singh >> >> Sent via BlackBerry Wireless >> >> >> >> > > > -- > Thanks & Regards, > > Harmeet Singh > > Sent via BlackBerry Wireless > -- Thanks & Regards, Harmeet Singh Sent via BlackBerry Wireless --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
<<attachment: tip2.png>>
