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

excel courses in london - f buttons

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel courses in london - F buttons

excel courses in london - F buttons

ResolvedVersion Standard

Jurgita has attended:
Excel Intermediate course

F buttons

How do I use F buttons on a keybord?

RE: F buttons

Hi Jurgita

I am not sure what you are asking about. Please could you clarify what you want to do.

RE: F buttons

I would guess the question means what functions do they have in regards to working on a spreadsheet ?

RE: F buttons

Absolute/relative/mixed reference F4
Calculate all worksheets F9
Calculate active sheet Shift-F9
Edit cell F2
Function Wizard Shift-F3
Comment insert/edit Shift-F2
Insert chart sheet F11
Insert worksheet Shift-F11
Menu bar F10
Name a range (Insert/Name/Create) Ctrl-Shift-F3
Name a range (Insert/Name/Define) Ctrl-F3
Next window Ctrl-F6
Paste named ranged (Insert/Name/Paste) F3
Previous window Ctrl-Shift-F6
Repeat Find Shift-F4
Save As F12
Spelling and Grammar check F7

Excel tip:

Missing Field handle

If your field handle goes missing all you need to do is go to tools > options > edit tab and then make sure that the check boxes for paste and insert buttons are checked.

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.11 secs.