List Of All Excel Keyboard Shortcuts

	Microsoft Excel has the basic features of all spreadsheets,using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering and financial needs. In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display. It allows sectioning of data to view its dependencies on various factors for different perspectives (using pivot tables and the scenario manager).It has a programming aspect, Visual Basic for Applications, allowing the user to employ a wide variety of numerical methods, for example, for solving differential equations of mathematical physics,and then reporting the results back to the spreadsheet. It also has a variety of interactive features allowing user interfaces that can completely hide the spreadsheet from the user, so the spreadsheet presents itself as a so-called application, or decision support system (DSS), via a custom-designed user interface, for example, a stock analyzer,or in general, as a design tool that asks the user questions and provides answers and reports.In a more elaborate realization, an Excel application can automatically poll external databases and measuring instruments using an update schedule,analyze the results, make a Word report or PowerPoint slide show, and e-mail these presentations on a regular basis to a list of participants.                                     All Excel Keyboard Shortcuts F1 Displays the Office Assistant or (Help > Microsoft Excel Help) F2 Edits the active cell, putting the cursor at the end F3 Displays the (Insert > Name > Paste) dialog box F4 Repeats the last worksheet action (Edit > Repeat) F5 Displays the (Edit > GoTo) dialog box F6 Moves to the next pane in a workbook (if the window is split) F7 Displays the (Tools > Spelling) dialog box F8 Toggles whether to extend a selection with the arrow keys F9 Calculates All the worksheets in All the open workbooks F10 Toggles the activation of the Menu Bar F11 Displays the (Insert > Chart) dialog box that creates a chart (on a chart sheet) using the highlighted range F12 Displays the (File > Save As) dialog box Shift + F2 Inserts or edits a cell comment (Insert > Comment) Shift + F3 Displays the (Insert > Function) dialog box Shift + F4 Repeats the last Find, the same as (Edit > Find Next) Shift + F5 Displays the (Edit > Find) dialog box Shift + F6 Moves to the previous pane in a workbook (if the window is split) Shift + F8 Toggles between switching Add Mode on or off* Shift + F9 Calculates just the active worksheet Shift + F10 Displays the (Shortcut) menu for the selected item Shift + F11 Inserts a new worksheet (before the active sheet) into the active workbook (Insert > Worksheet) Shift + F12 Saves, Displays the (File > Save As) dialog box if a new workbook Ctrl + F1 Closes and reopens the current task pane (ribbon in 2007) Ctrl + F2 Print Preview Ctrl + F3 Displays the (Insert > Name > Define) dialog box Ctrl + F4 Closes the selected workbook window Ctrl + F5 Restores the size of the active workbook or window Ctrl + F6 Moves to the next open workbook or window Ctrl + F7 Activates the Move window command Ctrl + F8 Activates the Resize window command Ctrl + F9 Minimises the size of the active workbook or window Ctrl + F10 Maximises the size of the active workbook or window Ctrl + F12 Displays the (File > Open) dialog box Alt + F1 Creates a chart (on a chart sheet) using the highlighted range Alt + F2 Displays the (File > Save As) dialog box Alt + F4 Closes all the workbooks (saving first) and exits Excel (File > Exit) Alt + F8 Displays the (Tools > Macro > Macros) dialog box Alt + F11 Toggles between the Visual Basic Editor window and and the Excel window Alt + Ctrl + F9 Calculates All cells on All worksheets in All workbooks Alt + Shift + F1 Inserts a new worksheet (before the active sheet) into the active workbook (Insert > Worksheet) Alt + Shift + F2 Displays the (File > Save As) dialog box Alt + Shift + F4 Closes all the workbooks (saving first) and exits Excel (File > Exit) Alt + Shift + F10 Displays the drop-down menu for the corresponding smart tag Alt + Shift + F11 Activates the Microsoft Script Editor window Ctrl + Shift + F3 Displays the (Insert > Name > Create) dialog box Ctrl + Shift + F6 Moves to the previous open workbook or window Ctrl + Shift + F10 Activates the Menu Bar or Shortcut Characters in 2007 Ctrl + Shift + F12 Displays the (File > Print) dialog box Ctrl + 0 Hides the columns in the current selection Ctrl + 1 Displays the formatting dialog box Ctrl + 2 Toggles bold on the current selection Ctrl + 3 Toggles italics on the current selection Ctrl + 4 Toggles underlining on the current selection Ctrl + 5 Toggles the strikethrough of text on the current selection Ctrl + 6 Toggles between hiding, displaying Ctrl + 8 Toggles the display of Outline symbols on the active worksheet Ctrl + 9 Hides the rows in the current selection (Format > Row > Hide) Ctrl + Shift + 0 Unhides the columns in the current selection Ctrl + Shift + 2 Enters the value from the cell directly above into the active cell Ctrl + Shift + 8 Selects the current region (surrounded by blank rows and columns) Ctrl + Shift + 9 Unhides the rows in the current selection Ctrl + A Displays formula palette given a function name or selects the whole worksheet or current date Ctrl + B Toggles bold on the current selection Ctrl + C Copies the current selection to the clipboard Ctrl + D Copies the first cell in the selection downwards Ctrl + F Displays the Find dialog box Ctrl + G Displays the GoTo dialog box Ctrl + H Displays the Replace dialog box Ctrl + I Toggles italics on the current selection Ctrl + K Displays the Insert Hyperlink dialog box Ctrl + L Displays the Create Table dialog box Ctrl + N Creates a new workbook Ctrl + O Displays the Open dialog box Ctrl + P Displays the Print dialog box Ctrl + R Copies the leftmost cell in the selection to the right Ctrl + S Saves, Displays the Save As dialog box if a new workbook Ctrl + U Toggles underlining on the current selection Ctrl + V Pastes the entry from the clipboard Ctrl + W Closes the active workbook or window Ctrl + X Cuts the current selection to the clipboard Ctrl + Y Repeats the last workbook action Ctrl + Z Undo the last workbook action Ctrl + Shift + F Activates the Font Tab of the format cells Ctrl + Shift + O Selects all the cells with comments Ctrl + Shift + P Activates the Font Size tab of the format cells Enter Enters the contents of the active cell and moves to the cell below (by default) Shift + Enter Enters the contents of the active cell and moves to the cell above (by default) Tab Enters the contents of the active cell and moves one cell to the right Shift + Tab Enters the contents of the active cell and moves one cell to the left Alt + = Enters the SUM() function (AutoSum) to sum the adjacent block of cells Alt + 0128 Enters the euro symbol (€) (using Number keypad) Alt + 0162 Enters the cent symbol (¢) (using Number keypad) Alt + 0163 Enters the pound sign symbol (£) (using Number keypad) Alt + Enter Enters a new line (or carriage return) into a cell Ctrl + ' Enters the contents from the cell directly above into the active cell Ctrl + Shift + 2 Enters the value from the cell directly above into the active cell Ctrl + ; Enters the current date into the active cell Ctrl + Shift + ; Enters the current time into the active cell Ctrl + Shift + Enter Enters the formula as an Array Formula Shift + Insert Enters the data from the clipboard Alt + Down Arrow Displays the Pick From List drop-down list Esc Cancels the cell entry and restores the original contents Delete Deletes the selection or one character to the right Backspace Deletes the selection or one character to the left Shift + Delete Cuts the selection to the clipboard Ctrl + Delete Deletes text to the end of the line Ctrl + - Displays the Delete dialog box Ctrl + Shift + = Displays the Cells dialog box Ctrl + \ Selects the cells in a selected row that do not match the value in the active cell Ctrl + Shift + \ Selects the cells in a selected column that do not match the value in the active cell Ctrl + / Selects the array containing the active cell ?? Alt + ; Selects the visible cells in the current selection Ctrl + Shift + (8 or *) Selects the current region (surrounded by blank rows and columns) Ctrl + * Selects the current region (using the * on the number keyboard) Ctrl + [ Selects all the cells that are directly referred to by the formula in the active cell (precedents) Ctrl + Shift + [ Selects all the cells that are directly (or indirectly) referred to by the formula in the active cell Ctrl + ] Selects all the cells that directly refer to the active cell (dependents) Ctrl + Shift + ] Selects all the cells that directly (or indirectly) refer to the active cell Ctrl + Shift + Page Down Selects the active worksheet and the one after it Ctrl + Shift + Page Up Selects the active worksheet and the one before it Ctrl + Shift + Spacebar Selects all the objects on the worksheet when an object is selected or selects the whole worksheet Ctrl + Spacebar Selects the current column Shift + Arrow keys Selects the active cell and the cell in the given direction Shift + Backspace Selects the active cell when multiple cells are selected Shift + Spacebar Selects the current row Ctrl + Shift + Arrow Key Extends the selection to the next cell adjacent to a blank cell in that direction Ctrl + Shift + End Extends the selection to the last used cell on the worksheet Ctrl + Shift + Home Extends the selection to the beginning of the worksheet Shift + Arrow Keys Extends the selection by one cell in that direction Shift + Home Extends the selection to the first column Shift + Page Down Extends the selection down one screen Shift + Page Up Extends the selection up one screen End + Shift + Arrow Keys Extends the selection to the next non-blank cell in that direction End + Shift + End Extends the selection to the last cell in the current row* End + Shift + Home Extends the selection to last used cell on the worksheet Alt + ' Displays the Style dialog box Ctrl + Shift + ( ' or ) Applies the Time format "hh:mm" to the selection Ctrl + Shift + (1 or !) Applies the Comma separated format "#,##0.00" to the selection Ctrl + Shift + (4 or $) Applies the Currency format "£#,##0.00" to the selection Ctrl + Shift + (5 or %) Applies the Percentage format "0%" to the selection Ctrl + Shift + (6 or ^) Applies the Exponential format "#,##E+02" to the selection Ctrl + Shift + (# or ~) Applies the General format to the selection Ctrl + (# or ~) Applies the Custom Date format "dd-mmm-yy" to the selection Ctrl + Shift + (7 or &) Applies the outline border to the selection Ctrl + Shift + (- or _ ) Removes all the borders from the selection Arrow Keys Moves to the next cell in that direction Ctrl + Tab Moves to the next open workbook or window Alt + Tab Moves to the next application open on your computer Alt + Shift + Tab Moves to the previous application open on your computer Enter Moves to the cell directly below Tab Moves to the next cell on the right (or unprotected cell) Home Moves to the first column in the current row End + Arrow Keys Moves to the next non empty cell in that direction End + Enter Moves to the last cell in the current row that is not blank End + Home Moves to the last used cell on the active worksheet* End + Home Moves to the last used cell on the active worksheet* Page Down Moves to the next screen of rows down Page Up Moves to the previous screen of rows up Shift + Enter Moves to the cell directly above (opposite direction to Enter) Shift + Tab Moves to the cell directly to the left (opposite direction to Tab) Alt + Page Down Moves you one screen of columns to the right Alt + Page Up Moves you one screen of columns to the left Ctrl + Home Moves to cell "A1" on the active sheet Ctrl + End Moves to the last used cell on the active worksheet* Ctrl + Up Arrow Moves to the first row in the current region Ctrl + Down Arrow Moves to the last row in the current region Ctrl + Left Arrow Moves to the first column in the current region Ctrl + Right Arrow Moves to the last column in the current region Ctrl + Page Up Moves to the previous worksheet in the workbook Ctrl + Page Down Moves to the next worksheet in the workbook Ctrl + Shift + Tab Moves to the previous open workbook or window Scroll Lock + Arrow Keys Moves the workbook or window one cell the corresponding direction Scroll Lock + End Moves to the last cell in the current window Scroll Lock + Home Moves to the first cell in the current window Scroll Lock + Page Down Moves you down one screen (current selection unchanged Scroll Lock + Page Up Moves you up one screen (current selection unchanged) Enter Moves from top to bottom within a selection Tab Moves from left to right within a selection Ctrl + . Moves clockwise to the next corner within a selection Shift + Tab Moves from right to left within a selection (opposite direction to Tab) Alt + Ctrl + Left Arrow Moves to the left between non adjacent cells in a selection Alt + Ctrl + Right Arrow Moves to the right between non adjacent cells in a selection = Starts a Formula Ctrl + ` Toggles between the value layer and the formula layer Ctrl + Insert Copies the current selection to the clipboard Ctrl + Shift + ( Unhides any hidden rows within the selection Ctrl + Shift + ) Unhides any hidden columns within the selection Ctrl + Shift + \ Select unequal cells Alt Toggles the activation of the old Menu Bar Alt + Shift + Left Arrow Displays the (Data > Group and Outline > UnGroup) dialog box Alt + Shift + Right Arrow Displays the (Data > Group and Outline > Group) dialog box Alt + Spacebar Activates the Control Box in the top left hand corner End Toggles between switching End Mode on or off Scroll Lock Toggles between switching Scroll Lock on or off Shift + Insert Pastes the entry from the clipboard DISABLE AUTORUN OPTION OF USB/CD/DVD

Read More

CCTV Camera Installation & Maintenance Services Faridabad

We provide a wide range of CCTV camera installation and maintenance services in Faridabad.Our CCTV camera solutions and other digitaal security systems are then designed keeping in mind your security requirements. And, after approvals from the client the security system is implemented.

We utilize security gears, for example, CCTV Polaroid, DVR, home entryway telephone and others from heading names in computerized imaging and information handling companuies. We give DVR and IP based security results.

Cctv Service Faridabad, as a group deals with CCTV establishment according to customer accommodation and likewise the trappings are led with minimum effect to business exercises.

Our team support is simply a telephone summon. We are constantly dedicated to brisk conveyance of items and administrations without the misfortune of value and after deals support..!!

Contact Info

E-mail: computerservicefbd@gmail.com

Phone no:- 8802784196 

Read More

Best Computer Services in Faridabad

Rajpoot Computer offer best computer services in Faridabad for Pcs and Macs, including workstation set-up, printer repairs, equipment and programming repairs, infection and spyware evacuation, information recuperation, information reinforcement, and parts replacement.we likewise offer a full line of top-brand and X-Engineers custom constructed desktops and laptops.

With infection and adware/malware evacuation we not just clean up those irritating pop-up ads, however we likewise clean up infections and Windows. We keep duplicates of against infection programming in our shop so we will dependably have the capacity to help if you get an infection. While we're busy we can perform other support to keep your Pcs running easily. Likewise, we can deal with any redesigns you may need, including memory or a higher limit hard drive for more amazing document stockpiling. We are Laptop Repair Specialists.

Read More

Computer Repair Faridabad

Computer Repair Faridabad full on location & off-site workstation repair and support administration scope to the Faridabad City.if you are private, business, instructive or a legislature establishment, we have numerous repair and upkeep contract choices to give full administration scope to your private and business areas.

PICK-UP REPAIR SERVICES FOR COMPUTERS, LAPTOPS AND PRINTERS

Computer Repair Faridabad an advantageous and reasonable pick-up repair administration, accessible to both business and private customers. In the event that you have an occupied timetable, we can go to your area, pick-up your PC, portable computer or printer and drop it off to you when completed. Our pick-up administration works from 10 am to 4 pm every day, and is midway placed to the Auburndale and Winter Haven regions.

Our pick-up administrations spread workstations, laptops & printers, including troubleshooting, repairs and updates at extremely aggressive rates. We normally give a judgment and gauge inside 3 business days of getting your work request, and facilitated administration for dire repairs.

COMPUTER SERVICE

PC, Computer Repair

· Laptop, Notebook Repair

· Printer, Plotter Repair

· Repair and Upgrades

· Warranty Repair Center

· On-Site Services

· Pick-Up Services

NETWORK SERVICE

 Microsoft and Novell Partners

· Network Installation & Upgrades

· Internet Security

· Custom PC and Server Sales and Configuration

· Projects and Contract Services

Read More

How to Speed up a Windows XP Computer

New hardware

1. To decrease a system's boot time and increase system performance, use the money you save by not buying defragmentation software (the built-in Windows defragmenter works just fine) and instead equip the computer with an Ultra-133 or Serial ATA hard drive with 8-MB cache buffer.
   

2. More memory

   If your PC has less than 512 MB of RAM, add more memory. This is a relatively inexpensive and easy upgrade that can dramatically improve system performance.]
   

