Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

desktop keypad f

ResolvedVersion 2016

Soumya has attended:
O365 Digital Champions course
Excel Power Query course

Desktop keypad f4

Hi Team,
On my regular desktop keypad I cannot use f4 to do the $in formulas to make them constant. What do i do?

Thanks,
Soumya

RE: desktop keypad f4

Hi Soumya,

Thank you for the forum question.

You probably need to use the keys FN and F4

You will find FN (the function key) on the bottom left side of your keyboard.




Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

RE: desktop keypad f4

Hi Jens,

That was the first thing i tried, it didnt work.

RE: desktop keypad f4

Hi Team,


This has been resolved. The problem was in Skype setting, f4 is used as shrt key to start a call, so you need to go int setting - General and Hotkeys within there, change it from F4 to either another key or none for npl guys

Thankyou

RE: desktop keypad f4

Great Soumya,

I am glad that the issue has been resolved.


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Thu 26 Sep 2019: Automatically marked as resolved.

Excel tip:

Conditional formatting for cells that return text , not picked up by Go to command

If you have tried to format all cells containing text even those that display text as a result of a formula you may have had difficulty. As Go to command with constant selected does not pick up formulas that result in text.

Then try this. Select the range the formula cells appear in on your sheet. Format, select Conditional Formatting menu. In the dialog box under Condition 1, select "Formula Is" from drop down. Next to it in the Formula Box, enter the formula =Istext(A1. Click Format button , choose desired formatting settings and click OK. To go ahead and apply the conditional formatting click OK to accept

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.