ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   SHORT KEY (https://www.excelbanter.com/excel-discussion-misc-queries/216719-short-key.html)

Arbab[_2_]

SHORT KEY
 
Is there any short key for Align right, centre, and left like in words.
Ctrl+R, Ctrl+E & Ctrl+L respectivily

or we go through Ctrl+1 only

Best Regrads
Arbab


Pete_UK

SHORT KEY
 
If you have the formatting toolbar visible, then you have icons for
those alignments.

I think it unlikely that there are shortcut keys, as there are 7
different horizontal alignments withn cells. Nothing is listed in XL
Help under Keyboard Shortcuts - Formatting.

Hope this helps.

Pete

On Jan 16, 1:11*pm, Arbab wrote:
Is there any short key for Align right, centre, and *left like in words..
Ctrl+R, Ctrl+E & Ctrl+L respectivily

or we go through Ctrl+1 only

Best Regrads
Arbab



Eduardo

SHORT KEY
 
Hi,

Left= Ctrl+A+L
Right= Ctrl+A+R
Center= Ctrl+A+c

"Arbab" wrote:

Is there any short key for Align right, centre, and left like in words.
Ctrl+R, Ctrl+E & Ctrl+L respectivily

or we go through Ctrl+1 only

Best Regrads
Arbab


David Biddulph[_2_]

SHORT KEY
 
Which version of Excel is that, Eduardo?
In my Excel 2003, Ctrl+A does a select all, and Ctrl+L does a create list,
and it won't do anything for Ctrl+A+L.

Ctrl+A+R does the Select All, then Fill Right.
--
David Biddulph

"Eduardo" wrote in message
...
Hi,

Left= Ctrl+A+L
Right= Ctrl+A+R
Center= Ctrl+A+c

"Arbab" wrote:

Is there any short key for Align right, centre, and left like in words.
Ctrl+R, Ctrl+E & Ctrl+L respectivily

or we go through Ctrl+1 only

Best Regrads
Arbab




Bob I

SHORT KEY
 
In 2007 it is Alt-H-A-L, Alt-H-A-C, and Alt-H-A-R

David Biddulph wrote:

Which version of Excel is that, Eduardo?
In my Excel 2003, Ctrl+A does a select all, and Ctrl+L does a create list,
and it won't do anything for Ctrl+A+L.

Ctrl+A+R does the Select All, then Fill Right.
--
David Biddulph

"Eduardo" wrote in message
...

Hi,

Left= Ctrl+A+L
Right= Ctrl+A+R
Center= Ctrl+A+c

"Arbab" wrote:


Is there any short key for Align right, centre, and left like in words.
Ctrl+R, Ctrl+E & Ctrl+L respectivily

or we go through Ctrl+1 only

Best Regrads
Arbab






Eduardo

SHORT KEY
 
Hi David,
2007

"David Biddulph" wrote:

Which version of Excel is that, Eduardo?
In my Excel 2003, Ctrl+A does a select all, and Ctrl+L does a create list,
and it won't do anything for Ctrl+A+L.

Ctrl+A+R does the Select All, then Fill Right.
--
David Biddulph

"Eduardo" wrote in message
...
Hi,

Left= Ctrl+A+L
Right= Ctrl+A+R
Center= Ctrl+A+c

"Arbab" wrote:

Is there any short key for Align right, centre, and left like in words.
Ctrl+R, Ctrl+E & Ctrl+L respectivily

or we go through Ctrl+1 only

Best Regrads
Arbab






All times are GMT +1. The time now is 02:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com