Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Microsoft Excel 2007 highlights multiple cells in Excel

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? This is affecting multiple users within
our company.

Have found related posts @ Microsoft, but nothing definitive that MS
apparently has not yet acknowledged that this is, in fact, an "issue".

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

TIA!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Microsoft Excel 2007 highlights multiple cells in Excel

Thanks for the work-around, but does anyone know of a permanent fix for this?
We're running: XP Pro SP3, Office 2007 SP1

"biz_kid1" wrote:

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? This is affecting multiple users within
our company.

Have found related posts @ Microsoft, but nothing definitive that MS
apparently has not yet acknowledged that this is, in fact, an "issue".

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

TIA!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
selecting multiple cells in Excel 2007 cjb22 Excel Discussion (Misc queries) 20 November 11th 08 06:35 PM
MS Excel 2007 highlights multiple cells when selecting single cell biz_kid1 Excel Discussion (Misc queries) 5 September 14th 08 06:42 PM
Save as file format excel worksheet 4.0 in Microsoft excel 2007 Saria Excel Discussion (Misc queries) 1 July 14th 08 11:39 AM
Print Named Cells highlights web link to Excel range ExcelMonkey Excel Discussion (Misc queries) 1 June 12th 08 11:46 PM
help fix - - one click now selects multiple cells in Excel 2007 R James Excel Discussion (Misc queries) 5 October 8th 07 04:16 PM


All times are GMT +1. The time now is 11:54 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"