Getting the numbers correct

Resolved · Low Priority · Version 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:

Repeating headings on spreadsheets that print on more than one page

By default when you print a spreadsheet out and it prints on more than one page, the headings at the top and the side of the spreadsheet don't appear on all the pages following page 1.

To get Excel to repeat headings on all pages when printing, go to File - Page Setup - Sheet, then select the rows to repeat at the top of pages, and the columns to repeat at the side of pages by clicking on the red arrows at the right side of the two boxes under the 'Print titles' area. Then click OK.

If you view your spreadsheet in Print Preview, you should see the headings being repeated on each page.

View all Excel hints and tips

Getting the numbers correct

Getting the numbers correct

RE: getting the numbers correct

Excel articles

Excel tip:

Repeating headings on spreadsheets that print on more than one page