Posts

How to add text to the beginning or end of all cells in Excel?

Image
 How to add text to the beginning or end of all cells in Excel? Sometimes you may need to add same specific text to the beginning or end of all cells in a selection. If you added the text to each cell manually one by one, it must be time-consuming. Are there easier ways? Yes, there are many easy tricks to add same text to the beginning or end of all cells in a selection. Suppose you have a name roll as following screenshot shows, and the follow methods will guide you add specified text at the beginning and end of each cell in A1:C5. There are two formulas to add specified text to the beginning or end of all selected cells in Microsoft Excel.  Method 1: & formula Enter the  ="Class A: "&A1  in Cell E1, and copy this formula to other cells with dragging the bottom right corner of the Cell E1. Method 2: Concatenate formula Enter the  =Concatenate ("Class A: ", A1)  in Cell E1, and copy this formula to other cells with with...

Steps to include Indian Rupee Symbol Font in MS Word and Excel

Image
Steps to include Indian Rupee Symbol in MS Word and Excel Download the file .  Rupee Font Version 3.0 Extract the files. (You will need winrar or 7zip installed in your PC to extract the files) Double click on the Rupee_Font_Installer.exe Click on "Install" button Done. :)       Go to setting ----- > Control panel ------> Regional & Lang Option ------> Customize ------> then click Currency tab Put currency symbol as " ` " click ok Open Excel Go to format cell (Ctrl + 1 command) Click to Number tab ------- > select currency as " ` " & ok it. Select fonts as Rupee_Foradian.ttf open a excel sheet get into--->insert then click (symbol) as given in above image Then select the font ( Rupee Foradian ) then click the Indian Rupees Symbol then insert it like above... Select font as Rupee Foradian and click the button above the tab ( ` ) when you selecting ur font as Rupee Foradian then only you can wr...

Fix Skype webcam Problem in Ubuntu

Image
                           Fix Skype webcam Problem in Ubuntu step-1              open the terminal and type this command ( sudo su ) to get root permission step-2               Then give this command on terminal ( sudo gedit /usr/share/applications/skype.desktop ) then one editor will come as given belown you have to change this line and u will get this lines in colour step-3           Delete the above given (Exec=skype) and Copy & paste this line into that ( Exec=bash -c  'LD_PRELOAD=/usr/lib/i386-linux-gnu/libv4l/v4l1compat.so skype' ) like given in below image and then save it and close the editor and type exit command in your terminal step-4            ch...

Recover Redhat 6 Linux Grub Easily

Image
RECOVER REDHAT 6 GRUB Step-1             Insert redhat DVD in your Cd drive Step-2             Select "Rescue Installed System" like given in below image Step-3            Choose-> Language on keyboard & Rescue method. Select "Local CD/DVD" for the rescue method Step-4            Next on the (Rescue Screen) select continue ok two time Step-5            Next on the " First Aid Kit Quick Start Menu " Select Shell  then shell will start like this bash.4.1# or Sh.1# Step-6 >#chroot /mnt/SysImage >#cd /boot/grub >#fdisk -l >#grub-install /dev/sda       ---> give (sda) after checking ur hdd name >#du -h      (to disk check) if u did properly it will display what i given belo...

How to get recover from Windows NTLDR missing

Image
            G et recover from Windows NTLDR missing in Windo ws 7   only 6 steps to recover do what given belown step-1            Insert windows 7 dvd in dvd drive then leave it to run then click repair your computer below install now given in picture     step-2           It will run to search Os then click next and select CMD prompt in System recovery option given Step-3         Command prompt will open then type bootrec in cmd prmt then press enter Ste p-4        Typ e bootrec /fixmbr S tep-5        T ype bootrec /fixboot Step- 6        T ype bootrec /rebuildbcd T hen restart your computer ...

HOW TO CHANGE THEME OF FACE BOOK

Image
         HOW TO CHANGE THEME OF FACE BOOK    1. First thing you should have mozila firefox on your computer  go to tools in firefox click it u can see add-ons in that click that and type stylish in search bar don't forget to login in facebook and make lik given below picture.. then firefox will ask want to restart u should restart firefox.. 2.Then type userstyles.org in url then type facebook in search bar lik given in picture ur facebook profile should be login in next tab.. 3.Then click any one of themes given in userstyles.org website like given below 4.Go to facebook page it will load for few min then look it ur facebook new theme Enjoy it...!!! & share it to ur friends

Mosquitoe Spy drone for Urban areas to track Muslims

Image
Robot Mosquitoes for Urban Areas to Track Muslims financed by (US)   Is this a mosquito? No. It's an insect spy drone for urban areas, already in production, funded by the US Government. It can be remotely controlled and is equipped with a camera and a microphone. It can land on you, and it may have the potential to take a DNA sample or leave RFID tracking nanotechnology on your skin. It can fly through an open window, or it can attach to your clothing until you take it in your home   Reports indicate that the US military has poured huge sums of money into surveillance drone miniaturization and is developing micro aircraft which now come in a swarm of bug-sized flying spies. According to various internet sources, a team of researchers at the Johns Hopkins University in conjunction with the US Air Force Office of Scientific Research at Wright-Patterson Air Force Base in Arlington, Virginia, is helping develop what they are calling a micro aerial ...