Excel

The UK's most regular instructor-led training courses.
Training information: advanced excel courses · Excel course · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Excel

Fay has attended:
Excel Intermediate course

by - delegate Fay [1 post] (2008 Feb 20 Wed, 15:58) Reply

What are all the F buttons for?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2009 Jan 8 Thu	Bloomsbury	2	book now	£215	£215
2007	2009 Jan 8 Thu	Bloomsbury	3	book now	£224	£224
2007	2009 Jan 12 Mon	Bayswater	4	book now	£224	£224
2007	2009 Jan 13 Tue	Bloomsbury	2	book now	£224	£224
2002/XP	2009 Jan 13 Tue	Tooting	0	FULL
2003	2009 Jan 15 Thu	Southwark	1	book now	£215	£215
Full Schedule: See all 136 Excel Intermediate course dates. Bookings currently available until 30th March 2010.

RE: Excel

by - trainer Mara silver contributer [73 posts] (2008 Feb 23 Sat, 22:08) Reply

Hello Fay,
I hope you enjoyed your Excel training with us.

Thank you for your question. Here is a list of all the F buttons, and their shortcut purpose in Excel:

F1 Help
F2 Edit
F3 Paste Name
F4 Repeat last action
F4 While typing a formula, switch between absolute/relative refs
F5 Goto
F6 Next Pane
F7 Spell check
F8 Extend mode
F9 Recalculate all workbooks
F10 Activate Menubar
F11 New Chart
F12 Save As

I hope this resolves your question. If it has, please mark this question as resolved. If you require further assistance, please reply to this post. And please feel free to ask any other questions you may have.

Have a great day.

Regards,
Mara
Microsoft Office Specialist Master Trainer

· Microsoft Excel Training Course
· Microsoft Excel Training: Not Just for Newbies Anymore
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· Microsoft Excel's Best Kept Secret
· How to check for and reduce errors in Microsoft Excel

Please browse our web site to find out more about
advanced excel courses and other Microsoft training courses.

Excel tip:

Return to the active cell after scrolling

When I scroll a long way down the screen from a selected cell, I can return to that cell with the Ctrl+Back Space shortcut. The active cell now appears in roughly the middle of the screen.

Shift+Back Space does something similar. Scroll down from the active cell and Shift+Back Space returns me to it and puts the active cell at the top of the screen; scroll up from the active cell and Shift+Back Space returns me to it and puts the active cell at the bottom of the screen.

Note also, that while Ctrl+Back Space will return me back to a selected range, Shift+Back Space only ever returns me to the active cell, which is normally at the top left-hand corner of any selected range.

View all Excel hints and tips

Rate this page: