"...to become the leader in providing faster, friendlier, and more affordable subscription-based computer support services."

Ask Dr.Tech solution database


How to disable autorun in Windows.

Thursday, 22 July 2010 12:12 by Jim

Autorun is the most likely way to infect your computer. To prevent this we can disable autorun feature in Windows.

Press Start button ->Run.

In window that has appear type gpedit.msc and press OK button.

 

disable_autorun_drive_cd_rom_usb_thumbdrive.jpg

At the left part of "Group policy" window select "Computer configuration"->"System". Select "Turn off Autoplay" at the left part of screen when "System" is select.

disable_autorun_drive_cd_rom_usb_thumbdrive2.jpg

Double click on "Turn off Autoplay". Point to "Autoplay" and in the drop-down list select "All drives".

Press "Apply" and "OK" buttons.

 

 

Categories:   Windows

How to hide Windows 7 Notification Area & System Clock

Monday, 28 June 2010 19:45 by Jim

If you’d like to display a clean Windows 7 taskbar, you will have to hide the notification area and the system clock which appears on the right side if the Windows taskbar.

1_1_1_1_1_1_1_1_1_1_1_1_1_1_1_1_1.png

To hide the notification area or the system tray which appears in the right side of your Windows taskbar, type gpedit.msc in start search box and hit Enter to open the Group Policy Editor.

Navigate to User configuration > Administrative Templates > Start Menu and Taskbar.

Now double click on the entry Hide the notification area’ Select Enabled button, click Apply > OK.


To hide the System Clock, double click on the entry Remove clock from the system notification area. Select Enabled button, click Apply > OK.

To revert back to the default settings, you have to set it as Disabled or Not Configured.

You can also easily hide the system clock by the following method:
Right click System Clock > Customize notification icons > Turn system icons on/off.

Thats it!

Tags:  
Categories:   Windows | Operating System

Get quick access to Office documents with Outlook 2010 Jumplists

Monday, 28 June 2010 09:31 by Jim

Windows 7 Jumplists are right-click menus or contextual menus in the Windows taskbar that make it easier to find the files and operations you need. If you have a program open, a Jump List will appear in the taskbar.

You can also pin programs to the taskbar so that their Jump Lists are always available. If the currently used program is pinned to the Start Menu, then the Jump Lists will appear from the Start Menu. As you click on the arrow beside the program at the Start Menu, the Jump Lists will pop up.

1_1_1_1_1_1_1_1_1_1_1_1_1_1_1_1.png

With Office 2010 Jumplists, you can have a quick access to Word documents, Excel worksheets or other Office 2010 files. Office 2010 Jump Lists are the menu options that pop up when users right-click on any icon in the taskbar. These Jump Lists help jump to programs that users are recently working on. These files are currently pinned programs to the task bar.

2_1_1_1_1_1_1_1_1_1.png

However, Outlook 2010 makes use of Windows 7’s Jumplists feature for quick access to certain processes which include actions to create a new email, appointment, meeting, contact, or task directly from the Outlook 2010 Jump List.

3_1_1_1_1_1_1_1_1.png

So, with Outlook 2010 you don’t have to open Outlook to perform these operations and can use a few clicks to perform an operation and for quick access to certain processes.

Tags:  
Categories:   Microsoft Office

View Two Parts of the Same Word Document at the Same Time

Friday, 25 June 2010 19:53 by Jim

Long gone are the days of editing your document in a word processor, printing it out, and seeing what you get. The contemporary word processor possesses some of the power of a desktop publishing application.

As usual, Microsoft Word leads the way with more features and convenience tools than any other word processor on the market.

Word’s convenient Print View is a nearly perfect visual representation of how your document will look after you send it to your printer. However, some people prefer the older style Draft View to edit their documents.

Which view you prefer, it is possible in Word to split the screen to view two parts of the same document at the same time.
Why View Two Parts of a Document?

Although there are an infinite number of reasons why you might want to view two parts of the same Word document, there are two that are quite common. First, suppose you are writing a report and you made a list near the top of your document indicating the topics you will cover later in the same document.

By splitting the screen, you can remind yourself of the topics you want to cover while writing about them farther down in your report.

Second, if you write papers for your college classes, you likely use some sort of citation style such as APA, MLA, or Harvard. By splitting the screen, you can search the document for citations in the text to make sure that every citation has a reference in the references section and every reference appears in the document as a citation.

