Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Nov 2009
    Location
    Naperville, IL
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts
    How do I center/align text in a cell using keystrokes?

    Thanks in advance

  2. #2
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    one way is to set Excel to use Transition Navigation Keys, then precede each entry with a caret(^).

  3. #3
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    David,

    Here's the Excel 2003 Shortcut List.
    Here's the Excel 2007 Shortcut List.

    I think you'll need to record a macro and assign a key-combo to it.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  4. #4
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    988
    Thanks
    56
    Thanked 105 Times in 90 Posts
    ALT + CTRL then repeatedly pressing TAB increments the indents (extending across cells if needs be) which might possibly simulate what you seek.

  5. #5
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Alt+HAC in 2007.
    Regards,
    Rory

    Microsoft MVP - Excel

  6. The Following User Says Thank You to rory For This Useful Post:

    RetiredGeek (2011-01-18)

Posting Permissions

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