More than selected rows being highlighted
in [General]
|
Prev: can I have a multiselect option for a list box in excel 2003
Next: Converting Date 03/01/2010 into a simple Month
From: RLD on 15 Mar 2010 13:20 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).
From: Russell Dawson on 15 Mar 2010 13:28 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).
From: Russell Brogan on 17 Mar 2010 03:03
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). |