Whatever your reasons, being able to see different parts of the same Word document can be not only convenient but a real time saver as well.
How to See Two Parts of the Same Word Document

To see two parts of the same document, begin by clicking on the View tab on the Word Ribbon and locating the section titled Window. There are a number of options on this part of the Ribbon but to the far right you will see three button titled New Window, Arrange All, and Split. Click on the Split button.

 

1_1_1_1_1_1_1_1_1_1_1_1_1_1_1.png

Word will immediately place a grey line on the screen that you can move up and down with your mouse. This line is simply where you want the split to be on the screen.

It doesn’t matter where you place the split for now because you can move it anywhere to make one or the other split screens the size you want. Place the grey line where you want the initial split and click the left mouse button.

2_1_1_1_1_1_1_1_1.png

Notice that you now have two views of the same document. You can scroll each one independently of the other and see two places in your word document at the same time.

3_1_1_1_1_1_1_1.png

If you play around with the two views for a while you will notice a few things. Each view of the document is treated like two separate documents even though you are viewing the same one. You can zoom, scroll, and even change the type of view (print, draft, outline, etc.) for each view individually.

Because you are simply seeing two views of the same document, any changes you make to one will be made to the other view as well. In fact, you can edit the text in either view by simply clicking on it and typing.

Having two views of the same Word document can save you time by allowing you to edit one view while not losing sight of the second. Using the split screen feature in Word, you can spend less time scrolling and more time getting your work done.

Tags:  
Categories:   Microsoft Office

Prevent Users from Shutting Down Windows 7 Unless They are Logged In

Thursday, 24 June 2010 10:38 by Jim

For the average user, there aren’t many differences among the multiple versions of Windows 7 until you get to the server and other enterprise level versions of the operating system. Consequently, some options that are just fine for home use end up enabled in versions intended for use in work environments.

One such case has to do with whether just anyone can shut down a PC running Windows 7 even if that person isn’t logged in to the system. If you log off your Windows 7 account, you will notice that by default, there is a button to shut down the system in the lower right hand corner of the login screen. There is a setting in all versions of Windows 7 to remove that button forcing a person to login before he/she can shut the system down.
Why Restrict Shut Downs to Logged in Users?

It may seem like a trivial matter to prevent someone from shutting down a PC from the Windows 7 login screen, but consider this: Some computers such as those in a kiosk, public café, or work environment need to have certain aspects disabled to avoid negatively affecting other people who need the PC.

Of course, anyone with physical access to a computer can just push the button on the front and shut the computer down. However, not everyone has physical access to a computer; some people connect to a computer remotely. If they are in the habit of shutting down a computer when they are finished with it, they deny anyone else access to the PC until it is started up again.

Most administrators deny users the ability to shut down a networked PC. By removing the ability to shut down a Windows 7 computer from the login screen, you further prevent frustration on the part of other users who need the computer if someone were to accidently or purposely shut down a multi-user computer.
How to Remove the Shut Down Button on the Login Screen

To remove the Windows 7 shut down button on the login screen you must edit a local policy setting. Begin by logging into Windows 7 with an account that has administrative privileges. Then, click on Start>All Programs>Administrative Tools>Local Security Policy.

1_1_1_1_1_1_1_1_1_1_1_1_1_1.png

You should now be looking at the Local Security Policy window. In the left hand pane, locate and click on the folder titled Local Policies and then click on the folder titled Security Options.

2_1_1_1_1_1_1_1.png

In the right hand pane, locate a security policy titled Shutdown: Allow System To Be Shut Down Without Having To Log In. Right click on this option and select Properties.

3_1_1_1_1_1_1.png

You’ll notice that this option is Enabled by default. Click on the Disabled option and then click the OK button. Close the Local Security Policy window and you are done.

4_1_1_1_1_1_1.png

To test if the option has taken effect, log out of your account and notice that the log off button no longer appears on the login screen.

Although a trivial matter where people have physical access to a PC, you can prevent just anyone from shutting down a Windows 7 computer. In this way, only people who can log in to the operating system and have the right to shut down the system can do so.

In networked and public computer environments, administrators typically disallow anonymous shut downs to avoid user frustration and lost work hours.

Categories:   Windows | Operating System

How to Sort Text in Word

