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

Hi Anjali, Shortcut Key: 1. For Align Text Left : Alt+H+AL 2. For Center: Alt+H+AC 3.For Align Text Right: Alf+H+AR Regards, Kuldeep Singh Phone.: +91-120-4763789, Extn.: 789 naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print this e-mail unless you re

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

Hi Anjali, Press Ctrl+L, Ctrl+H, Ctrl+R, or Ctrl+J to *left*-*align*, *center*, *right* -*align* On Mon, Jul 30, 2012 at 11:47 AM, Shreedar wrote: > 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 Alignmen

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 align left, right and cente

Re: $$Excel-Macros$$ shortcut key .

Alt+D+F+S Regards On Sun, Dec 18, 2011 at 10:47 AM, vijayajith VA wrote: > Sorry . that is for put filter and remove filter.i need to clear checked > items .in filtered coloumn. > > > On Sun, Dec 18, 2011 at 12:10 PM, Ms-Exl-Learner . < > ms.exl.lear...@gmail.com> wrote: > >> Alt+D+F+F >> >> ---

Re: $$Excel-Macros$$ shortcut key .

Yes, to check and uncheck the filters you can use the bar. Thank you ! Regards, Rohan. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice wil

Re: $$Excel-Macros$$ shortcut key .

Hi, When the filters are On and you want to Check or Uncheck certain items, u can use Alt+Down Arrow, and then check or uncheck it by using "Space" button On Mon, Dec 19, 2011 at 4:43 PM, NOORAIN ANSARI wrote: > Dear Vijay, > > Incase of 2007+ you can use... > > *CTRL+SHIFT+L* > > -- > Thanks & r

Re: $$Excel-Macros$$ shortcut key .

Dear Vijay, Incase of 2007+ you can use... *CTRL+SHIFT+L* -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Sun, Dec 18, 2011 at 10:41 AM, vijayajith VA

Re: $$Excel-Macros$$ shortcut key .

>Subject: Re: $$Excel-Macros$$ shortcut key . > > >Sorry . that is for put filter and remove filter.i need to clear checked items >.in filtered coloumn. > > > >On Sun, Dec 18, 2011 at 12:10 PM, Ms-Exl-Learner . >wrote: > >Alt+D+F

Re: $$Excel-Macros$$ shortcut key .

Hi vijayajith100, There is no single keyboard shortcut for that function, but you can use ALT-D,F,S to clear all filters without disengaging AutoFilter. Asa On Sat, Dec 17, 2011 at 10:47 PM, vijayajith VA wrote: > Sorry . that is for put filter and remove filter.i need to clear checked > items

Re: $$Excel-Macros$$ shortcut key .

On Sat, Dec 17, 2011 at 10:49 PM, Ms-Exl-Learner . wrote: > The same is applicable for removing filter also. > > --- > Ms.Exl.Learner > --- > > > On Sun, Dec 18, 2011 at 12:17 PM, vijayajith VA > wrote: > >> Sorry . that is for put filter and remove filter

Re: $$Excel-Macros$$ shortcut key .

The same is applicable for removing filter also. --- Ms.Exl.Learner --- On Sun, Dec 18, 2011 at 12:17 PM, vijayajith VA wrote: > Sorry . that is for put filter and remove filter.i need to clear checked > items .in filtered coloumn. > > > On Sun, Dec 18, 20

Re: $$Excel-Macros$$ shortcut key .

Sorry . that is for put filter and remove filter.i need to clear checked items .in filtered coloumn. On Sun, Dec 18, 2011 at 12:10 PM, Ms-Exl-Learner . wrote: > Alt+D+F+F > > --- > Ms.Exl.Learner > --- > > > On Sun, Dec 18, 2011 at 10:41 AM, vijayajith VA

Re: $$Excel-Macros$$ shortcut key .

Alt+D+F+F --- Ms.Exl.Learner --- On Sun, Dec 18, 2011 at 10:41 AM, vijayajith VA wrote: > Hello sir > > Can you tell me what is shortcut key for data clear(filter)? > > > Thanks > > -- > FORUM RULES (934+ members already BANNED for violation) > > 1) Use co

Re: $$Excel-Macros$$ shortcut key .

HI andy, A Filter button [image: Applied filter icon] means that a filter is applied.-I want to clear ths applied filter .for that i need short cut key .i refered your link. i dint get it please hlp me Thanks for your reply On Sun, Dec 18, 2011 at 10:55 AM, Aindril De wrote: > Hi > > Try thi

