| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
highlight cells
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
highlight cells
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? "bruceo" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
highlight cells
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. "bruceo" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
highlight cells
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. -- Thanks Suleman Peerzade "bruceo" wrote: 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
highlight cells
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 On Sun, 11 Jan 2009 14:57:01 -0800, bruceo wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to highlight more related cells if cell highlight | Excel Discussion (Misc queries) | |||
| Trying to highlight cells | Excel Discussion (Misc queries) | |||
| How to highlight cells... | Excel Discussion (Misc queries) | |||
| Highlight cells with ctrl-click but only un-highlight one cell | Excel Discussion (Misc queries) | |||
| Highlight cells | Excel Worksheet Functions | |||
Hybrid Mode
