Thursday, 16 May 2013

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

Friday, 8 February 2013

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.

Sunday, 16 December 2012

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/
 

Monday, 10 December 2012

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.

Thursday, 1 November 2012

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

Sunday, 28 October 2012

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

Saturday, 27 October 2012

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.

Friday, 26 October 2012

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.