Re: $$Excel-Macros$$ shortcut key .

Hi Try this: http://dmcritchie.mvps.org/excel/shortx2k.htm Cheers, andy On Sun, Dec 18, 2011 at 10:41 AM, vijayajith VA wrote: > Hello sir > > Can you tell me what is shortcut key for data clear(filter)? > > > Thanks > > -- > FORUM RULES (934+ members already BANNED for violation) > > 1) Use c

Re: $$Excel-Macros$$ Shortcut key for Border

Now its working... Thanks... On 10/13/11, Dilip Pandey wrote: > Nice collection Noorain... > > Regards, > DILIPandey > > On 10/12/11, NOORAIN ANSARI wrote: >> Dear Ankit, >> >> Please find below Short Cut keys,I hope it will help to you. >> >> 1. *Apply* an outline border >> *[Ctrl]+[Shift]+[&]

Re: $$Excel-Macros$$ Shortcut key for Border

Nice collection Noorain... Regards, DILIPandey On 10/12/11, NOORAIN ANSARI wrote: > Dear Ankit, > > Please find below Short Cut keys,I hope it will help to you. > > 1. *Apply* an outline border > *[Ctrl]+[Shift]+[&] * > > 2. Remove the outline border > *[Ctrl]+[Shift]+[_] * > > 3. Toggle the lef

Re: $$Excel-Macros$$ Shortcut key for Border

Hi, Its excel 2007..Its not working in excel2003... Regards Sunil On 13 Oct 2011 10:38, "karan 1237" wrote: > Hey Ankit, > > Please see below image : > For all border press Alt+H+B+A > For outline border Ctrl+Shift+& > & for all border commands > press Alt+H+B+ then press character which is sho

Re: $$Excel-Macros$$ Shortcut key for Border

Hi, Even to me 1st and 2nd is working rest all other is not applying... Pls help... Regards, Sunil B.N +91 9035 8585 85 On 13 Oct 2011 10:25, "Ankit Agrawal" wrote: > Dear All, > > I am trying but it is not doing.Plz help me to solve out it. > > Regards, > Ankit > > On 10/12/11, NOORAIN ANSARI

Re: $$Excel-Macros$$ Shortcut key for Border

Smartphone on Loop Mobile. -Original Message- From: Ankit Agrawal Sender: excel-macros@googlegroups.com Date: Thu, 13 Oct 2011 10:25:37 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Shortcut key for Border Dear All, I am trying but it is not doing.Plz help me to

Re: $$Excel-Macros$$ Shortcut key for Border

Hey Ankit, Please see below image : For all border press Alt+H+B+A For outline border Ctrl+Shift+& & for all border commands press Alt+H+B+ then press character which is showing in the image below: [image: Picture1.jpg] Kaяan

Re: $$Excel-Macros$$ Shortcut key for Border

Dear All, I am trying but it is not doing.Plz help me to solve out it. Regards, Ankit On 10/12/11, NOORAIN ANSARI wrote: > Dear Ankit, > > Please find below Short Cut keys,I hope it will help to you. > > 1. *Apply* an outline border > *[Ctrl]+[Shift]+[&] * > > 2. Remove the outline border > *[C

Re: $$Excel-Macros$$ Shortcut key for Border

Thanks but it is not working. Regards, Ankit On Wed, Oct 12, 2011 at 2:55 PM, NOORAIN ANSARI wrote: > Dear Ankit, > > Please find below Short Cut keys,I hope it will help to you. > > 1. *Apply* an outline border > *[Ctrl]+[Shift]+[&] * > > 2. Remove the outline border > *[Ctrl]+[Shift]+[_] * > >

Re: $$Excel-Macros$$ Shortcut key for Border

Dear Ankit, Please find below Short Cut keys,I hope it will help to you. 1. *Apply* an outline border *[Ctrl]+[Shift]+[&] * 2. Remove the outline border *[Ctrl]+[Shift]+[_] * 3. Toggle the left border on the selected cells [*Alt]+[L] * 4. Toggle the right border on the selected cells *[Alt]+[R

Re: $$Excel-Macros$$ Shortcut key for Border

*Hi, Pls use CTRL+SHIFT+& * Regards Amresh On Wed, Oct 12, 2011 at 12:19 AM, Ankit Agrawal wrote: > Dear All, > > I need shortcut key for all border.plz help me. > > Regards, > Ankit > > -- > > -- > Some important li