Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: Right Align, Center, Left Align

  1. #11
    New Member
    Join Date
    Dec 2011
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Right Align, Center, Left Align

    thank you for your response...

    I am using EXCEL 2003 version... are there any shortcut keys to align cell in excel 2003 version?
    thank you..

  2. #12
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    UK
    Posts
    32,516
    Post Thanks / Like
    Mentioned
    27 Post(s)
    Tagged
    3 Thread(s)

    Default Re: Right Align, Center, Left Align

    No, not that I am aware of.

  3. #13
    Board Regular Akuini's Avatar
    Join Date
    Feb 2016
    Location
    Indonesia
    Posts
    1,149
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: test table

    Excel 2007 32 bit
    AB
    1dfshdtyju7ju
    2gffhhyddyh

    Sheet2



    Last edited by Akuini; Nov 3rd, 2018 at 08:05 AM.

  4. #14
    New Member
    Join Date
    Nov 2018
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Right Align, Center, Left Align

    Looks as though even prior to Excel 2007, there are no real shortcut keys like there are in MS Word for Left/Center/Right align. Was just looking at my Windows Default Key Codes file with the different combinations of modifiers for the Windows platform, and nothing is in it for these specific items. One reason why I created such a file was to help make data entry a bit easier, especially if one is using the 10-key numpad (MS calls it keypad, but numpad makes more sense in my mind as the terminology I learned long before I saw MS calling it keypad). That's because I was toying with events like KeyPressDown to trigger certain actions. However, the problem with that, VBA can't distinguish between the different keys such as the Enter Key on the QWERTY vs the Enter Key on the numpad, when using the Key Scan Codes. It would require a programming language like C programming or C#.NET to decipher between the different keys, including which Alt Key was pressed and of the like.

    Another reason for me to create this file was also to see which keyboard combinations are not being utilized, which then allows me to assign macros to such unassigned keyboard shortcuts.

    One such site that has a list of keyboard shortcuts for Excel 2003 is http://www.shortcutmania.com/microso...-shortcuts.pdf However, there is nothing listed in there for cell alignment purposes.

    If you had to do it via keyboard, guess you could do Alt,O,E and then use the Ctrl-PgDn to get to the Alignment Tab, and use the accelerator in there to get it right aligned. That's one thing that MS did make a bit easier with 2007 and beyond, using the Ribbon accelerator keys (i.e., Alt,H,A,C for Horizontal Center of the cell), though I hate the size of the ribbon to the point with certain files, I have to hide it via the Ctrl-F1 keyboard shortcut. However, if you have the old toolbar keyboard shortcuts memorized to 2000-2003 versions of Excel, you can still use that too within Excel 2007 and later (i.e., Ctrl-C,Alt,E,S,V,Enter, or use Ctrl-Insert in place of Ctrl-C to convert the selected cells from formulas to values, or use Alt,E,A,A to clear everything including formats within the selected cells)

Some videos you may like

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
  •