98.8% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Excel - What are F buttons for?
Excel - What are F buttons for?
Resolved · Low Priority · Version Standard
Fay has attended:
Excel Intermediate course
Excel - What are F buttons for?
What are all the F buttons for?
RE: Excel
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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Ctrl+d's double lifeSuppose I have a formula in B1 that I wish to copy into B2:B10. I can select B1:B10 then press Ctrl+d to copy the formula down the selected range. Users generally ignore this shortcut in favour of double-clicking on the fill handle to copy down, but Ctrl+d is useful sometimes particularly when there is no data in surrounding columns to guide to how far the double-click method should copy formulae. |