highlight cells

  • Thread starter Thread starter bruceo
  • Start date Start date
B

bruceo

I'm using Excel and when I click on one cell (and only one cell), Excel
highlights the next 4 or 5 cells below it automatically and wrongly. Problem
is when I copy/paste, or put in a value it populates all the highlighted cell
- not good.

how do I stop excel from doing this?
Thanks
 
Are there any macros running in the workbook? Set security level in workbook
(Tools - Macro -Security) to medium and close workbook. Then OPen workbook
again adnd press Disable macro when workbook is opened. Does the problem
still occur?
 
It's really simple, just press the arrow keys to the right, left, up or down
and you can place the cursor where ever you need copy.
 
Click on the highlighted cells and in the menu bar click format painter a
brush and then reclick on the selected cells the problem should be solved.
 
Are you using Excel 2007?

Try setting the Zoom level a little lower or higher.

The multiple cell selection is a bug in Excel 2007.

The zoom-changing appears to fix it.

I don't have 2007 but a few postings have made the suggestion and it seems
to work.

Here is one such posting.

http://tinyurl.com/3wofsf

Post back please to confirm if this works or is bogus advice.


Gord Dibben MS Excel MVP
 
Back
Top