shortcut key
VBA Telemetry pings you when your VBA projects fail
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: shortcut key

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Posts
    57
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Is there a short cut key (keyboard shortcut) for aligning the text in the columns.

    Regards,
    kalavathi

  2. #2
    New Member
    Join Date
    Apr 2002
    Location
    England
    Posts
    44
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Not as far as I know, however, you can format a cell or range of cells say, centre justified in one of two ways.
    If you centre justify a cell then select another cell and press F4 it will also justify this cell. This is because F4 will Repeat your last action.
    I usually leave my cell justification till last and then select all the cells I want to justify by holding down the Ctrl key while selecting cells.
    They other way is to write a macro for each justification you want to use and assign it a short cut key.
    For example:-
    sub JustifyCenter
    Selection.HorizontalAlignment = xlCenter
    endsub
    If you click option in the macro window you can then assign the macro a keystroke. In this case I used Ctrl+Shift+C. Not just Ctrl+C as that is the default copy key.

    Cheers,
    Alan.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com