Frequently Asked Questions



Questions Answered
Click on a question; the answer will drop down.


Click again and the answer will close.

Every day Pamela receives numerous questions from troubled computer and iPad/iPhone users, by email and at various seminars and workshops. Her answers provide advice on a variety of subjects related to computer hardware and software and Apple iPad and iPhones. Listed below are the questions that Pamela feels will be helpful to most users, from beginners to the more advanced.

If you cannot find the answer to your question listed below, ask Pamela your questions here or click on the ‘Ask Pamela’ link on the sidebar menu below the category list. You can also leave Pamela a Message by clicking on the Blue Button at the bottom of the right hand sidebar. Pamela always answers promptly.

Hyperlink

I have created twelve worksheets and a general ledger to do my monthly banking in EXCEL. How can I jump back and forth from the General Ledger worksheet to any given month without scrolling through all the worksheets at the bottom of the workbook?



  • From one of the monthly worksheets type GL for General ledger.
  • Highlight and right click on GL then choose ‘Hyperlink’ from the drop down menu.
  • Click on ‘Bookmark’ and then choose the ‘General Ledger’ from the drop-down list that appears.
  • Click OK and the hyperlink to your General Ledger will be active from your worksheet.

Repeat these steps throughout your workbook.

How do I remove the Hyperlink from the email addresses in an Excel list?



Email hyperlinks in a list in Excel can cause a new email to open if you accidentally click on them so it’s a good idea to remove the hyperlink so that changes can be made to the email address without causing a new email to open.

Right click on the email address and choose “Remove Hyperlink” which is the last option on the list if you are using Excel 2007.