Copy Values From Multiple Cells And Paste In Single Cell

First Put the Formula Given Below and select column

=A1 & "," & A2 & "," & A3

Then select that column & copy and paste special as Values

You can select multiple cell just follow formula

Change Registered Name and Registered Organization Name in Windows XP

Img 1

• Click Start, and then click Run.

• In the Open box, type regedit, and then click OK.

• Find the following registry key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion (as shown in Img 1)

• To change the company name, do the following:

• In the right pane, double-click Registered Organization. Under Value data, type the name that you want, and then click OK.

• To change the name of the registered owner, do the following:

•  In the right pane, double-click RegisteredOwner. Under Value data, type the name that you want, and then click OK. (as shown in Img 1)

• After that close the Register Editor.

Stdole2.tlb Excel 2007 Error

Manually Uninstall and Re-install Excel (please make sure you have the CD for Microsoft Office)
Step 1 – Make Excel unavailable
Make Excel Unavailable from Maintenance Mode
1. Click on Start > Control Panel.
2. Click on Classic view on the left Pane.
3. Double click on Programs and Features  
4. Click to select Microsoft Office 2007 or Microsoft Office Excel 2007 and click Change
5. Select "Add or Remove Features" and click Next.
6. Click to make excel unavailable

Backup the Registry
Note: Modifying REGISTRY settings incorrectly can cause serious problems that may prevent your computer from booting properly. Microsoft cannot guarantee that any problems resulting from the configuring of REGISTRY settings can be solved. Modifications of these settings are at your own risk.
1. Click on the Start > Run(Windows+R)
2. Type "regedit" (without quotes) in the run window, then press Enter.
3. within the Registry Editor Windows Click File and then Click Export.
4. Name your Backup something like Registry Backup, change Export Range to All, click Save.
5. Give your computer a moment to complete the task.

