How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Lindie Your Own Question

Lindie
Lindie, Computer Repairer
Category: Computer
Satisfied Customers: 5490
Experience:  Have worked with computer since 1998. From software to hardware
163146
Type Your Computer Question Here...
Lindie is online now
A new question is answered every 9 seconds

Excel question

Customer Question

Can the worksheets in an Excel workbook be shown in a "table of contents" format - e.g. in a column on their own worksheet - rather than having to scroll across the bottom.
Submitted: 11 years ago.
Category: Computer
Expert:  Lindie replied 11 years ago.

If I am understanding your question.. With wanting to see your document on one screen.


When you have Excel open.


Near the top where you see .. FILE.. EDIT.. VIEW.. Click on view.. Click on "Page Break Preview" That will bring up all the pages up on one screen.


Let me know if thats what you are talking about.. or if there is anything else I can do.



Customer: replied 11 years ago.
Reply to Lindie's Post: I did not do a good job of asking the question. I work with Excel a lot so I know how to scroll quickly across the worksheet bar, but I will be selling a service soon using Excel workbooks and...the customers may not be fluent in Excel.
   Suppose I had an Excel workbook with worksheet names A,B,C.......AA,BB,CC - maybe 40 sheets total. Is there a way, on a separate worksheet, to display these titles like a table of contents in a book, on a "title" worksheet?
A person could see all worksheets in a column and then click to go to it.
Expert:  Lindie replied 11 years ago.
If I am understanding your question better. I think this is what you are wanting to do... Let me know either way OK??

You need to start a new Workbook, then you pick a cell that you want to make your link for a page,


Go to that cell, then up on top go to the INSERT tab, open that up,

click on the HYPERLINK tab, a window will open up

click on PLACE IN THIS DOCUMENT

The amount of pages in your workbook will be in the little window,

Type the name you want displayed up on top

in the middle window type the cell letter and number

then click on the page you want the link to go to.


I guess adjust the cells so your names will fit in one cell instead of bleeding into the others.


On each page of your workbook you should put a link back to the title page. It makes it easy to get back instead of them wondering how to.

JustAnswer in the News:

 
 
 
Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.
 
 
 

What Customers are Saying:

 
 
 
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
< Previous | Next >
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
  • I am very happy with my very fast response. Eric is very knowledgeable in the subject area. Thank you! RP Austin, TX
  • Hi John, Thank you for your expertise and, more important, for your kindness because they make me, almost, look forward to my next computer problem. After the next problem comes, I'll be delighted to correspond again with you. I'm told that I excel at programing. But system administration has never been one of my talents. So it's great to have an expert to rely on when the computer decides to stump me. God bless, Bill Bill M. Schenectady, New York
  • The Expert answered my Mac question and was patient. He answered in a thorough and timely manner, keeping the response on a level that could understand. Thank you! Frank Canada
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
 
 
 

Meet The Experts:

 
 
 
  • Andy

    Andy

    Computer Consultant

    Satisfied Customers:

    5316
    11yr exp, Comp Engg, Internet expert, Web developer, SEO
< Last | Next >
  • http://ww2.justanswer.com/uploads/EN/Engineer1010/2012-6-9_132423_jaj12a.64x64.jpg Andy's Avatar

    Andy

    Computer Consultant

    Satisfied Customers:

    5316
    11yr exp, Comp Engg, Internet expert, Web developer, SEO
  • http://ww2.justanswer.com/uploads/CO/ComputEngineer/2012-2-6_20858_20111114201751jalogoold.200x200.64x64.jpg Engineer John C.'s Avatar

    Engineer John C.

    Computer Science Engineer

    Satisfied Customers:

    3220
    Computer Science Engineer with 10 years of experience in Computer Support, and Microsoft, A+ and Cisco certified
  • http://ww2.justanswer.com/uploads/ZE/zeyank/2014-12-9_221254_zeyank.64x64.png Ryan H.'s Avatar

    Ryan H.

    Computer Support Specialist

    Satisfied Customers:

    1741
    A+ Certified Technician - 10 Years experience working with all types of computer systems.
  • http://ww2.justanswer.com/uploads/JA/jadedangel/2015-8-10_192649_janenewsm.64x64.jpg Jane Lefler's Avatar

    Jane Lefler

    Sr Prog Analyst / Technician

    Satisfied Customers:

    0
    Computer Programmer / Technician/ Consultant 16+ years
  • http://ww2.justanswer.com/uploads/FS/fszcze/2012-6-18_181848_500test.64x64.jpg Frederick S.'s Avatar

    Frederick S.

    Computer Specialist

    Satisfied Customers:

    7241
    Computer technician and founder of a home PC repair company.
  • http://ww2.justanswer.com/uploads/lifesaver333/2010-10-17_191349_ls.jpeg lifesaver's Avatar

    lifesaver

    Computer Software Engineer

    Satisfied Customers:

    4288
    Engineering degree in Computer science,Microsoft Certified Professional.JA computer expert.
  • http://ww2.justanswer.com/uploads/WI/Windowspcfix/2013-8-19_153826_ja12.64x64.jpg James K.'s Avatar

    James K.

    Consultant

    Satisfied Customers:

    4103
    Technical Director of IT Company