3. Set Windows to NTSF

   Ensure that Windows XP is utilizing the NTFS file system. If you're not sure, here's how to check.
   
   1. Double-click on My Computer
   2. Right-click on the C: drive and select Properties
   3. Examine the File System type
   If the File System Type is set to FAT32, change it to NTSF.
   
   1. Back-up any important data
   2. Click Start and select Run
   3. Type CMD and press OK
   4. At the prompt, type: C: /FS:NTFS and press Enter
   This process may take a while. It's important that the computer remains uninterrupted and is virus-free. The file system used by the bootable drive will be either FAT32 or NTFS. I highly recommend NTFS for its superior security, reliability, and efficiency with larger disk drives.
   

4. Disable file indexing

   The indexing service extracts information from documents and other files on the hard drive and creates a "searchable keyword index." As you can imagine, this process can be quite taxing on any system.
   The idea is that the user can search for a word, phrase, or property inside a document, should they have hundreds or thousands of documents and not know the file name of the document they want. Windows XP's built-in search functionality can still perform these kinds of searches without the Indexing service. It just takes longer. The OS has to open each file at the time of the request to help find what you are looking for.
   
   1. Double-click on My Computer
   2. Right-click on the C: drive and select Properties
   3. Uncheck Allow Indexing Service to index this disk for fast file searching.
   4. Apply changes to "C: subfolders and files" and click OK
   If a warning or error message appears (such as "Access is denied"), click the Ignore All button.
   

