98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » excel.training.course.london - F keys
excel.training.course.london - F keys
Resolved · Low Priority · Version Standard
Thu 10 Jan 2008, 11:41Delegate Jenny said...
Jenny has attended:
Excel Introduction course
Excel Intermediate course
PowerPoint Intermediate Advanced course
F keys
When creating/using formulas, could you please remind me which F key is used and what its used for?
Many thanks
Thu 10 Jan 2008, 13:14Trainer Amanda said...
RE: F keys
Hi Jenny
Thank you for your question.
I think you are referring to using the F4 key when creating a formula. You would use the F4 key after you have selected (clicked on ) a cell to put it in the formula, if you wanted that cell reference to stay the same/fixed if the formula was copied to other cells. This is called an absolute reference in Excel-speak, so if you want to look this up in Excel Help at any point, try typing in absolute reference as your search term.
I hope this helps.
Amanda
Training information:
|
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:Quickly create a list of numbersThe fill handle in Excel has many uses. If a number is typed into a cell and then the fill handle is used, the number will be copied from one cell to the next. |
