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/143952-short-key.html)

adeel via OfficeKB.com

SHORT KEY
 
Is there any Short Key for "Centre Align", "Left Align", "Right align".....if
not please tell me any macro design for these purpose.

--
Message posted via http://www.officekb.com


Gary''s Student

SHORT KEY
 
If there is no ShortCut key for "center", it easy to make one:

Sub centre()
Selection.HorizontalAlignment = xlCenter
End Sub
and assign something like CNTRL-e to it.
--
Gary''s Student - gsnu200724


"adeel via OfficeKB.com" wrote:

Is there any Short Key for "Centre Align", "Left Align", "Right align".....if
not please tell me any macro design for these purpose.

--
Message posted via http://www.officekb.com




All times are GMT +1. The time now is 03:07 AM.

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