5. Update firmware

   Update the PC's video and motherboard chipset drivers. Also, update and configure the BIOS. If the PC has a CD or DVD recorder, check the drive manufacturer's Web site for updated firmware. In some cases you'll be able to upgrade the recorder to a faster speed.
   

6. Empty the prefetch folder

   Empty the Windows Prefetch folder every three months or so. Windows XP can "prefetch" portions of data and applications that are used frequently. This makes processes appear to load faster when called upon by you. That's fine. But over time, the prefetch folder may become overloaded with references to files and applications no longer in use. When that happens, Windows XP is wasting time, and slowing system performance, by pre-loading them. Nothing critical is in this folder, and the entire contents are safe to delete.
   
   1. The prefetch folder can be accessed at C:Windows\prefetch
Update:
Empty the prefetch folder, is incorrect. Regualar cleaning of the pefetch folder will not improve performance, it will impair it. Prefetching of application data does not occur at boottime. Prefetch files contain data allowing Windows to more efficiently load them. Unused prefetch files have virtually no impact on performance. In any event the prefetch folder is self cleaning after 128 entries. This has been extensively tested.
For references, check Comcast and Edbott.
Thanks to Larry Miller for mentioning this.



7. Disk Cleanup

   Once a month, run a disk cleanup.
   
   1. Double-click on My Computer
   2. Right-click on the C: drive and select Properties
   3. Click the Disk Cleanup button (Right of the Capacity pie graph) and delete all temporary files
      

