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

2012-07-29 Thread Anjali .
Hi Group, Can any one please help me to know how to align left, right and center in a cell in excel file through shortcut key. Thanks Regards, -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need

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

2011-12-20 Thread Dheeraj Bankoti
Alt+D+F+S Regards On Sun, Dec 18, 2011 at 10:47 AM, vijayajith VA vijayajith...@gmail.comwrote: 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:

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

2011-12-19 Thread Shaik Waheed
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 noorain.ans...@gmail.comwrote: Dear Vijay, Incase of 2007+ you can use... *CTRL+SHIFT+L*

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

2011-12-18 Thread Asa Rossoff
On Sat, Dec 17, 2011 at 10:49 PM, Ms-Exl-Learner . ms.exl.lear...@gmail.com wrote: The same is applicable for removing filter also. --- Ms.Exl.Learner --- On Sun, Dec 18, 2011 at 12:17 PM, vijayajith VA vijayajith...@gmail.comwrote: Sorry .

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

2011-12-18 Thread Asa Rossoff
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 vijayajith...@gmail.comwrote: Sorry . that is for put filter and remove filter.i need to

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

2011-12-18 Thread hanumant shinde
:17 PM 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 . ms.exl.lear...@gmail.com wrote: Alt+D+F+F --- Ms.Exl.Learner

$$Excel-Macros$$ shortcut key .

2011-12-17 Thread vijayajith VA
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 concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not

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

2011-12-17 Thread Aindril De
Hi Try this: http://dmcritchie.mvps.org/excel/shortx2k.htm Cheers, andy On Sun, Dec 18, 2011 at 10:41 AM, vijayajith VA vijayajith...@gmail.comwrote: Hello sir Can you tell me what is shortcut key for data clear(filter)? Thanks -- FORUM RULES (934+ members already BANNED for

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

2011-12-17 Thread vijayajith VA
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 aind...@gmail.com wrote:

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

2011-12-17 Thread Ms-Exl-Learner .
Alt+D+F+F --- Ms.Exl.Learner --- On Sun, Dec 18, 2011 at 10:41 AM, vijayajith VA vijayajith...@gmail.comwrote: Hello sir Can you tell me what is shortcut key for data clear(filter)? Thanks -- FORUM RULES (934+ members already BANNED for

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

2011-12-17 Thread vijayajith VA
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 --- Ms.Exl.Learner --- On Sun, Dec 18, 2011 at 10:41

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

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

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

2011-10-13 Thread Dilip Pandey
Nice collection Noorain... Regards, DILIPandey On 10/12/11, NOORAIN ANSARI noorain.ans...@gmail.com 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.

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

2011-10-13 Thread Ankit Agrawal
Now its working... Thanks... On 10/13/11, Dilip Pandey dilipan...@gmail.com wrote: Nice collection Noorain... Regards, DILIPandey On 10/12/11, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Ankit, Please find below Short Cut keys,I hope it will help to you. 1. *Apply* an outline

$$Excel-Macros$$ Shortcut key for Border

2011-10-12 Thread Ankit Agrawal
Dear All, I need shortcut key for all border.plz help me. Regards, Ankit -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our

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

2011-10-12 Thread Amresh Maurya
*Hi, Pls use CTRL+SHIFT+ * Regards Amresh On Wed, Oct 12, 2011 at 12:19 AM, Ankit Agrawal ankit.agrawal...@gmail.comwrote: Dear All, I need shortcut key for all border.plz help me. Regards, Ankit -- --

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

2011-10-12 Thread NOORAIN ANSARI
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

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

2011-10-12 Thread Ankit Agrawal
Thanks but it is not working. Regards, Ankit On Wed, Oct 12, 2011 at 2:55 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: 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

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

2011-10-12 Thread karan 1237
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 http://www.facebook.com/singhkarann

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

2011-10-12 Thread somcpardeshi
® Smartphone on Loop Mobile. -Original Message- From: Ankit Agrawal ankit.agrawal...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 13 Oct 2011 10:25:37 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Shortcut key for Border Dear

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

2011-10-12 Thread sunil bn
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 ankit.agrawal...@gmail.com wrote: Dear All, I am trying but it is not doing.Plz help me to solve out it. Regards, Ankit On

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

2011-10-12 Thread sunil bn
Hi, Its excel 2007..Its not working in excel2003... Regards Sunil On 13 Oct 2011 10:38, karan 1237 karan1...@gmail.com 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

$$Excel-Macros$$ shortcut key needed

2009-09-23 Thread Alok Bhatt
Hi friends, Can u provide me any shortcut key for proper and upper function in Excel --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and