Hi Manoj, The tip Ctrl + ` shows the all formulas in the worksheet. For testing purpose I attached a excel file just open it the press Ctrl + ` you will seen all formulas.
Thanks&Regards Ramesh On Mon, Jun 8, 2009 at 3:01 AM, Manoj S Negi<manojsnegi.uttranc...@gmail.com> wrote: > Hi Ramesh, > > Thanks for the tip but its showing the formule of current cell only not for > entire work sheet. > Is there any another way to use this tip???? Kindly share the same. > > > BR > MSN > > > On Mon, Jun 8, 2009 at 9:50 AM, Ramesh Katta <kr.sap...@gmail.com> wrote: >> >> Hi all, >> >> >> Name : Ramesh >> Subject : Open a workbook which has formule. >> Tip :Use Ctrl+` to see the all formule which are in the sheet. >> >> We use Ctrl+` to see the all used formulas in the current worksheet. >> >> >> >> Thanks&Regards >> Ramesh Katta >> >> > > > > > --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