8. ATA/ATAPI Controllers device

   In your Device Manager, double-click on the IDE ATA/ATAPI Controllers device, and ensure that DMA is enabled for each drive you have connected to the Primary and Secondary controller. Do this by double-clicking on Primary IDE Channel. Then click the Advanced Settings tab. Ensure the Transfer Mode is set to "DMA if available" for both Device 0 and Device 1. Then repeat this process with the Secondary IDE Channel.
   

9. Upgrade the cabling

   As hard-drive technology improves, the cabling requirements to achieve these performance boosts have become more stringent. Be sure to use 80-wire Ultra-133 cables on all of your IDE devices with the connectors properly assigned to the matching Master/Slave/Motherboard sockets. A single device must be at the end of the cable; connecting a single drive to the middle connector on a ribbon cable will cause signaling problems. With Ultra DMA hard drives, these signaling problems will prevent the drive from performing at its maximum potential. Also, because these cables inherently support "cable select," the location of each drive on the cable is important. For these reasons, the cable is designed so drive positioning is explicitly clear.
   

10. Remove spyware from the computer

    Use free programs such as AdAware or SpyBot Search & Destroy. Once these programs are installed, be sure to check for and download any updates before starting your search. Anything either program finds can be safely removed. Any free software that requires spyware to run will no longer function once the spyware portion has been removed; if you really want the program even though it contains spyware, simply reinstall it.
    

