Block Or Unblock Websites without software !

Block Or Unblock Websites without software !

Many times in schools, colleges & offices surfing some sites like orkut,etc are banned !

To overcome this you can unblock these or block some other websites and play pranks !

Do The Following :

For eg you want to block www.xyz.com !

* Open the folder C:\WINDOWS\system32\drivers\etc

* There you will find a file named HOSTS

* Click on the file and press SHIFT and now right click on it .

* From the right click menu select Open with .

* Now, select Notepad to open the file from the list !

* Now, in the file under the line 127.0.0.1 localhost add another line as127.0.0.2 www.xyz.com.

* Now, File>>Save !

Now, open your web browser and try openning www.xyz.com , it will not load !

To unblock sites just do the opposite !

Make Your Own Icons In Windows XP !

Make Your Own Icons In Windows XP !

Now even personalize your ICONS with Windows XP !

To make your own ICON :

1. Start>>All Programs>>Accessories2. Click Paint
3. In toolbar select Image4. Click Attributes

--------------------- Note : The size of a icon is 32 x 32 pixels ! ---------------------

5. Type 32 in both Height and Width and sure that Pixels is selected under Units6. Click OK
7. Now add your photo or design .
8. File>>Save As
9. Type name.ico10. Click Save
Enjoy your New ICON !!!

Hide Files in Image Files !!!

