ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Numeric Keypad (https://www.excelbanter.com/excel-discussion-misc-queries/158999-numeric-keypad.html)

[email protected]

Numeric Keypad
 
When I use the minus button on my numeric keypad, "ext" appears in the bottom
right hand corner and the minus sign is disabled. Is this a macro? How do I
delete this? What does the "ext" mean?

Dave Peterson

Numeric Keypad
 
Ext is an abbreviation of Extend.

It's an indicator that the range you're selecting should change when you click a
different cell.

Try clicking on any cell (say c3)
hit the extend key (- on the numeric keypad with numlock off, or hit F8)
then click on another cell (say f9)

Did you see how the selection changed?

You can toggle numlock on to kill the minus button on the numeric keypad acting
as the Extend key.

fyi: David McRitchie explains the statusbar:
http://mvps.org/dmcritchie/excel/statusbar.htm

wrote:

When I use the minus button on my numeric keypad, "ext" appears in the bottom
right hand corner and the minus sign is disabled. Is this a macro? How do I
delete this? What does the "ext" mean?


--

Dave Peterson

T. Valko

Numeric Keypad
 
EXT means extend selection.

Turn on your NUM LOCK key and either hit function key F8 or the "-" on the
numeric keypad and that EXT will go away.

--
Biff
Microsoft Excel MVP


" wrote in
message ...
When I use the minus button on my numeric keypad, "ext" appears in the
bottom
right hand corner and the minus sign is disabled. Is this a macro? How
do I
delete this? What does the "ext" mean?




[email protected]

Numeric Keypad
 
Awesome. Thanks so much!!



"Dave Peterson" wrote:

Ext is an abbreviation of Extend.

It's an indicator that the range you're selecting should change when you click a
different cell.

Try clicking on any cell (say c3)
hit the extend key (- on the numeric keypad with numlock off, or hit F8)
then click on another cell (say f9)

Did you see how the selection changed?

You can toggle numlock on to kill the minus button on the numeric keypad acting
as the Extend key.

fyi: David McRitchie explains the statusbar:
http://mvps.org/dmcritchie/excel/statusbar.htm

wrote:

When I use the minus button on my numeric keypad, "ext" appears in the bottom
right hand corner and the minus sign is disabled. Is this a macro? How do I
delete this? What does the "ext" mean?


--

Dave Peterson


[email protected]

Numeric Keypad
 
Awesome. Thanks so much!!

"T. Valko" wrote:

EXT means extend selection.

Turn on your NUM LOCK key and either hit function key F8 or the "-" on the
numeric keypad and that EXT will go away.

--
Biff
Microsoft Excel MVP


" wrote in
message ...
When I use the minus button on my numeric keypad, "ext" appears in the
bottom
right hand corner and the minus sign is disabled. Is this a macro? How
do I
delete this? What does the "ext" mean?






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

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