ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Why does Excel highlight all cells when making changes? (https://www.excelbanter.com/excel-discussion-misc-queries/151808-why-does-excel-highlight-all-cells-when-making-changes.html)

cja

Why does Excel highlight all cells when making changes?
 
My problem is that when working in Excel 2003 I need to make a change on a
previously saved document. After opening the document up I select the cell
that needs to be changed and for whatever reason as I move the mouse up to
the tool bar to make the changes all cells that I move the mouse over
automatically highlight and I cannot make any changes or do anything else
with the document. What causes this and how can I fix the probem.

John Bundy

Why does Excel highlight all cells when making changes?
 
Never heard of that, as a workaround you can try to select the cell to
change, then hit F2, that sets you into edit mode automatically in that cell.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"cja" wrote:

My problem is that when working in Excel 2003 I need to make a change on a
previously saved document. After opening the document up I select the cell
that needs to be changed and for whatever reason as I move the mouse up to
the tool bar to make the changes all cells that I move the mouse over
automatically highlight and I cannot make any changes or do anything else
with the document. What causes this and how can I fix the probem.


squenson via OfficeKB.com

Why does Excel highlight all cells when making changes?
 
It looks like Excel considers that you move your mouse with the left button
down. Do you have any macro that performs some SendKeys or another similar
effect. Does it do it for ALL spreadsheets?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200707/1


challa prabhu

Why does Excel highlight all cells when making changes?
 
Hi,

What has happened is after clicking the cell, you have pressed the F8
function key. Press the Esc key and click any cell to free the selection.

Challa Prabhu

"cja" wrote:

My problem is that when working in Excel 2003 I need to make a change on a
previously saved document. After opening the document up I select the cell
that needs to be changed and for whatever reason as I move the mouse up to
the tool bar to make the changes all cells that I move the mouse over
automatically highlight and I cannot make any changes or do anything else
with the document. What causes this and how can I fix the probem.



All times are GMT +1. The time now is 12:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com