$$Excel-Macros$$ Re: Hide Formula or data in column

Hi Keyur, Yes, you can select the column which you want to hide and to go to Format Menu --> Column --> Hide. On Mon, Jan 5, 2009 at 4:56 PM, Keyur Shah 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 m

$$Excel-Macros$$ Re: Arranging excel sheets in ascending orders

Thank you very much for the help..!!! On Tue, Dec 2, 2008 at 12:49 AM, Dev <[EMAIL PROTECTED]> wrote: > > Dude - this problem is already solved. Here is the link > > http://www.vbaexpress.com/kb/getarticle.php?kb_id=72 > > Regards, > -Dev > > On Nov 27, 12:17 pm, sanj <[EMAIL PROTECTED]> wrote

$$Excel-Macros$$ excel sheets in ascending Order

Hi Friends, Can anyone advise me, how can I arrange sheets in ascending order in excel file? Thanks in advance. Regards, Sanjaykumar --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group,

$$Excel-Macros$$ Re: $$Excel-Macros$$

Hi, You can try the "RIGHT" Formula, where; it will give you the last 6 digit from the particular cell. =RIGHT(B4,6) Best of luck... Regards, Sanjaykumar On Sun, Oct 19, 2008 at 7:15 PM, Mattathil M. Pradeep <[EMAIL PROTECTED]>wrote: > Dears.. > > > > How to copy particular data from one

$$Excel-Macros$$ Re: Can I get Day from date in excel.

Yes, Mayank There is a formula called: Text Wherein A1 cell contains date and if u wanna give result in b1 cell then type: =TEXT(a1,"") You will get day of that particular date Hope, it will help u. And if u still face difficulties, contact me without any hesitations. Regards, Sanjaykumar