Solved excel why are sections overlapping?

July 15, 2015 at 06:21:49
Specs: Windows 7
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!!!

See More: excel why are sections overlapping?

Report •

#1
July 15, 2015 at 09:40:09
Try altering the zoom level (slider in lower right corner of Excel window)
waaay out then back to 100% this has been known to help.

Also look at the bottom left of your spread sheet and make sure you are not in Extended Selection mode.
If you are, press the F8 key to exit.

MIKE

http://www.skeptic.com/


Report •

#2
July 15, 2015 at 10:38:53
Thank you. I actually was able to solve the problem by changing the view back to Normal. I don't know why mine sometimes changes from Normal to Page Layout or is possibly defaulted to Page Layout option. Thanks again for the response!

Report •

#3
July 15, 2015 at 11:52:28
✔ 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.


Report •

Related Solutions

#4
July 15, 2015 at 11:55:23
If it will make your life easier, you can disable the Page Layout View, look here:

http://excelribbon.tips.net/T012139...

MIKE

http://www.skeptic.com/


Report •

#5
July 15, 2015 at 13:36:22
Thank you for all the help. I am currently using 2007 so the instructions to disable Page Layout View looked more complicated than I wanted to undertake right now. :)

Report •

#6
July 15, 2015 at 15:49:09
The suggestion at that link to use a macro seems a bit over the top. I can't see using VBA code that forces the worksheet into Normal view every single time a user selects a cell. That seems like such a huge waste of resources.

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


Report •

Ask Question