Wednesday, 23 June 2010 20:40 by Jim

When most people think of sorting text in an application, they think of sorting cells in an Excel spreadsheet. However, you can sort text in Word as long as there is something that tells Word where the different parts of text begin and end.
Sorting Lists in Word

There are three types of lists you can sort in Word. The first kind is simply a list of words or phrases that each occupies a separate line. The second type is unordered or bulleted lists. The third is ordered or numbered lists.

In each of these cases, a line break (also called a carriage return) tells word where one word or phrase ends and the next one begins. This is how Word is able to sort text in the document.

1_1_1_1_1_1_1_1_1_1_1_1_1.png

To sort any of these types of lists, begin by selecting the list with your mouse. Simply start at the beginning of the list, hold down the left mouse button, and drag your mouse until the entire list is selected.

Then, click on the Home tab on the Ribbon and locate the section titled Paragraph. Look for a button with the letters A and Z on it and an arrow pointing down. This is the Sort command. Click on the Sort button and Word will open the Sort Text window.

2_1_1_1_1_1_1.png

On the Sort Text window, you’ll notice that there a number of options. First, you need to indicate that you want to sort the text you’ve selected by paragraph. Even though we only have one word per line, Word still considers each line to be its own paragraph because we pressed the enter key to get to the next line. Sorting by paragraph is the default option.

3_1_1_1_1_1.png

Next we need to tell Word what we are sorting. Locate the drop down menu labeled Type and choose Text. This is also the default option. Lastly, we need to tell Word whether we want to sort the text in ascending (A to Z) order or descending order (Z to A). Ascending order is the default option. When done, click the OK button and Word will sort your text with the options you chose.

4_1_1_1_1_1.png

Notice that now the text is sorted from A to Z in ascending order.
Sorting Text in Tables

This type of sorting may seem a bit more familiar to you if you often sort data in Excel. Much like an Excel worksheet, a table contains rows, columns, and may contain headings in the first row. Luckily, Word gives you much of the same flexibility to sort text as found in Excel.

Suppose you have a table in Word that looks like the one below.

5_1_1_1_1.png

Notice that there are column headings in the first row and that the first column contains the text we wish to sort. Let’s assume that we want to sort the data in descending order this time. Select the entire table and once again click on the Sort button in the Paragraph section of the Ribbon.

Notice in the bottom left hand corner of the Sort window that Word has already detected the headings in the first row. Notice also that the first Sort By drop down menu already has the column heading Name in the option box.

The rest of the options stay the same except remember to change the sort direction to Descending. When done, click the OK button and Word will sort the table using the options we’ve chosen.

6_1_1.png

Sorting text in Word is simple as long as you have a way to tell word what separates one data element from the next. If you play with the sort settings a bit you will discover that you can sort using multiple columns and even tab and comma delimited text in a Word document.

Although not as useful as sorting data in Excel, you can save yourself some time in Word by having the application sort paragraph and table text for you using a similar interface as found in an Excel worksheet.

Tags:  
Categories:   Microsoft Office

Recover Lost Data Using Excel’s Automatic Backup Feature

Monday, 21 June 2010 19:56 by Jim

If you often work with large spreadsheet files, you know how frustrating it can be to lose data because of a stupid mistake or because your computer crashed while you were working with your data. Using Excel’s automatic backup feature, you can recover your lost spreadsheet data and continue working as if nothing happened.

A few of the most useful features found in the Microsoft Office suite are underused because they are hard to find. Excel’s automatic backup and recovery option is just such as feature. Read on to learn why you should use Excel’s automatic backup and how to recover lost spreadsheet data.
Why Use Excel’s Backup and Recovery Feature?

It may seem obvious why you should use a backup feature in any program but Excel is a bit different from other application such as Microsoft Word. Many Excel spreadsheets use formulas to compute new figures across its cells. In a large spreadsheet, it is not always easy to see which cells affect other cells. Making one small change can have a domino effect and ruin other calculations in the worksheet.

Suppose you make a change to a cell’s formula and save your work. Later you discover that you made a mistake and can’t remember the exact formula previously used or the exact cell where the formula resided. It would be convenient if you could revert back to the last save state to undo your mistake. Using Excel’s built in backup and recovery option, you can do just that.
Activate Excel’s Backup Feature

