Dear Members, Sometimes you have many questions in mind like : How to know the cell protection status - Locked or Unlocked ? How to know the width of the cell ? How to know alignment of cell ? How to identify row & Col number of cell ? How to know the worksheet name, filename & full path of given cell ? & many more similar questions................. Now the time is to know that single excel function . Get answer of all the above questions<http://www.discussexcel.com/functions/formulas/cellformulatodisplaycontentpositionandformatting> NOW Download<http://www.discussexcel.com/functions/formulas/cellformulatodisplaycontentpositionandformatting>the sample file for practical understanding !! You will also get one BONUS<http://www.discussexcel.com/functions/formulas/cellformulatodisplaycontentpositionandformatting>tip at the end of the post. :-) Once you learn the solution, Share your feedback with other members. Feel free to share more tips with the group members. Visit DISCUSSEXCEL <http://www.discussexcel.com/> for more tips, tricks and formulas. Happy Learning to all. Regards, Ayush Jain Group Manager
-- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel