i've just installed a new wireless microsoft keyboard and in excel it won't
recongise me pushing f4 in the formula to change a cell reference to
absolute????

but outside of the formula it lets me push it and opens a new workbook.....

is there neway i can solve this delima without trying to uninstalling excel
and reinstalling it???

Thanks
Martin

makten86 wrote:
> i've just installed a new wireless microsoft keyboard and in excel it won't
> recongise me pushing f4 in the formula to change a cell reference to
> absolute????
>
> but outside of the formula it lets me push it and opens a new workbook.....
>
> is there neway i can solve this delima without trying to uninstalling excel
> and reinstalling it???
>
> Thanks
> Martin
Until you resolve it you could manually add $ in the formula to fix the
cell reference eg: $A$1

W

i know that, but its just a nuscence when i can just push F4 the question
wasn't how can i get around it... but how can resolve it. Thanks neway

"William Hamilton" wrote:

> makten86 wrote:
> > i've just installed a new wireless microsoft keyboard and in excel it won't
> > recongise me pushing f4 in the formula to change a cell reference to
> > absolute????
> >
> > but outside of the formula it lets me push it and opens a new workbook.....
> >
> > is there neway i can solve this delima without trying to uninstalling excel
> > and reinstalling it???
> >
> > Thanks
> > Martin
> Until you resolve it you could manually add $ in the formula to fix the
> cell reference eg: $A$1
>
> W
>

>> > i've just installed a new wireless microsoft keyboard and in excel it
>> > won't
>> > recongise me pushing f4 in the formula to change a cell reference to

Sounds to me like you have the "F Lock" key toggled OFF.
Try turning the F Lock key back on.
Hopefully and easy fix ??


As a side note, didn't you want to wait for Microsoft's new $300 Keyboard?
Just kidding.
http://www.microsoft.com/hardware/mo...s.aspx?pid=080
One article said it was missing some basic keyboard features, whatever that
meant.
--
HTH :>)
Dana DeLouis


"makten86" <(E-Mail Removed)> wrote in message
news:6687B27E-E897-461B-9D13-(E-Mail Removed)...
>i know that, but its just a nuscence when i can just push F4 the question
> wasn't how can i get around it... but how can resolve it. Thanks neway
>
> "William Hamilton" wrote:
>
>> makten86 wrote:
>> > i've just installed a new wireless microsoft keyboard and in excel it
>> > won't
>> > recongise me pushing f4 in the formula to change a cell reference to
>> > absolute????
>> >
>> > but outside of the formula it lets me push it and opens a new
>> > workbook.....
>> >
>> > is there neway i can solve this delima without trying to uninstalling
>> > excel
>> > and reinstalling it???
>> >
>> > Thanks
>> > Martin
>> Until you resolve it you could manually add $ in the formula to fix the
>> cell reference eg: $A$1
>>
>> W
>>

Thanks i found that out after seeing the F Lock key on my keyboard what a
stupid key, i suppose its there for those that dn't know the keyboard
shortcuts


"Dana DeLouis" wrote:

> >> > i've just installed a new wireless microsoft keyboard and in excel it
> >> > won't
> >> > recongise me pushing f4 in the formula to change a cell reference to
>
> Sounds to me like you have the "F Lock" key toggled OFF.
> Try turning the F Lock key back on.
> Hopefully and easy fix ??
>
>
> As a side note, didn't you want to wait for Microsoft's new $300 Keyboard?
> Just kidding.
> http://www.microsoft.com/hardware/mo...s.aspx?pid=080
> One article said it was missing some basic keyboard features, whatever that
> meant.
> --
> HTH :>)
> Dana DeLouis
>
>
> "makten86" <(E-Mail Removed)> wrote in message
> news:6687B27E-E897-461B-9D13-(E-Mail Removed)...
> >i know that, but its just a nuscence when i can just push F4 the question
> > wasn't how can i get around it... but how can resolve it. Thanks neway
> >
> > "William Hamilton" wrote:
> >
> >> makten86 wrote:
> >> > i've just installed a new wireless microsoft keyboard and in excel it
> >> > won't
> >> > recongise me pushing f4 in the formula to change a cell reference to
> >> > absolute????
> >> >
> >> > but outside of the formula it lets me push it and opens a new
> >> > workbook.....
> >> >
> >> > is there neway i can solve this delima without trying to uninstalling
> >> > excel
> >> > and reinstalling it???
> >> >
> >> > Thanks
> >> > Martin
> >> Until you resolve it you could manually add $ in the formula to fix the
> >> cell reference eg: $A$1
> >>
> >> W
> >>
>
>
>

I've been DESPERATE because all of a sudden both my F4 and F2 keys (which I
use constantly in Excel) were acting weird. THANK YOU THANK YOU THANK
YOU......

Having these boards makes a difference in details.

"makten86" wrote:

> i've just installed a new wireless microsoft keyboard and in excel it won't
> recongise me pushing f4 in the formula to change a cell reference to
> absolute????
>
> but outside of the formula it lets me push it and opens a new workbook.....
>
> is there neway i can solve this delima without trying to uninstalling excel
> and reinstalling it???
>
> Thanks
> Martin