The option to activate Excel’s backup feature is somewhat hidden given how useful it is. Begin by clicking on the Excel Jewel in the top left hand corner of your spreadsheet and selecting Save from the menu.

1_1_1_1_1_1_1_1_1_1_1_1.png

You should now be looking at the Excel Save dialogue window. For our purposes here, we will save the file to the user’s desktop. Name your file in the File Name box. Before you click the Save button, click the arrow next to the button labeled Tools and select General Options from the menu.

2_1_1_1_1_1.png

Excel will open up a very small window with several options available. The only option we are interested in here is the one titled Always Create Backup. Check this option.

3_1_1_1_1.png

You may notice that there are three other options in this window. You can set a password for both opening (viewing) and modifying (editing) your Excel file. If you set any of these passwords, they will transfer to the backup file as well.

So, use these options with caution because if you forget your password, you won’t be able to gain access to either your main or backup file. You can also set the file to read only. Although Microsoft recommends that you use this option, you may wish to skip over it if you often share your spreadsheets with other people who need the ability to modify its contents.

Click the OK button and Excel will create a backup file in the same location as main file each time you save. Save your file once again to create the first backup file. If we go to the desktop where we saved the spreadsheet you will notice two new files, one with a strange XLK file extension.

4_1_1_1_1.png

The XLK file is your backed up spreadsheet that contains the contents of your file before the last save. If you need to use this backed up file because of a mistake you made or because of a computer crash, click on it and Excel will ask you to verify that you truly want to open up this file.

This step seems a bit strange given that Excel should know what the file is. Simply click on the Yes button and you can restore your spreadsheet to the way it was before the last save.

5_1_1_1.png

Using Excel’s hard to find backup and recovery option, you can force Excel to create a backup copy of your spreadsheet. This backup copy contains the data and formulas of your file before your last save.

You can open this file to remove any mistakes you made while editing your main Excel file. If you often find yourself editing large spreadsheets, this backup option is a must.

Tags:  
Categories:   Windows | Microsoft Office

Freeze Panes to Make Excel Spreadsheets Easier to Use

Sunday, 20 June 2010 08:23 by Jim

Excel is one of the most popular applications for both the home and office in Microsoft’s suite of productivity software. Functioning as a kind of two-dimensional database, Excel can help you store any information you need to keep track of.

The only problem with Excel occurs when your spreadsheet contains more than just a few columns and rows. While scrolling through your data, you can easily lose track of what data is contained in the columns and rows forcing you to scroll all the way to top or all the way to the left just to see what data you are looking at. By freezing panes, you can avoid this confusion and work more efficiently.
Why Freeze Panes?

One feature missing from Excel is the ability to permanently rename the columns and rows as you can in other specialized applications. Excel only give you generic A, B, C, etc. column and 1, 2, 3, etc. row designations. If you are like most spreadsheet users, you use the top row and first column to give your rows and columns useful headings.

When you freeze panes, you make it so the first column or top row do not move with the rest of the spreadsheet as you scroll either up and down or left and right. This way, you can keep track of your column or row headings and you can avoid having to scroll to see if you are in the right column or row. In addition, you can even create custom panes and freeze them so you always have the information you need in front of you.
Freeze Top Row

The most common use of Excel’s Freeze Pane feature is to freeze the top row that contains the column headings in the spreadsheet. To freeze the top row, begin by clicking on the View tab on the Ribbon and locating the large section titled Window. Locate and click on the button titled Freeze Panes.

1_1_1_1_1_1_1_1_1_1_1.png

You’ll notice that you have three options. Click on the second option titled Freeze Top Row.

2_1_1_1_1.png

Notice that Excel indicates the freezing of the top row with a solid black line between rows 1 and 2. You should also notice that as you scroll down the spreadsheet, the top row stays where it is while all of the other rows scroll. To unfreeze the top row, click on the Freeze Panes button on the Ribbon and select the Unfreeze Panes button.
Freeze First Column

Although less popular then freezing the top row, you can also freeze the first column in the same way. Click on the Freeze Panes button again on the Ribbon and this time select the button titled Freeze First Column.

3_1_1_1.png

Notice, again, that Excel indicates the frozen pane with a black line but this time you will find it between columns 1 and 2. Also notice that as you scroll left and right, the first column stays where it is while all of the other columns scroll. To unfreeze the first column, click on the Freeze Panes button on the Ribbon and select the Unfreeze Panes Button.
Freeze Custom Panes

