Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Oct 2003
    Location
    Atlanta, Georgia, USA
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Select All (Control - A) in Excel (Excel 2003 SP1)

    Hi,

    Our IS dept. recently upgraded my laptop, and it was loaded with Office 2003. In this version of Excel, I've been having problems using the "Select All" command in Excel. Often times, when I use the "Control A" combination on the keyboard, it only highlights a portion of my worksheet. I would say this happens about 35% of the time, and I don't know why. In the past, I never had this issue. Whenever I typed Ctl A, it always selected the entire worksheet. Was there a change in this version of Excel and is there a setting someplace where I can fix this? Any help would be appreciated.

    Thanks,

    Jeff

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Select All (Control - A) in Excel (Excel 2003

    CTRL+A will not always select the entire worksheet. If the worksheet contains data, CTRL+A selects the current region. Pressing CTRL+A a second time selects the entire worksheet.

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Select All (Control - A) in Excel (Excel 2003 SP1)

    This is new in Excel 2003. According to Microsoft Office Assistance: Excel shortcut and function keys:
    <hr>CTRL+A Selects the entire worksheet.
    If the worksheet contains data, CTRL+A selects the current region. Pressing CTRL+A a second time selects the entire worksheet.
    ...<hr>
    So pressing Ctrl+A a second time should select the entire sheet, as in older versions of Excel.

  4. #4
    New Lounger
    Join Date
    Oct 2003
    Location
    Atlanta, Georgia, USA
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Select All (Control - A) in Excel (Excel 2003 SP1)

    Well that was easy enough. Thanks Hans & Tony!

Posting Permissions

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