Sometimes we are eager to hide some files on the system !!!
(I won't ask Why ???)

http://pcremix.blogspot.com/
So, now i have got a trick to hide files in image files !!!
Here it is :

** You require WinRAR installed on your PC for this trick.
** First add your files to .rar and i.e. say files.rar
** Say you have a image as img.jpg** Now, save files.rar and img.jpg in c:\ drive.
** Click start >> Run** Type cmd** Now in command prompt type cd..** Again type cd..** Type copy /b img.jpg + files.rar new.jpg

-------------- Please Note --------------
>> This command will concatenate the two files into the new file new.jpg
>> Don't type files.rar + img.jpg instead of img.jpg + files.rar.
>> Now, (size of new.jpg) = (size of img.jpg) + (size of files.rar) .

-------------------------------------------


*** Mission Accomplished !!! ***

Now, we have new.jpg consisting of both img.jpg and files.rar .

Accessing the files :
** Double click new.jpg and img.jpg can be viewed.

** Now, to access files.rar :
# Right click on new.jpg >> Select Open With >> Choose Program...# Select WinRAR archiver.
# Now, simply Extract your files !

Enjoy... Please Comment if you liked my work !!!

Access Your Folders as Drives

Well, this is my EXCLUSIVE !!!

Trick is all About :

You can create Virtual Drives in your Computer. Now you can access your Favorite Folders as a drive in My Computer.

What you can do ?

** Access your folders as a Drive !

** Fool 'Computer Beginners' or your 'Friends' (Non-Expert) , as the drive will show Disk Space of the folder's drive so it seems that the disk space has increased !!!

Do The Follwing :

► Start >> Run

► Type cmd and hit Enter

► This will open "Command Prompt"

► Type subst Z: E:\folder and hit Enter key.

→ You can replace Z: with your desired New Drive Letter (Except existing Drive letters)!

→ You can replace E:\folder with the path of your favorite folder !

► Now, type exit

*** This creates a new drive ! When you open this , it will open your folder !!!

*** Isn't it Awesome ?

*** And this is Exclusive at pcremix.blogspot.com !

-------------------------------------------------------------

But a Problem !

۩ On Restart the Virtual Drive Disappears !!!

-------------------------------------------------------------

Solution !

-------------------------------------------------------------

۩ We can make a batch file which will make the drive everytime on startup !

Here is how ?

► Open Notepad

► Type :

@ECHO OFF

subst Z: E:\folder

exit

► File >> Save As...

► Name it : Virtual Drive Emulator.bat

► Start >> All Programs

► Right Click on Startup >> Open

► This open the Startup folder

► Paste the Virtual Drive Emulator.bat file here !

*** That's all , now the drive will automatically be created when ever you start your pc

-------------------------------------------------------------

>>>> Mission Accomplished <<<<

PLEASE Comment !!!

Boost Up Internet Speed Without Software

Above 90% computers all over the world run Windows... and hence anothercomputer trick.

FACT
But do you know that about 20% of your internet bandwidth is reserved by Microsoft.
---------------------------------------------------------------------------------------------------------
Uses of Reserved Bandwidth
** Windows Automatic Updates rely on this reserved bandwidth.
** Fast loading Microsoft Websites** Sending Error Reports** Online Help support in Microsoft Office
---------------------------------------------------------------------------------------------------------
But this can be recovered back...
---------------------------------------------------------------------------------------------------------
The Remedy** Start >> Run** Type gpedit.msc** This opens the Policy Editor** Now, Local Computer Policy >> Computer Configuration** Then, Administrative Templates >> Network** Now, click on QOS Packet Scheduler** Now, on Right hand side** Double Click Limit reservable bandwidth** Now in Setting Tab

********************* NOTE **********************It says : Not ConfiguredReality : The Explain Tab says "By default, the Packet Scheduler limits the system to 20 percent of the bandwidth of a connection"
***************************************************
** So, on Setting Tab select Enabled** Now, change Bandwidth limit (%) to 0 (Zero)

********************** NOTE ********************Misconcept : This don't means that you won't be able to communicate with Microsoft or any its services !!!
Actually : This reserved Bandwidth is only to accelerate Microsoft internet connections more than other connections !!!
****************************************************
** Click OK !!!

That's All !!!

Trace Websites !

Trace Websites !

My Exclusive... another contribution to Computer Tricks !

Surfing Internet...
Type in the url and Hit Enter, that's it ?

But...
Have you ever thought what happens after that ?

Lets Trace n see what happens !

Do the following :
# Start >> Run
# Type cmd
# This will open the Command Prompt
# Type cd\
# Type tracert www.google.com

---------------------- Note ---------------------------

You can replace www.google.com with any website url.

---------------------------------------------------------

Results :
$ First line shows the IP address of the website...$ You'll be shown steps in which the website gets load !
$ More is the number of steps more is time taken to load the website !

That's all !

Please Comment...

Excel Macro tutorial, A free guide to creating macros in Excel

Creating macros using the excel macro recorder The simplest way to create a macro in Excel is to use the macro recorder. The first step is to open up the workbook (file) that you wish to use the macro in. Then click on Tools, hover over Macros and then select Record new macro from the menu. You will now see the Record Macro dialogue box as shown below in fig 1.1: There are 4 points of interest: Name - Type the name of your macro. Shortcut key - (optional) this has to be a letter, we have used h, so in our example the macro will run every time we hold down the CTRL key and press the H key. Store macro in - This would normally be the workbook you are working on (this workbook), but you can save macros into a personal macro workbook. Description - Here you can enter a description of the macro for your benefit. When you have finished filling in the information click the OK button to start the macro recorder. You will now see the macro recording box as shown in fig 1.2 below. Everything you do now in the workbook will be recorded, so manually go through the process that you want your macro to recreate, for instance adding up a column. When you have finished click on the small blue square within the macro recording box to stop recording. Playing the macro back To run the macro click on tools, hover the mouse over Macro, then select Macros. You will see the Macro dialogue box similar to that shown in fig 1.3 below, your macro should be in there ready to use. To use the macro simply select it and then click the Run button. The macro dialogue box also allows you to delete and edit macros, for instance by clicking on the Options button you can assign or change the keyboard shortcut associated with each macro. If you have assigned a keyboard shortcut to a macro then you can run it by holding down the CTRL key and pressing the associated letter.

Excel Hotkeys - keyboard Shortcuts

Keyboard Shortcut	Result in Excel 2000 - General
F1 Key	Help
F2 Key	Edit current Cell
F5 Key	Goto
F7 Key	Spell Check
F12 Key	Save file as
CTRL and A	Select entire worksheet.
CTRL and B	Toggle Bold Text.
CTRL and C	Copies the item or items selected to the Clipboard and can be pasted using CTRL and V.
CTRL and F	Displays the Find dialog box.
CTRL and H	Displays the Replace dialog box.
CTRL and I	Toggles Italic Text.
CTRL and N	New File.
CTRL and O	Open File.
CTRL and P	Print.
CTRL and S	Save File.
CTRL and U	Toggles Underlined Text.
CTRL and V	Paste the contents of the clipboard.
CTRL and X	Cut the selected item.
CTRL and Y	Redo the last undone action
CTRL and Z	Undoes the last action.
CTRL and 1	Displays Format Cells Dialogue Box
CTRL and 5	Toggles Strikethrough Text

---

---

Keyboard Shortcut	Result in Excel 2000 - Formulas
ALT and =	Autosum
ALT and F8	Macros
CTRL and ;	Insert Current Date
CTRL and :	Insert Current Time

---

---

Keyboard Shortcut	Result in Excel 2000 - Movement
Left Arrow	One Cell Left (also SHIFT and TAB)
Right Arrow	One Cell Right (also TAB)
Up Arrow	One Cell Up
Down Arrow	One Cell Down
Home	Go to End of row
CTRL and left Arrow	Go to End of Column
CTRL and Home	Go to Top of Worksheet (A1)
CTRL and End	Go to End of Worksheet
CTRL and PAGE-DOWN	Go to Next Worksheet

---

---

Keyboard Shortcut	Result in Excel 2000 - Cell Selection
CTRL and Spacebar	Select the entire Column
SHIFT and Spacebar	Select the entire Row
CTRL and A	Select Entire Worksheet
SHIFT and Left Cursor	Select all cells to the left of the active one
SHIFT and Right Cursor	Select all cells to the right of the active one

Windows XP Hotkeys - keyboard Shortcuts

Keyboard Shortcut	Result in Windows ® XP - General
CTRL and A	Selects all the items in the active window.
CTRL and C	Copies the item or items to the Clipboard and can be pasted using CTRL and V.
CTRL and F	Displays the Find all files dialog box.
CTRL and G	Displays the Go to folder dialog box.
CTRL and N	Displays the New dialog box.
CTRL and O	Displays the Open dialog box.
CTRL and P	Displays the Print dialog box.
CTRL and S	Displays the Save dialog box.
CTRL and V	Pastes the copied item or items from the Clipboard.
CTRL and X	Cuts the item or items selected to the Clipboard.
CTRL and Z	Undoes the last action.
CTRL and F4	Closes the active document window.
CTRL while dragging an item	Copy the selected item
CTRL+SHIFT with arrow keys	Highlight a block of text
CTRL+F4	Close the active document
CTRL+ESC	Display the Start menu
CTRL and F6	Opens the next document window in the active application.

Keyboard Shortcut	Result in Windows ® XP - General
ALT+ENTER	View the properties for the selected item
ALT+F4	Close the active item, or quit the active program
ALT+SPACEBAR	Open the shortcut menu for the active window
ALT+TAB	Switch between the open items
ALT+ESC	Cycle through items in the order that they had been opened

Keyboard Shortcut	Result in Windows ® XP - General
F1 key	Gives help on the active window or selected item.
F2 key	Rename the selected item
F3 key	Search for a file or a folder
F4 key	Display the Address bar list in My Computer or Windows Explorer
F5 key	Update the active window
F6 key	Cycle through the screen elements in a window or on the desktop
F10 key	Activate the menu bar in the active program

Keyboard Shortcut	Result in Windows ® XP - General
Windows Logo	Display or hide the Start menu
Windows Logo+BREAK	Display the System Properties dialog box
Windows Logo+D	Display the desktop
Windows Logo+M	Minimize all of the windows
Windows Logo+SHIFT+M	Restore the minimized windows
Windows Logo+E	Open My Computer
Windows Logo+F	Search for a file or a folder
CTRL+Windows Logo+F	Search for computers
Windows Logo+F1	Display Windows Help
Windows Logo+ L	Lock the keyboard
Windows Logo+R	Open the Run dialog box
Windows Logo+U	Open Utility Manager

Keyboard Shortcut	Result in Windows ® XP - Dialogue Box
TAB	Move forward through the options
SHIFT+TAB	Move backward through the options
CTRL+TAB	Move forward through the tabs
CTRL+SHIFT+TAB	Move backward through the tabs
ALT+Underlined letter	Perform the corresponding command or select the corresponding option
ENTER	Perform the command for the active option or button
SPACEBAR	Select or clear the check box if the active option is a check box
F1 key	Display Help
F4 key	Display the items in the active list
Arrow keys	Select a button if the active option is a group of option buttons
BACKSPACE	Open a folder one level up if a folder is selected in the Save As orOpen dialog box

Keyboard Shortcut	Result in Windows ® XP - Windows Explorer
END	Display the bottom of the active window
HOME	Display the top of the active window
NUM LOCK+Asterisk sign (*)	Display all of the subfolders that are under the selected folder
NUM LOCK+Plus sign (+)	Display the contents of the selected folder
NUM LOCK+Minus sign (-)	Collapse the selected folder
LEFT ARROW	Collapse the current selection if it is expanded, or select the parent folder
RIGHT ARROW	Display the current selection if it is collapsed, or select the first subfolder