11. Remove unnecessary startup programs

    1. Click Start and select Run
    2. Type MSCONFIG and press OK
    3. Click the StartUp tab and uncheck any items you don't want to start when Windows starts
    Unsure what some items are? Visit the WinTasks Process Library. It contains known system processes, applications, as well as spyware references and explanations. Or quickly identify them by searching for the filenames using Google or another Web search engine.
    

12. Uninstall software

    Remove any unnecessary or unused programs from the Add/Remove Programs section of the Control Panel.
    

13. Trim down the visual performance

    Turn off any and all unnecessary animations, and disable active desktop. In fact, for optimal performance, turn off all animations. Windows XP offers many different settings in this area. Here's how to change it.
    
    1. Click on the System icon in the Control Panel
    2. Click on the Advanced tab and select the Settings button located under Performance
    Feel free to play around with the options offered here, as nothing you can change will alter the reliability of the computer; only its responsiveness.
    

14. Tweak your register

    If you are an advanced user who is comfortable editing your registry, try some of the performance registry tweaks offered at Tweak XP.
    

15. Update Windows

    Visit Microsoft's Windows update site regularly and download all updates labeled Critical. Download any optional updates at your discretion.
    

16. Update Anti-virus

    Update your anti-virus software on a weekly, even daily, basis. Make sure you have only one anti-virus software package installed. Mixing anti-virus software is a sure way to spell disaster for performance and reliability.
    

