 |
Gaming and Simulation Using Microsoft Excel
| |
| | Unformatted Document Text:
SB46
J
ACKSON
:
E
XCEL
S
IMULATIONS
P
AGE
36
OF
41
Fig. 25 -- Insert Hyperlink Menu for All Office Suite Products
If you use hyperlinks to navigate between sections or worksheets of a spreadsheet, you will need to create a “name” in a particular cell. That creates a reference like a bookmark within the worksheet. The way to create one is Insert, Name, Define. That brings up this dialog box:
Fig. 26 -- Define Name Dialog box.
As you can see, the terms used for the names are not particularly imaginative (“issue1” through “issue20”) but if the simulation is highly sequential, then they are more than adequate. Having created a Name in the worksheet, you can now hyperlink to it. This hyperlink goes to a Place in This Document, so choose that alternative on the left. Then
|
| | Authors: Jackson, Steven. |
|
| |
|
|
SB46
J
ACKSON
:
E
XCEL
S
IMULATIONS
P
AGE
36
OF
41
Fig. 25 -- Insert Hyperlink Menu for All Office Suite Products
If you use hyperlinks to navigate between sections or worksheets of a spreadsheet, you
will need to create a “name” in a particular cell. That creates a reference like a bookmark
within the worksheet. The way to create one is Insert, Name, Define. That brings up this
dialog box:
Fig. 26 -- Define Name Dialog box.
As you can see, the terms used for the names are not particularly imaginative (“issue1”
through “issue20”) but if the simulation is highly sequential, then they are more than
adequate. Having created a Name in the worksheet, you can now hyperlink to it. This
hyperlink goes to a Place in This Document, so choose that alternative on the left. Then
|
|
 Convention | | Submission, Review, and Scheduling! All Academic Convention can help with all of your abstract management needs and many more. Contact us today for a quote! | | Submission - Custom fields, multiple submission types, tracks, audio visual, multiple upload formats, automatic conversion to pdf. | | Review - Peer Review, Bulk reviewer assignment, bulk emails, ranking, z-score statistics, and multiple worksheets! | | Reports - Many standard and custom reports generated while you wait. Print programs with participant indexes, event grids, and more! | | Scheduling - Flexible and convenient grid scheduling within rooms and buildings. Conflict checking and advanced filtering. | | Communication - Bulk email tools to help your administrators send reminders and responses. Use form letters, a message center, and much more! | | Management - Search tools, duplicate people management, editing tools, submission transfers, many tools to manage a variety of conference management headaches! | | Click here for more information. |
|
|
|
| |
|
|
|
