You can apply the background color of the cell (white in general) to the font color and check the hide option from Format > Cells > Protection tab.
Now, if you protect the sheet, no one can see those data... Will this work for you? Maddy... On Jan 6, 1:38 pm, "Keyur Shah" <keyursha...@gmail.com> wrote: > thanks for response > > But did not want to hide entire column i want to hide only data enter in the > column. Coulm should be visible but data entered in that column should not > be visible to everyone. > > On Tue, Jan 6, 2009 at 12:33 PM, vijender kumar <simplevi...@gmail.com>wrote: > > > > > > > Hi ... > > > you can hide the column in very simple way > > > Select the column > Right Click with your Mouse > click on Hide > > > On 1/5/09, Keyur Shah <keyursha...@gmail.com> wrote: > > >> hi, > > >> Can anybody guide me how to hide data in column sothat no one can visible > >> and i want to lock sheet that mouse pointer move only selected column only. > > >> -- > >> Keyur Shah > >> (M) 98259 28073 > > -- > Keyur Shah > (M) 98259 28073- Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~----------~----~----~----~------~----~------~--~---