excel xp training - Next and back buttons/cells

Hi Reyno

You could do this by setting up hyperlinks.

If you type the word Next into a cell, press Enter, then select the cell with the word Next, then go to Insert - Hyperlink (or use Ctrl + K).

You would want to set up a hyperlink to a Place in this Document (which you can select from the left in the Insert Hyperlink dialogue box).

Where it has Type the cell reference towards the top of the dialogue box, you can enter a reference to the cell you wish to link to. If it is on the same sheet, then enter in the cell reference. If the cell you wish to link to is on a different sheet, then enter in the sheet name followed by an ! then the cell reference. Then click OK. Test by clicking the hyperlink.

Then you will need to set up another hyperlink that will link back from the cell that the text Next links to.

I hope this helps. Please reply if you have any problems.
Amanda