17. Minimize your fonts

    Make sure you have fewer than 500 type fonts installed on their computer. The more fonts you have, the slower the system will become. While Windows XP handles fonts much more efficiently than did the previous versions of Windows, too many fonts (that is, anything over 500) will noticeably tax the system.
    
    1. Fonts are located in C:Windows\fonts
       

18. Do not partition the hard drive

    Windows XP's NTFS file system runs more efficiently on one large partition. The data is no safer on a separate partition and a reformat is never necessary to reinstall an operating system. The same excuses people offer for using partitions apply to using a folder instead.
    For example, instead of putting all your data on the D: drive, put it in a folder called "D drive." You'll achieve the same organizational benefits that a separate partition offers, but without the degradation in system performance. Also, your free space won't be limited by the size of the partition; instead, it will be limited by the size of the entire hard drive. This means you won't need to resize any partitions, ever. That task can be time-consuming and also can result in lost data.
    

19. Check the system's RAM

    Check the system's RAM to ensure it is operating properly. I recommend using a free program called MemTest86. The download will make a bootable CD or diskette (your choice), which will run 10 extensive tests on the PC's memory automatically after you boot to the disk you created. Allow all tests to run until at least three passes of the 10 tests are completed. If the program encounters any errors, turn off and unplug the computer, remove a stick of memory (assuming you have more than one), and run the test again. Remember, bad memory cannot be repaired, but only replaced.
    

20. Disable unnecessary services

    Windows XP loads a lot of services that you most likely do not need. To determine which services you can disable, visit the Black Viper site for Windows XP configurations.
    

21. "Launch folder Windows in a separate process"

    If you're sick of a single Windows Explorer window crashing and then taking the rest of your OS down with it, then follow this tip.
    
    1. Open My Computer
    2. Click on Tools, then Folder Options and click on the View tab
    3. Scroll down to "Launch folder Windows in a separate process" and enable this option.
    You'll have to reboot your machine for this option to take effect.
    

22. Clean your hardware

    At least once a year, open the computer's cases and blow out all the dust and debris. While you're in there, check that all the fans are turning properly. Also inspect the motherboard capacitors for bulging or leaks.

Following any of these suggestions should result in noticeable improvements to the performance and reliability of your computer. If you still want to defrag a disk, remember that the main benefit will be to make your data more retrievable in the event of a crashed drive.

Best Computer Service in Faridaba

Read More

Best Tips For The Safety of Computer

                            BEST TIPS FOR THE SAFETY OF COMPUTER.

Here some tips for the safety of computer. A user can get better result and performance of computer speed by acting upon these tips. 

• Don't  turn off your computer during working position of windows.
• Alway turn off you computer manually by clicking on start menu and select shut down. If you are not using a mouse then simply press windows key and then press "U key" 2 times. 
• Before connecting new hardware i.e cd rom, ram, hard drive etc, Turn off computer completely.
• Always close Cd Rom by pressing its button, don't apply force on the gate of CD Rom.
• Don't keep your computer near dinning table and also don't keep any liquid or water near your CPU. 
• Keep you system in airy atmosphere. 
• You can use AC in your compute room.
• Don't use water room cooler in front of CPU.
• Always turn off computer manually and disconnect your computer from the AC current.

Read More

DISABLE AUTORUN OPTION OF USB/CD/DVD

          Disable autorun option of usb or cd dvd drives.

 Many people know that when ever they plug in their USB drive into the USB port, automatically an auto play option gets executed. Similarly when they insert CD or DVD in drive, it also shows same option of auto run. Sometime it becomes very dangerous for your computer because if your USB drive contains any virus then it gets executed along with auto run files. As a result your computer or operating system becomes slow. There is a trick to solve this problem. Just follow these steps.

    Click start menu and click on RUN.
    Type “GPEDIT.MSC” and press enter.
    Click on Computer Configuration, then click on “administrative templates”
    Now click on “system” and you will see a list on right side of the window.
    Search Line No. 16. (Turn Off Auto play)
    Double click on it and on the resultant window click on “enable”
    Select “All Drive” to disable all drives.
    Click on apply. Done.

Read More