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.

Shortcuts

When I perform a feature, like insert a row into EXCEL, I would like to know if there is a shortcut to repeat this feature without going through longer steps.



Yes, there is a quicker way to repeat steps previously performed and this can be used in all Office programs and numerous other programs including Paint Shop Pro. Once you have made the first step: Hold down the CTRL key and tap the ‘Y’ key as many times as you wish to repeat the step i.e. if you have just inserted a row in EXCEL hold down the CTRL key and tap the ‘Y’ key for as many rows as you need to insert. They will be inserted one after the other as you ‘tap.’

Is there a shortcut to add the current date in an Excel Worksheet?



When using Microsoft Excel there are many shortcuts you can use to speed up your work. One of the most used is the shortcut for inserting the current date.
Hold down the CTRL key and click the ‘colon key’ The current date will be inserted.
If you would like more help with this and other features please visit this page.
Insert today's date in Excel

How often should I save my work when working on a document?



It’s always a good idea to save your work every ten minutes when working on a document especially if it is a lengthy document.

There is a quick way to do this using a ‘shortcut.’

Hold down the CTRL key and click on the ‘S’ key.

Save your work

I have created a Word document with 35 pages. Is there a way to jump to the last page quickly without scrolling down manually?



To jump to the last page or the end of any document quickly just hold down the CTRL key and click the ‘End’ key.

Jump to last page

How can I copy an Excel Formula into a column that has more than 200,000 lines without dragging it manually?



There are quite a few options for performing this procedure. I have chosen two that are listed below beginning with the easiest:

Easiest:

  • Add a formula to the first cell in the column.
  • Click into the cell and locate the “fill handle” which is the small cross that appears on the bottom right corner of a cell when you point to it.
  •  “Double click” the “fill handle with your left mouse.
  • The formula in the first cell will be copied into all the cells in the column ending on the line that has the last entry in your worksheet.

Another Option:

1. Click into the cell that contains the formula.
2. Click the F5 key and type a range. Example: G2:G227
3. Click into the “formula bar” 

4. Click the CTRL key plus the “Down Arrow” key and hit the ENTER key.

The formula will fill all the cells in the range automatically.

How do I Show or Hide a Toolbar?



Show a Toolbar:

1. Right-click the menu bar or any toolbar.
2. Click the name of the toolbar that you want to show on the shortcut menu.
NOTE: If you don’t see the toolbar that you are looking for on the shortcut menu, click “Customize” and then click the “Toolbars” tab. In the Toolbars list, select the check box next to the name of the Toolbar that you want.

Show a Toolbar – Keyboard Method:

  • On the “Tools” menu, click “Customize.”
  • Click the “Toolbars” tab.
  • Select the check box next to the name of the Toolbar that you want to display.

Hide a Toolbar:

Right-click the toolbar, and then clear the check box next to the name of the toolbar that you want to hide.

Hide a Toolbar – Keyboard Method:

  • On the “Tools” menu, click “Customize.”
  • Click the “Toolbars” tab.
  • Clear the check box next to the name of the toolbar that you want to hide.

How do I create a Desktop shortcut to the Contacts folder in Outlook.



1.  Open the Search field of the Start Menu

2.  Type outlook.exe in the Search field. (Don’t click “enter.”)

Search for outlook.exe3.   When you see the icon appear on the list above the Search Field right click on it and choose; Send To-> Desktop  (create shortcut)

Right Click on Properties

4.  Right-click the shortcut you just created, and from the shortcut menu click “Properties.”   

Outlook Desktop ShortcutOutlook Properties
5.   On the Shortcut tab, locate the “Target box.” It contains the path for Outlook.exe.

6.  Press the “Spacebar” once to type a space after the path, and then type; /select outlook:contacts (include the space after “select.”)

Select Outlook Contacts

7.  Click OK.

 8.  On the desktop, double-click the Outlook shortcut    Outlook Desktop Shortcut that you created and your contact list or lists will appear.

Please contact me if you need more help with this feature by clicking on the blue button in the right hand column. I will answer promptly.

When typing the temperature I would like to insert a “degree” symbol automatically instead of writing the word “degrees.” Is there a shortcut for this symbol?



Yes, there are two shortcuts for the degree symbol.

1. Hold down the ALT key and type 0176 on the numeric keyboard. The degree
symbol will appear immediately ° You must use the numeric keypad to
type the numbers and not the keyboard. Make sure that the NUM LOCK key
is on if your keyboard requires it to type numbers on the numeric
keypad.

2. AutoCorrect has a predefined keyboard shortcut for creating a degree
symbol. Press CTRL+@, then press SPACEBAR.

If I cannot close my computer using the Start Button or my computer freezes, is it OK to pull the plug?



No, it is not advisable to “pull the plug” if your computer freezes. The “shock” of pulling the plug on a working computer could cause the hard drive to crash or malfunction.

The safe way to close down the computer is to hold down the CTRL, ALT and DELETE keys simultaneously, which will bring up the Windows Task Manager. This “tool” allows you to close the troublesome program or programs and then continue working on your computer without closing down your system. It also has an option to ‘Disconnect’ or ‘Logoff’ under the ‘Users’ tab.