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,780
    Thanks
    403
    Thanked 1,551 Times in 1,405 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
    1,061
    Thanks
    71
    Thanked 119 Times in 104 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,313
    Thanks
    3
    Thanked 211 Times in 194 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
  •