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

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Getting the numbers correct

Getting the numbers correct

ResolvedVersion 2003

Mon 15 Jun 2009, 16:44 Delegate Jason said...

Jason has attended:
Excel Introduction course
Excel Intermediate course

Getting the numbers correct

when do i use the f4 key

Tue 16 Jun 2009, 10:40 Trainer Amanda said...

RE: getting the numbers correct

Hello Jason

Thank you for your question and welcome to the forum.

When you have selected a cell to put it into a formula, pressing the F4 key once immediately afterwards turns the cell reference for the selected cell from a relative reference (e.g. A4) to an absolute reference ($A$4). This 'fixes' or 'locks' the cell reference into the formula, so when the formula is copied to other cells in the spreadsheet, the reference to the cell stays the same.

Kind regards
Amanda

Mon 22 Jun 2009: Automatically marked as resolved.

Excel tip:

Transpose text

You can transpose any range of cells, turning the columns into rows and the rows into columns. Just follow these steps:

Select the range.

Click the Copy button on the Standard toolbar to copy it to the Clipboard.

Select a cell outside of the range you copied.

Select Paste Special from the Edit menu.

In the Paste Special dialog box, click Transpose, then OK.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Getting the numbers correct

Getting the numbers correct

RE: getting the numbers correct

Excel articles

Excel tip:

Transpose text