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

ranges

ResolvedVersion 2003

Charlotte has attended:
Excel Introduction course

Ranges

if you forget ranges and formulas is there any easy way to find this out?

RE: ranges

Hi Charlotte

How are you thanks for the post - sorry for the late response

There are a few ways of finding your named ranges - if you are in a formula then press the F3 or F5 function keys

If you are navigating to them you can use the name box at the top left corner where your cell ref is or press the F5 button
and double click the name

Hope this helps

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn

Mon 8 Dec 2008: Automatically marked as resolved.

Excel tip:

Create Charts with One keystroke

Create a graph with one click

1. Select your data.
2. Press F11.
3. You have a graph.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.