Computing.Net > Forums > Office Software > Excel '07 highlights multiple cells

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Excel '07 highlights multiple cells

Reply to Message Icon

Name: biz_kid1
Date: August 11, 2008 at 07:01:22 Pacific
OS: Win XP Pro SP2
CPU/Ram: 1.00 GB
Product: Dell OptiPlex GX745
Comment:

I have an ongoing issue...various spreadsheets (none in particular...could be one or two or all of them) will start taking on this behavior for no apparent reason: when you click an individual cell, it highlights that cell plus usually two to the right of it. Reformatting by using the format painter from an unaffected cell (if you can find one at that point that hasn't been affected) usually corrects it but it's time-consuming to manually go back and reformat each affected cell. What causes this behavior and how can I stop it? Or is there an easier fix for it? TIA!

Have found related posts @ Microsoft, but MS apparently has not yet acknowledged that this is, in fact, an "issue":
http://www.microsoft.com/office/com... http://www.microsoft.com/office/com...

My suggested workarounds are as follows:
1. Try tapping the wheel of scroll mouse, if applicable.
2. Try changing the page view from Page Layout to any other View option: View tab > Normal
3. Close the spreadsheet, open again and see if behavior still exists.
4. Close Excel, open the spreadsheet and see if behavior still exists.
5. If cell still selects multiple cells, up keyboard up/down/left/right arrows to navigate away and then back to cell, then click in the formula bar to edit
6. If it says EXT or Extend Selection in the bottom left corner of Excel, then it is in Extended mode - try tapping the F8 key once
7. Try zooming out then clicking the cell selection again: View tab > Zoom > Edit % in Custom field > Click OK



Sponsored Link
Ads by Google

Response Number 1
Name: Jennifer SUMN
Date: August 16, 2008 at 16:57:43 Pacific
Reply:

Stuck shift key perhaps?

"So won’t you give this man his wings
What a shame
To have to beg you to see
We’re not all the same
What a shame" - Shinedown


0
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links

Ads by Google


Results for: Excel '07 highlights multiple cells

Excel 2003 - Highlight current cell www.computing.net/answers/office/excel-2003-highlight-current-cell/3788.html

deleting multiple cells www.computing.net/answers/office/deleting-multiple-cells/8563.html

Highlighting cells depending on val www.computing.net/answers/office/highlighting-cells-depending-on-val/7857.html