Category Archives: Tricks & Tips

Cleanup your PC without installing any extra software

disk-cleanup_itlivesupportbd-wordpress-com

Often we use many kinds of software to clean our PC. But more software we install on our PC it would create more presser on the OS. So there is a simple solution for Windows OS user. Follow this steps –

  1. Click “Win(super key)+R“.
  2. A pop-up window will appear named “Run“. Wright “cleanmgr” in that Run window.
  3. Now a pop-up window will come named “Disk Cleanup : Drive Selection“. Select your system drive (by default C drive is the system drive for Windows OS) and click “Ok“.
  4. Now your system will check for cleanable files on your selected drive, it may take a while.
  5. After checking a pop-up window named “Disk cleanup for (C:)” will appear. Check those items you want to clean. If doesn’t understand than just click “Ok” then “Delete Folders”.
  6. Now your disk will clean up automatically within few minutes.
  7. Done.

 

Prevent losing documents & increase space of your C drive

lost-data_itlivesupportbd.wordpress.com

When Windows crash we often lost our important data in the process of OS setup, especially those who don’t use cloud backup. There is an easy solution for that. Save your documents in “Documents” folder. Then follow this steps.

  1. Go to “My computer
  2. Right click on “Documents” folder and select properties
  3. Now select “Location
  4. Wright “D:\Documents” instead of “C:\Users\your computer user name\Documents
  5. Press “Ok
  6. The pop-up window may come twice. Press Ok each time.

We are done.From now on your, all document from “Documents” folder will be saved in D drive. And it will also save and increase space of your C drive.

Check account balance in GP, Airtel, Robi, Citycell, Teletalk, Banglalink

all operators_itlivesupportbd.wordpress.com

To check the account balance press:

 

  • For GrameenPhone Press *566#
  • For Airtel Press *778#
  • For Robi Press *222#
  • For Banglalink Press *124#
  • For Teletalk Press *152#
  • For Citycell Press *811

 

symply Translate & listen any language with Mozilla Firefox

  1. Open your Mozilla Firefox browser.
  2. Click to Open menu at right corner.
  3. Select Add-ons.
  4. Type “s3.google translator” in the search bar.S3_1_itlivesupportbd.wordpress.com
  5. Now install S3.Google Translator.S3_2_itlivesupportbd.wordpress.com
  6. After installation click Restart now.S3_3_itlivesupportbd.wordpress.com
  7. Now you are ready to use this translator. Select any text from any web page then a pop-up icon will come, click that icon and it will translate your selected language in English by default. You can change the default language in settings. You can also listen audio of your selected text (only english).

Reset the login username/password of DSL modem/router

The default login username and password both are admin, if you or some had changed them but you forget them now, you need to reset the router to factory default settings.
Note: If you reset the device, the device will return to factory defaults, you will lose all your settings.
Step 1: Turn off the router.
Step 2: Press and hold the reset button on the rear panel with a pin, then turn on the router.  (Do not release the reset button when you turn on the router and Please keep holding the button for about 6~10 seconds after turning on the router).

Step 3 Release the reset button and wait for the device to reboot.
Note:
  1. Make certain that the router is powered on before it restarts completely.
  2. The default IP address is 192.168.0.1, and the default login username and password both are admin(all lower case).
  3. Ensure that the IP address of your computer is in the same subnet with the device.  It means that your computer should have an IP address 192.168.0.X (X is in range of 2~253), and the subnet mask is 255.255.255.0, the default gateway should be 192.168.0.1 which is the IP address of the router.
  4. Or, Obtain an IP address automatically.

IPV4_itlivesupportbd.wordpress.com

View your Windows PC’s details

Follow the instructions given below.

1. Create a file named info.nfo (info is the file name so you can change it as you wish but .nfo is the file format, so you can’t change it.)
2. After creating the file, you will be asked for permission. Give permission by pressing Yes.

3. Now run this file by pressing Enter. Select OK.

4. Now you can see your Windows PC’s details.

কি-বোর্ডের শর্টকাট :: Microsoft Excel Keyboard Shortcuts :: Part-9

office-excel-2013_itlivesupportbd.wordpress.com

# Microsoft Excel :

Worksheet navigation
  1. Ctrl + Home Cursor at beginning of worksheet
  2. Home Cursor at beginning of row
  3. Ctrl + Arrow Keys Moves to edge of current data region
  4. Tab Moves to next cell
  5. Shift + Tab Moves to previous cell
  6. Alt + Page Up, Page Down Move one screen to the left, right
  7. Ctrl + Page Up, Page Down Move to the next/previous worksheet
  8. Ctrl + Tab, Shift + Tab Move to the next/previous workbook 
Edit Worksheet
  1. F2 Edit active cell/put cursor at end of line
  2. Ctrl + Shift + Plus Sign (+) Insert blank cells or rows and columns
  3. Ctrl + Hyphen (-) Delete selected cells
  4. Shift + Space Bar Highlights entire row
  5. Ctrl + Space Bar Highlights entire column
  6. Shift + Arrow Keys Highlights cells
  7. Delete Clear contents of selection
  8. Ctrl + Z Undo last action
  9. Shift + F11 Insert a new worksheet