Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlighting cells in Excel
When I click on one cell in Excel, the 4 or 5 below that cell often get
highlighted as well and I have to type in one of them to remove the highlight. This is rather annoying as if I hit delete (to delete the info in the first cell) it will delete all of the info. I have only seen this with the new version of Excel 2007. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlighting cells in Excel
Do you see 'Extend Selection' on the status bar at the bottom of Excel window?
If yes, then press F8 once and see whether the problem goes away... "Ritamarie01" wrote: When I click on one cell in Excel, the 4 or 5 below that cell often get highlighted as well and I have to type in one of them to remove the highlight. This is rather annoying as if I hit delete (to delete the info in the first cell) it will delete all of the info. I have only seen this with the new version of Excel 2007. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlighting cells in Excel
1. Check in status bar whether 'Extended selection' is enabled (F8)
2. One of you shift keys is jammed If this post helps click Yes --------------- Jacob Skaria "Ritamarie01" wrote: When I click on one cell in Excel, the 4 or 5 below that cell often get highlighted as well and I have to type in one of them to remove the highlight. This is rather annoying as if I hit delete (to delete the info in the first cell) it will delete all of the info. I have only seen this with the new version of Excel 2007. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlighting cells in Excel
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. A few postings have made the suggestion and it seems to work. Here is one such posting. http://tinyurl.com/3wofsf I have received replies to this advice indicating the zoom change clears it up. Gord Dibben MS Excel MVP On Tue, 26 May 2009 18:11:01 -0700, Ritamarie01 wrote: When I click on one cell in Excel, the 4 or 5 below that cell often get highlighted as well and I have to type in one of them to remove the highlight. This is rather annoying as if I hit delete (to delete the info in the first cell) it will delete all of the info. I have only seen this with the new version of Excel 2007. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i remove shift lock (highlighting cells) from excel? | Excel Discussion (Misc queries) | |||
How do I configure excel to show results when highlighting cells? | Excel Discussion (Misc queries) | |||
Highlighting blanks via GO TO SPECIAL is not highlighting blank cells - HELP, I'm totally stuck. | Excel Discussion (Misc queries) | |||
Turn off cursor from automatically highlighting cells in Excel? | Excel Worksheet Functions | |||
Cells in Excel will not stop highlighting | Excel Discussion (Misc queries) |