More than selected rows being highlighted
 

My workbook has sheets with many formulas. Sometimes when I highlight
multiple rows or cells, more than what I selected is highlighted (for example
= I can't highlight rows 5-10 without 11-15 being highlighted). The problem
seems to go away when I delete or edit individual rows or cells, but reoccurs
after I successfully select multiple rows or cells (for copy & paste
purposes).

More than selected rows being highlighted
 

It sounds as if you have merged cells 10:15 in your example
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"RLD" wrote:

My workbook has sheets with many formulas. Sometimes when I highlight
multiple rows or cells, more than what I selected is highlighted (for example
= I can't highlight rows 5-10 without 11-15 being highlighted). The problem
seems to go away when I delete or edit individual rows or cells, but reoccurs
after I successfully select multiple rows or cells (for copy & paste
purposes).

More than selected rows being highlighted
 

You might have merged cells in your selected range. If so, find it/them,
select it/them, and click the merge button once to break them into individual
cells.

Hope this helped.

"RLD" wrote:

My workbook has sheets with many formulas. Sometimes when I highlight
multiple rows or cells, more than what I selected is highlighted (for example
= I can't highlight rows 5-10 without 11-15 being highlighted). The problem
seems to go away when I delete or edit individual rows or cells, but reoccurs
after I successfully select multiple rows or cells (for copy & paste
purposes).