View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Russell Brogan Russell Brogan is offline
external usenet poster
 
Posts: 5
Default 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).