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
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:
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*
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 .
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
: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
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
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
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:
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
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
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.
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.
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
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
*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
--
--
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
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
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
® 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
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
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
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
23 matches
Mail list logo