Hi Vinay,
Please find enclosed sample xl Sheet. Please note that in the cell A1, I’ve written my name but that is visible only in formula bar, not in Excel Sheet. I Hope it helps…. Regards, Upendra Singh 9910227325 ---------------------------------------------------------------------------- --------------------------------- There are 10 kinds of people: Those who understand binary and those who don’t From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of vinay keni Sent: Saturday, June 20, 2009 12:25 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: <BEST EXCEL TIP> <WEEK # 25> <Submit your TIP here only> Options dear upendra i am trying it out but i am unable 2 get the thing can attach an excel sheet & show with the example On Sat, Jun 20, 2009 at 12:23 AM, vinay keni <kenivi...@gmail.com> wrote: dear upendra On Fri, Jun 19, 2009 at 8:39 PM, Upendra Singh <upendrasinghsen...@gmail.com> wrote: Hi Friends, Name : Upendra Singh TIP : Hide Data in Cell or Worksheet from praying Eyes ð Select the range you want to hide. ð Go To Format=>Number=>Custom ð In the type Box, type three colon (;;;) and press enter. ð The data where the above formatting is applied will be visible in formula Bar only and not in Worksheet Cell. Regards, Upendra Singh 9910227325 ---------------------------------------------------------------------------- --------------------------------- There are 10 kinds of people: Those who understand binary and those who don’t. -- Regards, Vinay Keni -- Regards, Vinay Keni --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
Hidden Text.xls
Description: MS-Excel spreadsheet