How to organize DVDs excel to link multiple pages to single page?

Asked By araceliariana 30 points N/A Posted on - 09/16/2012

How to organize DVDs excel so that all the pages are linked to a single main page. The main page will have different categories such as genre, actor/actresses, year etc. What I want is when I click on a genre say comedy it should take me to pages which have comedy genre mentioned.

• Status: Open
• Question Views: 679
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By JOY Schilling 5 points N/A #141950

How to organize DVDs excel to link multiple pages to single page?

Hi

 

You want to create an index page in excel. It is very simple. Just Create your sheets like Actors, Actress, Genre etc. And give name as a Index to first Sheet.

Then in Index sheet create a table of index row and column wise. Write your all categories. After writing all categories then provides hyperlinks to that categories. 

 

How to create a list of hyperlinks.

 

1. Click on a cell that contains a sheet name.

 

2. On Excel's Ribbon, click the Insert tab.

3. Click Hyperlink, to open the Insert Hyperlink dialog box.

4. In the Link To list, click on Place in This Document

5. In the list of places in the document, click on a sheet name, then click OK.

About JOY Schilling

Questions
1

Answers
100

Best Answers
28

• Vote Up 0 Vote Down

• Posted on - 10/30/2012
• Question Category: MS Excel