Difficulty: Moderately Easy
Step1
Open your spreadsheet and enter data. One of the advantages of using a spreadsheet is there is plenty of leeway in entering data. You can't make a mistake as you can move it wherever you want whenever you want.
Step2
Learn the rules for naming a range. There are only two: a range name can be any length but can't contain spaces, commas or hyphens and it must start with an underscore or a letter.
Step3
Select the data that you want to name. This can be a single cell or multiple cells depending on what you intend to use it for. If you just want to find a place in the spreadsheet a single cell is adequate, but if you wanted to print a certain area (such as a table) you would want to select the whole area.
Step4
Create a name. Use "Insert," "Name," "Define" and a dialog box will appear. Give it a name following the rules in Step 2.
Step5
Use the range name. By selecting "Edit" and "Go To" or by pressing "F5" a box will come up that will ask you to put in where you want to go. This is where you would select the range name that you just defined and press enter; the spreadsheet will then take you to the selected spot. Close the box.
