Auto sum shortcut key in Microsoft Excel

Auto sum shortcut key in Microsoft Excel

             Microsoft Excel has been very important and essesness tool for routine office work. For making sum sub division or multiplumultip we need to use excel formulas..

    Here the short cut to create a Microsoft Excel formula to get the sum of all cells ias as bellow 

Select the cells you want to know the value of and pressing Alt and =(equals) together

Continue Reading

Recover Windows XP Administrator Password

Have you forgotten Windows xp Administrator login password or do you want to hack or change the Administrator password of the windows system at your School, College or office, then this Trick is just for you.

Follow the steps below

1.  Restart your computer

2.  Press F8 key continuously until you get a black screen where you have many options to start you operating system

3.  From the options  “Select the Safe mode with Command Prompt”

4.  When your computer starts in DOS mode, type the following commands

net user

This command displays the list of users on this OS in ROWS

5. Now type the following commands to reset the windows Administrator password

net user username password

Note: Enter your username above and space then password.

Then it asks the new password without the last password.
Now type your new password ******
Again retype your new password********
Note: When you type the password, it will not be displayed

Continue Reading

TCP/IP is not enabled for your system error Solution

Today My computer was not at all functioning. SMPS fan is working. But no power lights are coming. The system is under warranty. So i Called the HCL engineer to come and check my system.

So I decided to use my laptop. when i tried to print a document though network, Print error was coming. The system was not accessible. When tried to repair the network connection, the error "TCP/IP is not enabled for your system".
Finally i found a solution for this problem.  Downloaded winsockxp fix and fixed.

Now the problem is solved.

Continue Reading

RESTART WINDOWS WITHOUT RESTARTING YOUR COMPUTER

Mostly Computer takes lots of time for restart. Sometimes we need to restart our computer, that time it becomes necessity like after installing some software but when we have limited time and we are busy then it is very annoying to wait for it to restart.

So here is solution for this problem. In that case you need not to restart your computer but you can restart your windows without restarting computer. It will take very less time.

To restart windows without restarting computer you just need to hold Shift key down while clicking on shutdown or restart button.

Your computer would restart without restarting the Computer.

Restart Windows without Restarting PC, this term is known as Hot Booting.

Continue Reading

Best KeyBoard Shortcuts in windows

 

Getting used to using your keyboard exclusively and leaving your mouse behind will make you much more efficient at performing any task on any Windows system. I use the following keyboard shortcuts every day:

Windows key + R = Run menu

This is usually followed by:
cmd = Command Prompt
iexplore + "web address" = Internet Explorer
compmgmt.msc = Computer Management
dhcpmgmt.msc = DHCP Management
dnsmgmt.msc = DNS Management
services.msc = Services
eventvwr = Event Viewer
dsa.msc = Active Directory Users and Computers
dssite.msc = Active Directory Sites and Services
Windows key + E = Explorer


ALT + Tab = Switch between windows

ALT, Space, X = Maximize window

CTRL + Shift + Esc = Task Manager

Windows key + Break = System properties

Windows key + F = Search

Windows key + D = Hide/Display all windows

CTRL + C = copy

CTRL + X = cut

CTRL + V = paste

Also don't forget about the "Right-click" key next to the right Windows key on your keyboard. Using the arrows and that key can get just about anything done once you've opened up any program.


Keyboard Shortcuts

[Alt] and [Esc] Switch between running applications

[Alt] and letter Select menu item by underlined letter

[Ctrl] and [Esc] Open Program Menu

[Ctrl] and [F4] Close active document or group windows (does not work with some applications)

[Alt] and [F4] Quit active application or close current window

[Alt] and [-] Open Control menu for active document

Ctrl] Lft., Rt. arrow Move cursor forward or back one word

Ctrl] Up, Down arrow Move cursor forward or back one paragraph

[F1] Open Help for active application

Windows+M Minimize all open windows

