#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 80
Default spreadsheet problem

Hi
using 2007
I was working on a spreadsheet yesterday inserting a date as
24/1020009 and I hit a key (Idon't know what it was) on the numeric
keypad and now every time I hit a number on the numeric keypad the
cursor moves to the last cell of the sheet

This is also exhibiting weird behaviour on my other spreadsheets too,
though some are behaving differently

But it doesn't happen when I uses the keyboard numbers

I have just realised while typing this message that this numeric
keyboard behaviour is happening here too

Can someone help me resolve this problem please?
--
Martin
©¿©¬
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 80
Default spreadsheet problem

Silly me
I just realised thst number lock was turned OFF
--
Martin with a blush red face
©¿©¬

On Fri, 13 Nov 2009 13:50:56 +0000, Martin ©¿©¬ @nohere.net wrote:

Hi
using 2007
I was working on a spreadsheet yesterday inserting a date as
24/1020009 and I hit a key (Idon't know what it was) on the numeric
keypad and now every time I hit a number on the numeric keypad the
cursor moves to the last cell of the sheet

This is also exhibiting weird behaviour on my other spreadsheets too,
though some are behaving differently

But it doesn't happen when I uses the keyboard numbers

I have just realised while typing this message that this numeric
keyboard behaviour is happening here too

Can someone help me resolve this problem please?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,069
Default spreadsheet problem

Did you accidentally turn off NumLock? That would turn 1 into an End key, 3
into PgDn, 7 into Home, 9 into PgUp, etc. (on most keyboards).

Hope this helps,

Hutch

"Martin ©¿©¬ @nohere.net" wrote:

Hi
using 2007
I was working on a spreadsheet yesterday inserting a date as
24/1020009 and I hit a key (Idon't know what it was) on the numeric
keypad and now every time I hit a number on the numeric keypad the
cursor moves to the last cell of the sheet

This is also exhibiting weird behaviour on my other spreadsheets too,
though some are behaving differently

But it doesn't happen when I uses the keyboard numbers

I have just realised while typing this message that this numeric
keyboard behaviour is happening here too

Can someone help me resolve this problem please?
--
Martin
©¿©¬
.

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 80
Default spreadsheet problem

On Fri, 13 Nov 2009 06:33:02 -0800, Tom Hutchins
wrote:

Did you accidentally turn off NumLock? That would turn 1 into an End key, 3
into PgDn, 7 into Home, 9 into PgUp, etc. (on most keyboards).

Hope this helps,


Thanks Hutch
Yes, apparently I did accidentally turn off NumLock
This was quite mystifying for 2 days until I happened to notice that
the numlock light was out.
Another lesson learned
--
Martin
©¿©¬

"Martin ©¿©¬ @nohere.net" wrote:

Hi
using 2007
I was working on a spreadsheet yesterday inserting a date as
24/1020009 and I hit a key (Idon't know what it was) on the numeric
keypad and now every time I hit a number on the numeric keypad the
cursor moves to the last cell of the sheet

This is also exhibiting weird behaviour on my other spreadsheets too,
though some are behaving differently

But it doesn't happen when I uses the keyboard numbers

I have just realised while typing this message that this numeric
keyboard behaviour is happening here too

Can someone help me resolve this problem please?
--
Martin
©¿©¬
.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem: Xfr Spreadsheet Lin[_2_] Excel Discussion (Misc queries) 0 December 3rd 08 04:33 AM
spreadsheet problem He cries for help[_2_] Excel Discussion (Misc queries) 0 December 13th 07 11:28 PM
Spreadsheet problem Shaq32 New Users to Excel 2 July 15th 07 11:28 PM
Excel spreadsheet problem mahfouz56 Excel Worksheet Functions 1 October 1st 06 02:41 AM
Big problem with large spreadsheet. Rugby Al Excel Discussion (Misc queries) 1 August 18th 05 02:00 AM


All times are GMT +1. The time now is 03:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"