Home/ Questions/Q 1398
Next
Answered
computing
  • 1
Asked: 2021-10-21T13:29:14+00:00 In:

Solved Excel Why Are Sections Overlapping?

  • 1

If I try to select a column, example E, it automatically highlights E & F and when I try Ctrl click to highlight only E and try to delete the column, I get a message “Cannot use that command on overlapping selections.” Lots of the columns are “overlapping” and I don’t know how this happened or how to stop it? Any suggestions? Thanks!!!

Share

    1 Answer

    1. Best Answer
      My guess is that the problem wasn’t really solved specifically by changing the view from Normal to Page Layout, but merely by the change in view as Mike hinted at.

      A quick test would be to toggle back and forth between Normal and Page Layout and see if the multiple column selection problem returns and goes away with each toggle of the 2 modes. I’m guessing it won’t.

      My guess is that you were a victim of the annoying “multiple cell selection” bug that showed up in Excel 2007 and beyond and changing the view cleared it up for the time being.

      Click Here Before Posting Data or VBA Code —> How To Post Data or Code.

      • 0