Re: $$Excel-Macros$$ locking the cells

Hi Sunitha, Select the whole sheet and uncheck the lock using the format cells window. Then select the cells which you want to protect and chec the lock using the format cells window. Now go to Tools, Protect Sheet and protect the worksheet. Only those cells will be protected which has been lock

Re: $$Excel-Macros$$ discussexcel formula quiz 1

Done! On 10-Nov-2012, at 11:40 AM, Ayush Jain wrote: > Dear group, > > I have created a small formula quiz to test your formula knowledge. This quiz > has 10 questions related to excel formulas only. > Formula quiz > > Based on your participation and engagement, I will try to launch more such

Re: $$Excel-Macros$$ Shortcut key to Align Left, Right & Center in Excel

Hi, Please find the shortcuts you are looking for...Alt+H+AL for Left Alignments, Alt+H+AC for Center Alignments, & Alt+H+AR for Right Alignments Regards...Shreedar On 30-Jul-2012, at 8:57 AM, "Anjali ." wrote: > Hi Group, > Can any one please help me to know how to a

Re: $$Excel-Macros$$ Dates in Excel

Hi, You can select all the dates and use Control + H Find What: 2011 Replace With: 2010 then click on Replace All button. It will change all the 2011 to 2010 Hope this helps! Thanks, Shreedar On Thu, May 26, 2011 at 11:19 PM, Rich Prince wrote: > I have a column of various dates that h

Re: $$Excel-Macros$$ Excel help

Hi Bhanu, Select all the cells where you want to remove zeros and select control + H, and type 0 and replace with blank and then click on* Replace All.* * * * * Thank you, Shreedar On Sun, Apr 3, 2011 at 8:25 PM, bhanu prakash wrote: > Hi - need it help excel. Removing zeros in alpha nume

Re: $$Excel-Macros$$ 22 days left - Launch of discussexcel.com

How about Excel in Excel? On Tue, Feb 22, 2011 at 11:29 PM, Ayush Jain wrote: > Dear members, > > I am too excited to share that discussexcel.com website development is in > good progress and we are ready to launch the website on 4th Anniversary of > our Google group. i.e. 16th -17th March. > >

$$Excel-Macros$$ Re: Ctrl + Tilde

Any help on this would really great. Thank You, Shreedar On Thu, Dec 2, 2010 at 7:01 PM, Shreedar Pandurangaiah < shreedar.panduranga...@gmail.com> wrote: > Hi Group, > > While I am able to use the Ctrl + Tilde, to see the hidden formulas in the > spreadsheet. My colleague

$$Excel-Macros$$ Ctrl + Tilde

Hi Group, While I am able to use the Ctrl + Tilde, to see the hidden formulas in the spreadsheet. My colleague is not able to do that...I mean to say can't use the Ctrl + Tilde. What should I do to enable that? Thank You, Shr

Re: $$Excel-Macros$$ VLOOKUP function

Hi Alan, The third part of the formula, where you've put $E:$E has to be replaced by either 1 or 2(since your table array is just D and E column). Thanks, Shreedar On Sun, Oct 10, 2010 at 2:30 AM, Alan wrote: > I am using Excel 2007 and having a strange problem with the VLOOKUP &g

$$Excel-Macros$$ Excel Training

Dear Group, Please let me know, if any of you are interested in training a group of folks on Microsoft Excel in Bangalore. They are looking for 30 hours of training.. Thank You, Shreedar -- -- Some important links

Re: $$Excel-Macros$$ Help: Removing duplicate data

You can use Advance filters to remove the duplicates. Select the data...Go to Data - Filter - Advance Filter - Click on Unique Records only - and Click Ok...All the duplicate records will be filtered of. Thanks, Shreedar On Thu, Sep 23, 2010 at 2:07 PM, janet dickson wrote: > Hi All, >

Re: $$Excel-Macros$$ Excel quiz

Hi Ayush, Here are my answers... If B and C is given A = Bth root of C If A and C is given B = Log(C,A) If A and B is given C = A ^ B Thanks, Shreedar P. On Wed, Sep 22, 2010 at 5:55 PM, Ayush wrote: > > Dear Group, > > A small quiz for you...let see who answers it first and c

Re: $$Excel-Macros$$ Congratulations : We are 7000 today

Dear All, this is amazing...I truly appreciate everyone's continued effort. Thanks again, Shreedar On Mon, May 24, 2010 at 12:55 PM, sudhir kumar wrote: > Hi > all Group members, > > Thanks for joining this group and countined with us and > very special thanks to Ayush

$$Excel-Macros$$ Re: help required

w, If you have any more questions on this one!!! Thanks, Shreedar On Thu, Jul 2, 2009 at 1:04 PM, shivashankar katageri < shankarkatag...@gmail.com> wrote: > > Dear all, > > Any one can help w.r.t copy from subjects of column cells to row cells,by > just dragging or

$$Excel-Macros$$ Re: $$ Excel-Macros $$ Consolidation of different sheet by macro

Hi Sanjay, If you are using Excel 2003 then keeping your cursor in the data and then clicking Ctrl+A would choose the whole range of the data where your cursor is placed...Try doing this while recording the macro, It will work. Thanks, Shreedar On Thu, Jul 2, 2009 at 12:27 PM, SANJAY SONI wrote

$$Excel-Macros$$ Re: 2nd Anniversary - Surprise Gift for Top Posters on Mar16

Hi All, Congratulations to each one of you!!! This is wonderful...I'm sure your posts has made a great amount of difference in our day to day work...Thank you soo much. Rgds, Shreedar On Wed, Mar 11, 2009 at 5:23 AM, Ashish Jain <26may.1...@gmail.com> wrote: > > Hi