Get instant live expert help on how to create an index in excel

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I have an excel workbook with over 100 worksheets in it. (no I didn't create it, just inherited it..). Is there a way to get a list or index of all of the worksheet names?
Solved by O. H. in 17 mins
Hello, I am using Excel 2016 to create a workbook that contains an index sheet and then several reference sheets. I am attempting to create hyperlinks on the index sheet to jump to the reference sheets and then I want to convert the workbook into a pdf. My hyperlinks all work as expected within excel but seem to be disabled in the pdf document. I have searched the web and this seems to be a common issue with lots of ideas on how to resolve it but none have worked
Solved by T. B. in 11 mins
how to create an RFM analysis on excel for customer transactions
Solved by K. A. in 24 mins
I want a clear explanation on how to create a gantt chart in excel with an example
Solved by X. W. in 27 mins
how can I change the sumproduct formula to an index match
Solved by O. H. in 20 mins