This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I am using excel 2007, on occasion when i try to select any one cell it will highlight and select multiple cells. Once this occurs it happens with every cell I click on.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
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.
I have heard, but cannot confirm, that some people with this problem have found that altering the zoom level (slider in lower right corner of Excel window) gets the multiple seelction to go away
best wishes
people.stfx.ca/bliengme
I'd still go back to WordPerfect and Quattro Pro in a heartbeat.
Hi all, haven't been on here for a while, usually just read the emailed answers.
It's amusing as this thread has gone on for years through quite a few versions of Excel.
It only happens in page layout view, switch out of that and it won't happen, trouble is if your altering a spread sheets physical content then you need to be in page layout view to make sure it fits a page still!
NONE of the get arounds are a cure, that will take Microsoft to re-write some code which they will not do as they just don't care about us users, they got their money from us when we bought it so they think we can go jump!
I have rebuilt complete spread sheets from scratch to get rid of it, a while and it's back!
One guy says he has found out how to replicate it but I'm not inclined to search through 13 pages to find it, semi retired now and have learnt to live with it when I use one of my books with it in.
I'm convinced it's a bug to do with shortcuts, just so may ways to do everything, you hit a couple of keys in error and your off somewhere that takes you ages to get back from.
Word is now a real pain, you just breath and you've got all sorts of pop up menu's opening, editing functions appearing.
Best if ALL those were switched off as standard and you just select which ones you want to use, bet NO ONE ever uses even a small percentage of them all!
(Pun intended)
This worked! Thanks. I was getting so frustrated.
This problem seems to be linked with the header. If the header is not visible on the screen the multi-select does not occur. As soon as you can see a portion of the header the problem appears.