excel course tate modern - Excel

Hi Deane

Great to meet you on Friday on my course.

The benefits for having a range name in a worksheet:

1) Will enable you to jump to a cell or group of cells quickly without having to remember the cell reference, scrolling down or across worksheet.

2) Will enable you to jump to specific areas on another worksheet within the same workbook.

3) Will make your formulas more user friendly. e.g. =SUM(Qtr1) instead of e.g. =SUM(B2:B6)

To create a range name for one cell or several cells,

1) Select cell(s), type a new range name in name box and press ENTER key.

2) Select cell(s), Insert menu, Create name.

3) Select cell(s), Insert menu, Define name, accept existing name or type a new name.

Range names can be up to 225 characters in length. Excel will not allow you to create a range name with a space e.g. Post Code must be set up as Post_Code

To jump to a range once one is set up:

1) Click on Name box, choose named range.
2) Press CTRL+ G or the F5 key to display Go To dialog box, choose named range from list.

Hope this all helps
Take care
Sandy