The second and third buttons on the Freeze Panes menu described above are really only there for your convenience because those are the two most common panes frozen in Excel. You can actually freeze any cells you want to create custom panes. You can even freeze a combination of both rows and columns.

To create a custom frozen pane, click on any cell in your spreadsheet. Now click on the Freeze Panes button on the Ribbon and this time click on the button titled Freeze Panes.

4_1_1_1.png

You will notice that Excel froze the cells to the left and above the active cell. Using this method, you can simultaneously freeze both the rows and columns you want. To unfreeze your custom pane, click on the Freeze Panes button on the Ribbon and select the Unfreeze Panes Button.

Freezing panes in Excel can help make large spreadsheets more management by eliminating the need to constantly scroll to the top or left to see the headings of the cells in which you are working.

Although Excel gives you the option to freeze only the top row and the first column, you can select any cell, choose Freeze Panes from the Ribbon, and create your own custom pane.

Tags:  
Categories:   Microsoft Office

Move the Taskbar to Different Locations In Windows

Thursday, 17 June 2010 19:49 by Jim

Most of you are probably used to the Taskbar always being at the bottom of the screen and have never thought about moving it. Here we show you how to move it to any of the four corners of the desktop in XP, Vista, and Windows 7.

Move the Taskbar

Right-click an empty area on the Taskbar and uncheck Lock the taskbar.

 

1_1_1_1_1_1_1_1_1_1.png

Now that it’s unlocked, hold down the left mouse button and drag it to any of the four sides of your desktop. Here we take a look at it on the right side in Windows 7.

2_1_1_1.png

Here is a look at what it looks like at the top of the Desktop. Wherever you reposition it, you’ll probably want to move some of your Desktop icons around accordingly.

3_1_1.png

On the left side…with it on this side it made sense to move shortcuts to the right side of the desktop.

4_1_1.png

On the right side in Vista…

5_1_1.png

Finally a look at it on top in Windows XP.

6_1.png

This actually can be handy if you have a widescreen monitor and are reading documents in full screen. If you’ve always had it on the bottom, it definitely takes some getting used to having it in other spots. However, you might want to experiment and potentially find a new location for the Taskbar full time.

Categories:   Windows

How to create a shortcut or hotkey to eject the CD/DVD Drive

Saturday, 5 June 2010 20:04 by Jim

Right-click on the desktop or elsewhere and choose New \ Shortcut.

1_1.png

In the location box, put the full path to the nircmd.exe file that you downloaded, and append the “cdrom open” command to the end of it, adjusting the drive letter to match your disc drive:

“C:\path\to\nircmd.exe” cdrom open D:

Note the location of the quotes.. if you are using a path with spaces in it, you need to make sure the quotes are only around the path to the executable, and the arguments should be placed after the quote.

2_1.png

Give the shortcut a meaningful name, like Eject CD or something like that, and you’ll have a new icon (read below on how to use the cd-rom icon as shown)

3_1.png

You can move the icon to anywhere you’d like… double-clicking on it will immediately eject the drive.

Create a Shortcut to Close the CD/DVD Drive

You can follow the same exact instructions as above, but instead of “cdrom open” just substitute “cdrom close”.

Assign a Hotkey to the Shortcut

Now that we have a shortcut, we can assign a hotkey to the shortcut by right-clicking on the icon and choosing Properties. On the Shortcut tab you’ll see a place to assign the Shortcut key:

4_1.png

Add in the shortcut key and close the dialog. As long as the shortcut is on your desktop you shouldn’t have to restart anything for the hotkey to work. You can also move the shortcut to another folder, for instance your quick launch bar.

Tip: If you add the shortcut to the Windows Vista quick launch bar, you can use the built-in hotkeys instead of bothering to assign one manually.

Assign an Icon to the Shortcut

If you click on the Change Icon button in the properties window, you can give the shortcut a more meaningful icon, perhaps the DVD one you see below.

5_1.png

http://www.nirsoft.net/utils/nircmd.html

Categories:   Third-party Software

Sign up now - $98.00 annual plan
Also available plans: 15 day money back guarantee
per-incident $19.00
monthly plan* $24.00
* Plans include unlimited number of support incidents

A “must-have” service


Using Ask Dr. Tech is like having your personal technician always at hand *
* for only 26 cents per day