excel.training.course.london - F keys

Resolved · Low Priority · Version Standard

Thu 10 Jan 2008, 11:41 Delegate 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:14 Trainer 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 courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Quickly create a list of numbers

The 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.

If you wish to create a list of numbers that increment by one at a time, hold down Ctrl in conjunction with using the fill handle - this should give you a series of numbers (e.g. 1, 2, 3 etc) rather than copying a single number.

View all Excel hints and tips