Author Archives: kate

How to rename a Worksheet in Excel 2007?

When you open a new Excel 2007 workbook, you will have three worksheets to work with by default. When you’re only using one worksheet there’s no reason to name it but if you have a lot of them, the naming thing becomes a must if you want to organize your work properly. I’ve asked a few people and they didn’t even know that you can change the name of the worksheet although it’s very simple as you will see.

Step 1: You can either double click on the sheet you want to rename (first picture) or right click on the sheet and select “Rename” from the menu (second picture).

Renaming Worksheets 1

Renaming Worksheets 2

Step 2: Type in the new name of the sheet and press Enter. Done!

Renaming Worksheets 3

How to create a Windows 7 System Repair Disc?

 

You never know what can happen tomorrow. Maibe your system will crash and you will be put in the situation of reinstalling your system. However, you can do a preemptive action like creating a repair disk before all breaks down. The System Repair Diskc can be used for booting the system but also it has some repairing tools that can help you to get back your system like it used to be.

Step 1: Click on the Start button and then type “repair” in the search box below. Usually, the first result in programs will be “Create a System Repair Disc” so click on that. You can also find the program clicking on the Start button then selecting All Programs/Maintenance/ Create a System Repair Disc.

System Repair Disk 1

 

Step 2: In the newly opened window you have to select the correct optical drive and then click on the Create disc button below. However, make sure you inserted a CD or DVD in the drive. In a few minutes you will have the disk. The last thing to do is to write something with a marker and put it in a safe place.

 

System Repair Disk 2

 

How to safely remove USB gadgets from your computer in Windows 7?

I’ve seen it a million times but that doesn’t make it right: unplugging the USB stick or other USB gadget from the computer without safely removing it from the system. You can damage the data from the storage of that device (if it has any and most do) and you even risk to damage the device itself. Most of the people who do that don’t know that this can be harmful and don’t know how to do it although it’s a simple thing that should become a reflex before physically unplugging the cable.

Step 1: Click on the little arrow on the right of the task bar to show the hidden icons, then click on the icon that looks like a USB connector with a green check mark on it.

Remove USB gadgets 1

Step 2: There will be a small pop up window. Click on the drive that you want to eject.

Remove USB gadgets 2

Step 3: Wait until a dialogue box saying it’s “Safe to Remove Hardware”, then unplug the USB cable or device from the computer.

Remove USB gadgets 3