Shift+Windows+M Undo minimize all open windows

Windows+F1 Open Windows Help

Windows+Tab Cycle through the Taskbar buttons

Windows+Break Open the System Properties dialog box



acessability shortcuts

Right SHIFT for eight seconds........ Switch FilterKeys on and off.

Left ALT +left SHIFT +PRINT SCREEN....... Switch High Contrast on and off.

Left ALT +left SHIFT +NUM LOCK....... Switch MouseKeys on and off.

SHIFT....... five times Switch StickyKeys on and off.

NUM LOCK...... for five seconds Switch ToggleKeys on and off.

explorer shortcuts

END....... Display the bottom of the active window.

HOME....... Display the top of the active window.

NUM LOCK+ASTERISK....... on numeric keypad (*) Display all subfolders under the selected folder.

NUM LOCK+PLUS SIGN....... on numeric keypad (+) Display the contents of the selected folder.

NUM LOCK+MINUS SIGN....... on numeric keypad (-) Collapse the selected folder.

LEFT ARROW...... Collapse current selection if it's expanded, or select parent folder.

RIGHT ARROW....... Display current selection if it's collapsed, or select first subfolder.




Type the following commands in your Run Box (Windows Key + R) or Start Run

devmgmt.msc = Device Manager
msinfo32 = System Information
cleanmgr = Disk Cleanup
ntbackup = Backup or Restore Wizard (Windows Backup Utility)
mmc = Microsoft Management Console
excel = Microsoft Excel (If Installed)
msaccess = Microsoft Access (If Installed)
powerpnt = Microsoft PowerPoint (If Installed)
winword = Microsoft Word (If Installed)
frontpg = Microsoft FrontPage (If Installed)
notepad = Notepad
wordpad = WordPad
calc = Calculator
msmsgs = Windows Messenger
mspaint = Microsoft Paint
wmplayer = Windows Media Player
rstrui = System Restore
netscp6 = Netscape 6.x
netscp = Netscape 7.x
netscape = Netscape 4.x
waol = America Online
control = Opens the Control Panel
control printers = Opens the Printers Dialog


internetbrowser

type in u're adress "google", then press [Right CTRL] and [Enter]
add www. and .com to word and go to it


For Windows XP:

Copy. CTRL+C
Cut. CTRL+X
Paste. CTRL+V
Undo. CTRL+Z
Delete. DELETE
Delete selected item permanently without placing the item in the Recycle Bin. SHIFT+DELETE
Copy selected item. CTRL while dragging an item
Create shortcut to selected item. CTRL+SHIFT while dragging an item
Rename selected item. F2
Move the insertion point to the beginning of the next word. CTRL+RIGHT ARROW
Move the insertion point to the beginning of the previous word. CTRL+LEFT ARROW
Move the insertion point to the beginning of the next paragraph. CTRL+DOWN ARROW
Move the insertion point to the beginning of the previous paragraph. CTRL+UP ARROW
Highlight a block of text. CTRL+SHIFT with any of the arrow keys
Select more than one item in a window or on the desktop, or select text within a document. SHIFT with any of the arrow keys
Select all. CTRL+A
Search for a file or folder. F3
View properties for the selected item. ALT+ENTER
Close the active item, or quit the active program. ALT+F4
Opens the shortcut menu for the active window. ALT+SPACEBAR
Close the active document in programs that allow you to have multiple documents open simultaneously. CTRL+F4
Switch between open items. ALT+TAB
Cycle through items in the order they were opened. ALT+ESC
Cycle through screen elements in a window or on the desktop. F6
Display the Address bar list in My Computer or Windows Explorer. F4
Display the shortcut menu for the selected item. SHIFT+F10
Display the System menu for the active window. ALT+SPACEBAR
Display the Start menu. CTRL+ESC
Display the corresponding menu. ALT+Underlined letter in a menu name
Carry out the corresponding command. Underlined letter in a command name on an open menu
Activate the menu bar in the active program. F10
Open the next menu to the right, or open a submenu. RIGHT ARROW
Open the next menu to the left, or close a submenu. LEFT ARROW
Refresh the active window. F5
View the folder one level up in My Computer or Windows Explorer. BACKSPACE
Cancel the current task. ESC
SHIFT when you insert a CD into the CD-ROM drive Prevent the CD from automatically playing.

Use these keyboard shortcuts for dialog boxes:

To Press
Move forward through tabs. CTRL+TAB
Move backward through tabs. CTRL+SHIFT+TAB
Move forward through options. TAB
Move backward through options. SHIFT+TAB
Carry out the corresponding command or select the corresponding option. ALT+Underlined letter
Carry out the command for the active option or button. ENTER
Select or clear the check box if the active option is a check box. SPACEBAR
Select a button if the active option is a group of option buttons. Arrow keys
Display Help. F1
Display the items in the active list. F4
Open a folder one level up if a folder is selected in the Save As or Open dialog box. BACKSPACE

If you have a Microsoft Natural Keyboard, or any other compatible keyboard that includes the Windows logo key and the Application key , you can use these keyboard shortcuts:


Display or hide the Start menu. WIN Key
Display the System Properties dialog box. WIN Key+BREAK
Show the desktop. WIN Key+D
Minimize all windows. WIN Key+M
Restores minimized windows. WIN Key+Shift+M
Open My Computer. WIN Key+E
Search for a file or folder. WIN Key+F
Search for computers. CTRL+WIN Key+F
Display Windows Help. WIN Key+F1
Lock your computer if you are connected to a network domain, or switch users if you are not connected to a network domain. WIN Key+ L
Open the Run dialog box. WIN Key+R
Open Utility Manager. WIN Key+U

accessibility keyboard shortcuts:

Switch FilterKeys on and off. Right SHIFT for eight seconds
Switch High Contrast on and off. Left ALT+left SHIFT+PRINT SCREEN
Switch MouseKeys on and off. Left ALT +left SHIFT +NUM LOCK
Switch StickyKeys on and off. SHIFT five times
Switch ToggleKeys on and off. NUM LOCK for five seconds
Open Utility Manager. WIN Key+U

shortcuts you can use with Windows Explorer:


Display the bottom of the active window. END
Display the top of the active window. HOME
Display all subfolders under the selected folder. NUM LOCK+ASTERISK on numeric keypad (*)
Display the contents of the selected folder. NUM LOCK+PLUS SIGN on numeric keypad (+)
Collapse the selected folder. NUM LOCK+MINUS SIGN on numeric keypad (-)
Collapse current selection if it's expanded, or select parent folder. LEFT ARROW
Display current selection if it's collapsed, or select first subfolder. RIGHT ARROW

Continue Reading

Install Windows Server 2003

How can I install Windows Server 2003 on my server?
As a Microsoft Windows Server support professional, one of your tasks may be to install the operating system.

Update: Get step-by-step instructions on how to install Windows Server 2008 here.

Step #1: Plan your installation

When you run the Windows Server 2003 Setup program, you must provide information about how to install and configure the operating system. Thorough planning can make your installation of Windows Server 2003 more efficient by helping you to avoid potential problems during installation. An understanding of the configuration options will also help to ensure that you have properly configured your system.
I won't go into that part right now (I might later this month, no promises...) but here are some of the most important things you should take into consideration when planning for your Windows Server 2003 installation:

• Check System Requirements
• Check Hardware and Software Compatibility
• Determine Disk Partitioning Options
• Choose the Appropriate File System: FAT, FAT32, NTFS
• Decide on a Workgroup or Domain Installation
• Complete a Pre-Installation Checklist

After you made sure you can go on, start the installation process.

Step #2: Beginning the installation process

You can install Windows Server 2003 in several methods - all are valid and good, it all depends upon your needs and your limitations.
For example, you can install directly from a CD by booting your computer with the CD, or you can also copy the I386 folder from a CD and run the setup process by going into the I386 folder and using the WINNT or WINNT32 command (depending upon your existing operating system).
It doesn't matter how you run the setup process, but the moment it runs - all setup methods look alike.

Step #3: The text-based portion of the Setup program

The setup process begins loading a blue-looking text screen (not GUI). In that phase you will be asked to accept the EULA and choose a partition on which to install 2003, and if that partition is new, you'll be asked to format it by using either FAT, FAT32 or NTFS.

1. Start the computer from the CD.

1. You can press F6 if you need to install additional SCSI adapters or other mass-storage devices. If you do you will be asked to supply a floppy disk with the drivers and you CANNOT browse it (or a CD for that matter). Make sure you have one handy.

1. If you want, you can press F2 to run the ASR sequence. For that you need a good backup created by the Windows Server 2003 backup program, and the ASR floppy disk. If you plan to install a new copy of 2003 - don't do anything.

1. Setup will load all the needed files and drivers.

1. Select To Setup Windows Server 2003 Now. If you want, and if you have a previous installation of the OS, you can try to fix it by pressing R. If not, just press ENTER.

1. Read and accept the licensing agreement and press F8 if you accept it.

1. Select or create the partition on which you will install Windows Server 2003. Depending upon your existing disk configuration choose one of the following:

• If the hard disk is unpartitioned, you can create and size the partition on which you will install Windows Server 2003.

• If the hard disk is already partitioned, but has enough unpartitioned disk space, you can create an additional partition in the unpartitioned space.
• If the hard disk already has a partition that is large enough, you can install Windows Server 2003 on that partition. If the partition has an existing operating system, you will overwrite that operating system if you accept the default installation path. However, files other than the operating system files, such as program files and data files, will not be overwritten.
• If the hard disk has an existing partition, you can delete it to create more unpartitioned space for the new partition. Deleting an existing partition erases all data on that partition.

If you select a new partition during Setup, create and size only the partition on which you will install Windows Server 2003. After installation, use Disk Management to partition the remaining space on the hard disk.

1. Select a file system for the installation partition. After you create the partition on which you will install Windows Server 2003, you can use Setup to select the file system with which to format the partition. Windows Server 2003 supports the NTFS file system in addition to the file allocation table (FAT) and FAT32 file systems. Windows Server 2003, Windows XP Professional, Windows 2000, and Windows NT are the only Microsoft operating systems that you can use to gain access to data on a local hard disk that is formatted with NTFS. If you plan to gain access to files that are on a local Windows Server 2003 partition with the Microsoft Windows 95 or Windows 98 operating systems, you should format the partition with a FAT or FAT32 file system. We will use NTFS.

1. Setup will then begin copying necessary files from the installation point (CD, local I386 or network share).
2. Note: If you began the installation process from an MS-DOS floppy, make sure you have and run SMARTDRV from the floppy, otherwise the copying process will probably last more than an hour, perhaps even more. With SMARTDRV (or if setup was run by booting from CD) the copying will probably last a few minutes, no more than 5 max.

1. The computer will restart in graphical mode, and the installation will continue.

Step #4: The GUI-based portion of the Setup program

The setup process reboots and loads a GUI mode phase.

It will then begin to load device drivers based upon what it finds on your computer. You don't need to do anything at this stage.

1. Click Customize to change regional settings, if necessary.

• Current System Locale - Affects how programs display dates, times, currency, and numbers. Choose the locale that matches your location, for example, French (Canada).
• Current Keyboard Layout - Accommodates the special characters and symbols used in different languages. Your keyboard layout determines which characters appear when you press keys on the keyboard.

If you don't need to make any changes just press Next.

If you do need to make changes press Customize and add your System Locale etc.
Note for Hebrew users: Unlike W2K, it is SAFE and it is OK for you to install Hebrew language support at this phase.

To install Hebrew support:

After pressing Customize go to the Languages tab and select the "Install files for complex script and right-to-left languages".
A warning message will appear. Press Ok.

Warning: You must now press Apply!!!
Setup will copy the necessary files from the installation point.
You can now go to the Regional Options tab and select Israel in the Location drop-down list, and Hebrew in the Standards and Formats drop-down list. Click Ok.

Note: Read the Install Hebrew on Windows Server 2003 page for more info.

1. Type your name and organization.

1. Type the product key.

1. Enter the appropriate license type and number of purchased licenses.

1. Type the computer name and a password for the local Administrator account. The local Administrator account resides in the SAM of the computer, not in Active Directory. If you will be installing in a domain, you need either a pre-assigned computer name for which a domain account has been created, or the right to create a computer account within the domain.

1. If you enter a password that is blank or does not match the required complexity settings you will get a warning message.

1. Select the date, time, and time zone settings.

1. Setup will now install the networking components.

After a few seconds you will receive the Networking Settings window. BTW, if you have a NIC that is not in the HCL and Windows Server 2003 cannot detect it, or if you don't have a NIC at all, setup will skip this step and you will immediately go to the final phase of the setup process.
Press Next to accept the Typical settings option if you have one of the following situations:

• You have a functional DHCP on your network.
• You have a computer running Internet Connection Sharing (ICS).
• You're in a workgroup environment and do not plan to have any other servers or Active Directory at all, and all other workgroup members are configured in the same manner.

Otherwise select Custom Settings and press Next to customize your network settings.

1. Highlight the TCP/IP selection and press Properties.

In the General tab enter the required information. You must specify the IP address of the computer, and if you don't know what the Subnet Mask entry should be - you can simply place your mouse pointer over the empty area in the Subnet Mask box and click it. The OS will automatically select the value it thinks is good for the IP address you provided.

If you don't know what these values mean, or if you don't know what to write in them, press cancel and select the Typical Settings option. You can easily change these values later.

1. In the Workgroup or Domain window enter the name of your workgroup or domain.

• A workgroup is a small group of computers on a network that enables users to work together and does not support centralized administration.
• A domain is a logical grouping of computers on a network that has a central security database for storing security information. Centralized security and administration are important for computers in a domain because they enable an administrator to easily manage computers that are geographically distant from each other. A domain is administered as a unit with common rules and procedures. Each domain has a unique name, and each computer within a domain has a unique name.

If you're a stand-alone computer, or if you don't know what to enter, or if you don't have the sufficient rights to join a domain - leave the default entry selected and press Next.

If you want to join a domain (NT 4.0 domain of W2K/2003 Active Directory domain) enter the domain's name in the "Yes, make this computer a member of the following domain" box.

To successfully join a domain you need the following:

• The person performing the installation must have a user account in Active Directory. This account does not need to be the domain Administrator account.

and

• The computer must have an existing computer account in the Active Directory database of the domain that the computer is joining, and the computer must be named exactly as its domain account is named.

or

• The person performing the installation must have appropriate permission to create a domain account for the computer during installation.

Also, you need to have connectivity to the domain's domain controllers (only to the PDC if on an NT 4.0 domain) and a fully functional DNS server (only in AD domains). Read the Joining a Domain in Windows XP Pro and Requirements when Joining a Domain pages for more on this issue.
Enter the Active Directory domain name (in the form of xxx.yyy, for example: DPETRI.NET) or the NetBIOS name of the NT 4.0 domain (in the form of xxx, for example: DPETRI). Press Next.
Note: If you provide a wrong domain name or do not have the correct connectivity to the domain's DNS server you will get an error message.
A username/password window will appear. Enter the name and password of the domain's administrator (or your own if you're the administrator on the target domain).

Note: Providing a wrong username or password will cause this phase to fail.

1. Next the setup process will finish copying files and configuring the setup. You do not need to do anything.

1. After the copying and configuring phase is finished, if Windows Server 2003 finds that you have a badly configured screen resolution it will advise you to change it and ask you if you see the new settings right.

BTW, the minimum supported screen resolution in 2003 is 800X600.

1. Setup finishes and boots Windows Server 2003.

1. That's it! you're done!

Continue Reading

How to Install Windows XP ? – Step By Step Guide To Clean Installation of XP

Why Do We Need To Re-install Windows XP?

You need a “clean install” of Windows XP when you got millions of viruses in your computer or you had tried every thing to restore your windows by using anti virus or system restore tools etc. A brand new hard drive also needs to install clean XP. A clean install simply means formatting the hard drive ( only C drive ) and reinstalling the operating system, puts the system back in the state in which you first got the machine.

Before You Proceed With The Installation

Backup your important data before you begin this process! (If you have multiple partitions on your hard drive, data on partitions other than the system partition “except C drive” will not be affected with the following steps, but a backup is still recommended to be on the safe side). You will also have to re install all the softwares you were using in your previous XP.

NOTE : Use these instructions at your own risk!. Only users experienced in installing, troubleshooting, and making repairs to Windows Operating Systems should attempt to follow these instructions on their own. If you choose to proceed, be aware that GetPcMemory assumes no responsibility for any problems encountered.

Step 1 : Prepare The Boot Sequence

Insert the windows XP cd in your cdrom and than go to the BIOS by hitting “DEL” or “F12″ when your system in powering on. Go to Boot order and make sure cdrom is on the first place.
Save settings and restart your computer.
Once you have successfully booted from the CD, you will see the Windows XP “Welcome to Setup” screen. Press ENTER to begin the setup process.

Step 2: Accept the license agreement

When you see the Windows XP license agreement press F8 to accept it and proceed.

Step 3: Searching for Previous Versions of Windows XP

Setup will search for existing Windows installations. You will see the next “repair or install fresh copy” screen appear only if a Windows installation currently exists on your machine. If you’re installing on a brand-new hard drive, skip to Step 5.

Step 4:Continue Installing a Fresh Copy

Press ESC. You will be given a list of partitions available on your hard drive.

Step 5: Partitions

If there are multiple partitions on your hard drive, or you have multiple hard drives in the computer, use the UP or DOWN arrow keys to choose your install partition. Please note that your system partition needs to be a primary partition (usually the first partition that shows up in the list), not a logical partition.
The partition should be at least 10 GB in size. Make sure that all the data you need from this partition is copied elsewhere, because it will be deleted.
Once you have selected the right partition selected, press ENTER. You will see the next “you already have a system installed” screen only if you already have Windows installed on this partition. If you are installing on a brand-new hard drive, skip to Step 7.

Step 6: Continue Installing On The Selected Drive

Press C to continue. You will be given a list of install options
/

Step 7: Format The Selected Partition

Select the option to “Format the partition using the NTFS file system (quick) and press ENTER.You will receive a warning about formatting the drive unless the drive is brand-new.

Step 8: Continue With The Format

Press F to continue formatting selected partition. If you still haven’t backed up, this is the last change to backup your important data, after this step you will not to able to go back and restore your data.

Step 9: Copying Files

After the format setup will automatically copy files and restart your computer. Go to BIOS and remove cdrom from first boot device. Start your computer.
/

Step 10: Automatic Installation After Restart

Setup will continue to install after the restart. it will ask you for the product key and user name etc. Fill the forms yourself.

After The Installation

Install the missing drivers because windows XP will install a limited set of drivers,you’ll have to find the rest. To see which drivers you’re missing, go to the Control Panel > System > Hardware tab > Device Manager. Things next to a Yellow exclamation is a missing driver. You’ll need to reinstall these drivers from a system CD that came with your computer or download them from the manufacture’s website.

Continue Reading