Feb 17

Click on the page that you want to change the orentation of, and then go to the

Page Layout Tab, Page Setup Group, and look in the Breaks menu .

You will see four-five different section breaks you can choose. If you have an existing document, it is best to use the “Continuous” section break.

Try to change the orentation again… you will notice it will change it for the current section (section 2).

Now all the pages after that page are landscape..We just repeat the process to create a third section using the Continuous Section Break, then change the orentation back to where we wanted it to be.

It works in Office Word 2007  and 2010.



written by MG \\ tags: , , ,

Jan 05

A good tutorial:


written by MG \\ tags: ,

Jun 18

Using the following command will show the uptime of the system as well as other information:

net statistics workstation

Look for a line such as this near the top of the output:

Statistics since 6/13/2009 11:12 PM

written by MG \\ tags: ,

Jun 18

1. Place your Windows XP CD in your cd-rom and start your computer (it’s assumed here that your XP CD is bootable – as it should be – and that you have your bios set to boot from CD)

2. Keep your eye on the screen messages for booting to your cd Typically, it will be “Press any key to boot from cd”

3. Once you get in, the first screen will indicate that Setup is inspecting your system and loading files.

4. When you get to the Welcome to Setup screen, press ENTER to Setup Windows now

5. The Licensing Agreement comes next – Press F8 to accept it.

6. The next screen is the Setup screen which gives you the option to do a Repair.

It should read something like “If one of the following Windows XP installations is damaged, Setup can try to repair it”

Use the up and down arrow keys to select your XP installation (if you only have one, it should already be selected) and press R to begin the Repair process.

7. Let the Repair run. Setup will now check your disks and then start copying files which can take several minutes.

8. Shortly after the Copying Files stage, you will be required to reboot. (this will happen automatically – you will see a progress bar stating “Your computer will reboot in 15 seconds”

9. During the reboot, do not make the mistake of “pressing any key” to boot from the CD again! Setup will resume automatically with the standard billboard screens and you will notice Installing Windows is highlighted.

10. Keep your eye on the lower left hand side of the screen and when you see the Installing Devices progress bar, press SHIFT + F10. This is the security hole! A command console will now open up giving you the potential for wide access to your system.

11. At the prompt, type NUSRMGR.CPL and press Enter. Voila! You have just gained graphical access to your User Accounts in the Control Panel.

12. Now simply pick the account you need to change and remove or change your password as you prefer. If you want to log on without having to enter your new password, you can type control userpasswords2 at the prompt and choose to log on without being asked for password. After you’ve made your changes close the windows, exit the command box and continue on with the Repair (have your Product key handy).

13. Once the Repair is done, you will be able to log on with your new password (or without a password if you chose not to use one or if you chose not to be asked for a password). Your programs and personalized settings should remain intact.

written by MG \\ tags: , ,

May 07

Iif you must do this, here’s how:

  1. Press the Windows key + R on your keyboard to launch the “Run” dialog box.
  2. Type in control userpasswords2
  3. Press Enter. The User Accounts window will display.
  4. Uncheck the option “Users must enter a user name and password to use this computer”
  5. Click “OK”  or “Apply”
  6. You will then be prompted to enter the current password and confirm it.
  7. After doing so, you will no longer be prompted to enter your password upon login.

written by MG \\ tags: , ,

Apr 07

In Microsoft Excel, it is possible to combine, or concatenate, different cells of data into one cell. This article contains two examples.

Simple Concatenation

The following formula combines data from cells A1, B1 and C1. Write this formula into another column, such as column D1:


Add Spaces Between Each Column

The following formula combines data from cells A1, B1 and C1 and adds spaces between each set of data. Write this formula into another column, such as column D1:

=A1&” “&B1&” “&C1
=CONCATENATE(A1,” “,B1,” “,C1)
PS: If you have multiple rows just copy the formula to other rows.

written by MG \\ tags: ,

Apr 07

To create a compiled list of unique records, follow these steps:

  1. Select the column titles above rows or records that you want to sort.
  2. On the Data menu, point to Filter, and then click Advanced Filter. If you are prompted as follows, click OK.
    No headers detected. Assume top row of selection is header row?
  3. Under Action, click Copy to another location.
  4. Click to select the Unique records only check box.
  5. In the List range box, type or select the range of records (such as A3:H10).
  6. In the Criteria range box, type or select the same range of records (that is, A3:H10)
  7. In the Copy to box, type the address of or select the first cell where you want the information to be placed. Make sure there is enough room so you don’t overwrite pre-existing data.

    Note You can only do this in the active sheet.

  8. Click OK.

written by MG \\ tags: ,