Delete "Excel" key from the following location in registry:
(If some keys can't be deleted or found, please skip them, this will not influence the result of the troubleshooting)
Click on the + sign to expand the registry keys, the keys following the backslash (\) are sub keys, right click on the last sub key and click Delete.
HKEY_CURRENT_USER\Software\Microsoft\Office\8.0\Excel
HKEY_CURRENT_USER\Software\Microsoft\Office\9.0\Excel
HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Excel
HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel
HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel
HKEY_CURRENT_USER\Software\Microsoft\Office\Excel
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\8.0\Excel
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\9.0\Excel
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\10.0\Excel
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\11.0\Excel
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\12.0\Excel
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\Excel
- Close the Registry Editor

Make Excel Available from Maintenance Mode
1. Click on Start > Control Panel.
2. Click on Classic view on the left Pane.
3. Double click on Programs and Features
4. Click to select Microsoft Office 2007 or Microsoft Office Excel 2007 and click Change
5. Select "Add or Remove Features" and click Next.
6. Click to check Excel and update the installation.
7. RESTART the computer.
Then try to open Excel and check.

I solve my problem by following above instructions

Ref:-http://answers.microsoft.com/en-us/office/forum/office_2007-office_install/stdole32tlb-file-missing/ba3e940d-d628-4334-ac89-5e8ac9878093 

And also check at
http://www.microsoftsupportchat.com/blog/post/Office-2007-Excel-stdole-32-tlb-error/
 

Windows 7 Installation Error 0x80070017

Windows 7 Installation Error 0x80070017

This happens due to damage or problem with media (DVD or CD, DVD Rom,DVD R/W). If you have face like this problem then check you media like CD or DVD.if this has scratch then rewrite a new DVD or CD.other wise if you got problem again then replace DVD ROM,DVD R/W OR CD ROM.
You will be solve this problem because i have solve this by changing my DVD R/W.

expand a hard drive partition without formatting

We can increase or expand partition  of hard drive using tool many companies provided home addition free of cost .EaseUS has provided home edition is free this is very useful utility you can trust because i have also test it.

Free EaseUS® Partition Master 9.1.1 Home Edition Free Full  For Windows (Windows 2000 Professional, XP, Vista, Windows 7 SP1, Windows 8. (Support 32 and 64 bit) ONLY FOR HOME USER
(Ref.http://www.partition-tool.com/personal.htm)
Download
Download2

EaseUS® Partition Master 9.1.1 Professional Edition Demo Version For Windows (Windows 2000 Professional, XP, Vista, Windows 7 SP1, Windows 8. (Support 32 and 64 bit) DEMO VERSION

Downlaod 1
Downlaod 2
Download 3


EaseUS® Partition Master 9.1.1 Server Edition Demo Version For Server (Windows Server 2000, 2003, Home Server, 2008 R2 SP1, 2012 and Windows 2000, XP, Vista, Windows 7 SP1, Windows 8. (Support 32 and 64 bit) DEMO VERSION
Download 1
Download 2
Download 3

Please before use you have to read the specification given above reference link

Download Internet Explorer Free

Download internet explorer  Free for windows

Download Internet Explorer 7 Free (Ref. http://www.microsoft.com/en-us/download/details.aspx?id=2)

Internet Explorer 7 for Windows xp 32bit
Download

Download Internet Explorer 8 Free (Ref.http://www.microsoft.com/en-us/download/details.aspx?id=43)

Windows Internet Explorer 8 for Windows XP 32 bit 
Download1
Download2

Download Internet Explorer 9 Free(Ref. http://www.microsoft.com/en-us/download/details.aspx?id=13950)

Windows Internet Explorer 8 for Windows 7 x86 or 32 bit
Download 

You can get detail about specification or requirement of operating systems (windows) by visit at given reference Link

Full Antivirus Free Download

Today There is all over the world everybody use internet.and they want their data secure and there pc free from virus.So there is many companies which provide Full Antivirus Free .but there will be limited feature in free edition.you can download form link mention below.

• Avira Free Full Antivirus (Ref: http://www.avira.com/en/avira-free-antivirus)

Download

• Avg Free Full AntiVirus (Ref: http://free.avg.com/in-en/free-antivirus-download)

Download

• Kaspersky Anti-Virus 2013 (Trial For 30 Days)

Download

• Avira Antivirus Premium 2013 (Trial For 30 Days)

Download

• Quick Heal AntiVirus Pro 2013 (Trial For 30 Days)

Download 1
Download 2

Windows Problems And Solutions

Problem 1.)PC did not show display but it is running or giving Beep Sound.
Solution. Turn off the PC and re-fix the ram into Motherboard

Problem 2.) PC getting restarted automatically
Solution. There are many reason for this problem

• First there will be problem in SMPS
• second there will be Problem in RAM
• Third There will be Problem in HDD (BAD SECTOR)
• Fourth There Will be Problem in Motherboard (Capacitor Problem) 

Problem 3.) How to Create a Schedule Task in Windows
 Solution.

• Go to Start-Programs-Accessories-System Tools-Schedule Task
• Double click on Add Schedule Task
• Click next and Select Task or Application in list
• Select Option in Perform Task and Click Next
• Enter User Name and Password
• For Advance setting check the box open advance properties for this task
• In Advance Setting You can set Time and other setting according to your need

Enable Disable Administrator Account windows 7

1. Open the Local Users and Groups manager by right click on my computer and select manage
2. In the left pane, click on the Users folder.
3. In the middle pane, right click on Administrator and click on Properties.
4. To Enable Administrator Account

•  Uncheck the Account is disabled box.

5. To Disable Administrator Account 

• Check the Account is disabled box. 

6. Click on OK.
7. Close the Local Users and Groups window.
8. Log off, and you will now see Administrator account log on icon added (if Uncheck the Account is disabled box enabled) or removed (if Check the Account is disabled box disabled) from the log on screen.

Internet Explorer Or Any Browser Opens Too Many Windows

Some time Internet Explorer or any browser like Firefox,chrome opens too many windows.this problem occur due to virus you can fix this problem by visit link which is mention below

For check information
 http://www.symantec.com/security_response/writeup.jsp?docid=2010-090608-3309-99

For download Tool By symantec
FixTDSS.exe click here

I have fix my problem by using this software.you have to download a .exe file from that link and scan your PC after that your PC got restarted and your problem will solve.

System Progressive Protection Virus Removal Guide

System Progressive Protection Virus Removal Instructions manually.

• You can remove this System Progressive Protection Virus manually by following simple step.

• First restart the computer 

• run windows in safe mode by pressing F8 key on keyboard many times

• click on start and run

• type msconfig and click on startup 

• lookup System Progressive Protection Virus registry or unknown registry or unknown software path

• then go to that location it may be local setting\application data 

• delete that folder then again click on start and run

• type regedit and press ok

• goto edit menu and click on find

• type  System Progressive Protection and click on find next you have find again and again till the message does not appear nothing found etc because there will be many entry of this virus in registry

• delete all registry which is related to System Progressive Protection but before do this take your data and registry backup

• delete all Temporary file in temp folder and internet temporary file and restart the PC

Problem in Windows "Registry Disabled By Administrator"

Sometime A problem in windows occur when we try to open registry using regedit command. it show a pop up window that "Registry Disabled By Administrator".this problem can occur due to virus attack.the solution of this problem mention below.How to enable registry disabled by administrator.

• Click Start, click Run, 

• Type gpedit.msc in the Open box, and then click OK.

• Expand User Configuration, Administrative Templates, and System, (Ref Img1)

• Then click Prevent access to registry editing tools.in the right side (Ref.Img2)

• Click to select disabled and Click apply and ok. (Ref.Img2)

Increase Your Internet Speed In Windows XP

In windows you can increase your internet speed follow below step but it will make a little bit changes in your speed.

• Click START, then click RUN.

• Type "gpedit.msc" without the quotes, then click OK.

• Browse to the highlighted area shown in img 1 and img 2 -- click Computer Configuration/ Administrative Templates/ Network/ QoS Packet Scheduler 

• in the left-hand pane (shown in img1) then double-click "Limit reservable bandwith" in the right-hand pane. 

• The dialog box shown below will pop up.(Ref Img2)

• Click the dot (radio button Follow the step 1-4) for Enabled as shown below, 

• in Bandwidth Limit, type or click up or down until a number between 0 and 10 is shown.

• Click Apply,(Ref.Img2 follow the step 1-4) and ok
•  after that Click START, then click RUN
• type gpupdate /force press ok or restart the pc

Task Manager Disabled By Administrator Or Enable/Disable Task Manager in windows

Problem. Sometime a problem in windows occur when we press Ctrl+Alt+Del for open task manger it show popup that Task Manager Disabled By Adminstrator.
Soluiton. how to enable/disable  task manager
Method 1.

• First press windows+run
• then type gpedit.msc and press ok
• then go to user configuration
• then go to administrative templates
• then got to system and click on Ctrl+Alt+Del option
• right side of the windows double click on remove task manager
• set to disable and click on apply and ok (by doing this task manager will work)
• set to enable and click on apply and ok (by doing this task manager will not work)
• press windows+run and type gpupdate /force and press ok or restart PC

 Method 2.
Warning: Modifying your registry can cause serious problems that may require you to reinstall your operating system.
                Always backup your registry before doing this registry edit and backup your pc data 
Verity correct registry settings::

•  Go to "Start" -> "Run" -> Write "regedit" and press on "Enter" button.

•  Navigate to the following registry keys and verity that following settings set to default:

• Windows Registry Editor Version 5.00
• [HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\System]
• "DisableTaskMgr"=dword:00000000
• [HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Group Policy Objects\LocalUser\Software\Microsoft\Windows\CurrentVersion\Policies\System]
• "DisableTaskMgr"=dword:00000000
• [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\policies\system\]
• "DisableTaskMgr"=dword:00000000
• [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Winlogon]
• "DisableCAD"=dword:00000000
•  Reboot the computer.

Problems in Windows networking PC Ethernet card connected to net work but not work

Problem.1) Some time a problem occur in networking PC Ethernet card cable show connect but it did not work in windows
Solution. Many there some pair of network Cable not work or your ethernet card or lan card not work on auto-negotiations speed you have to follow this step

• Double Click on ethernet card
• then clich on properties
• then click on configure
• then click on advanced
• then click on speed/duplex settings
• then set value by scrolling down to auto-negotiations 10 HD(half duplex) note this will set your ethernet speed to 10 MB/per second

In Windows 7 getting problem of Moniter Frequency

Solution For getting problem of moniter frequeny problem in windows 7
Caution of problem is due to VGA driver incompatibility with windows or virus attack

• First run windows in safe mode
• Then open Device Manger
• Uninstall Display Adapter Driver 
• Install Display Adapter Driver and update driver to Standard VGA Driver which has in windows by default
• restart Windows

Solution for "Operation could not be completed. Either the printer name was typed incorrectly, or the specified printer has lost its connection to the server"in windwos

• in windows First, check if the "Print Spooler / Spooler" service is up and running on the remote computer.

• If this is already the case, and if the computer runs Windows 2003 Server or higher OS, check in the Group Ploicy Editor if the print spooler accepts remote client connections. Follow these steps:

• Start  command prompt, Execute, "gpedit.msc"

• Browse to "Computer Configuration" / "Administrative Templates" / "Printers".

• In the right pane, double-clic on the policy"Allow Print Spooler to accept client connections".

• Enable this setting, then Apply.

• Then restart on the remote computer the "Print Spooler / Spooler" service in order to take changes into account.or restart computer

#1045 - access denied for user 'root'@'localhost' (using password no)" Solution for Joomla

Dear Friends,
If in windows using joomla you got problem of error #1045 - access denied for user 'root'@'localhost' (using password no) on running Php My admin in XAMPP.Then follow below step you will be able to solve this because i have also do this and my porblem get solved.

1.First Stop XAMPP

2. Goto to directory in which XAMPP has installed for example c:\xampp.

3. Then goto c:\xampp\mysql.


4. Run resetroot.bat .

5.Restart the PC and Enjoy.

Command For Find Port Used By Application On Computer in windows

Dear Friends,
There is many application running on windows on local or  network.These application use some port of windows.Here we find the port of application used by Following these steps.

Image 1

1. Open Command Prompt.
2. Type netstat -aon.(See Image 1)
3. Press Enter.

4. This show you port which is use a PID Number.
5. Then Note down PID Number using By Port Which You Want.
6. Now open TASK MANAGER by press ALT+CTRL+DELETE.

Image 2

7. Click on Process Tab (See Image 2).
8. Click On View and Select Columns. (See Image 2).
9. Then Click on PID Tick in the box.then ok.

10. after that see Task Manager.It show PID infront of application or image name.
11. you can End Process of that application which port used by.


Like this you will be able to find port used by application.

Windows 7 Network Password Problem And Solution

Image 1

Windows7 use Security Advance Level, So that it is ask for network password after enter a network computer user name and password.For this solution you have a simple few step to close network password option.
1.First open Control Panel

2.Find Administrative Tool and open it

3.Then open Local Security Policy which is show in image1

Image 2

4.Go to Security Setting

5.open Local Policy (See imgae 2)

6.Click On Security Option (see image 2)

7.Find Network Security: LAN Manager        authentication Level which show not define,Double    click on it.(See Image2)

Image 3

8.Click On drop Down List

9.Select Sent NTLM response Only (See Image3)


10.Click Apply and Ok (See Image 3)

Image 4

11.Open Command Prompt

12.Type Command gpupdate /force press Enter

Restat Computer And Enjoy!!!!!!!!!!