Share via

Cannot Select Single Column

Anonymous
2020-04-01T13:34:46+00:00

I am unable to select a single column in a table.  I've been using Excel for a very long time.  In the past, I selected one or more columns by using the column headings.  However, when I do that now, the selection expands to include all columns in the table, whether I am trying to select just one column or multiple columns.  I tried using the F8 key to no avail.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

11 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-06-28T23:41:32+00:00

    I have this same issue. Try disabling Add-ins. I disabled "LogiOptionsExcelAddin" and now the issue is gone.

    Was this answer helpful?

    40+ people found this answer helpful.
    0 comments
  2. Anonymous
    2020-07-01T18:24:47+00:00

    Thank you for this! I was certain it was caused by a new Logitech mouse (MX Master 3). This confirmed it.

    Was this answer helpful?

    10+ people found this answer helpful.
    0 comments
  3. Bob Jones AKA CyberTaz MVP 435.3K Reputation points
    2020-04-06T12:19:33+00:00

    OK, so the issue actually is on a PC rather than on a Mac, right?

    Unfortunately, the conglomeration of builds for Windows Office is a rat's nest I haven't kept pace with for quite some time. Although someone familiar with your release may stumble upon your message here in the Mac Excel Community you'll get much faster & more pertinent response if you post to the Community that deals with the specific product you're using. Use this link & select the appropriate Office Product when you do.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  4. Anonymous
    2020-04-01T18:05:05+00:00

    Yes, I do have merged cells in some rows.  Lots of them.  In the past, that was not an issue.  Do I have to unmerge all cells?  I just wanted to adjust column widths for selected columns without having unmerge and then merge again.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  5. HansV 462.6K Reputation points
    2020-04-01T13:46:40+00:00

    Do you have merged cells in one or more rows? That would explain the behavior that you describe.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments