Remove all the blank cells and rows with Go To Special command in Microsoft Excel

1. Select the range containing blank rows you want to remove.
2. Click Home > Find & Select > Go To Special.

3. In the Go To Special dialog box, check the Blanks option.

4. And then click OK, all of the entire blank rows are highlighted. Then click Home > Delete > Delete Cells,then select shift cells up then  the blank cells have been deleted from the selected range.
 
To delete rows, repeat  steps 1 to 3 then, all of the entire blank rows are highlighted. Then click Home > Delete > Delete Sheet Rows, the blank rows have been deleted from the selected range.

See screenshots:

Referred from :here

Configure WIFI from data card using wifi router.

Hi Guys,

I wanted to share my reliance data card internet through a wifi router so  bought a device called TP-LINK 3G/4G WIRELESS AND ROUTER for Rs.1550

  

I got below things in the box

1. Charger for router

2.lan cable

3. the wifi router.

First i connected the charger to router and connected.

Then i connected my data card

Then i connected the router to my Laptop thru LAN.

thats it.

Then Configuration starts.

1. I opened the browser and typed 192.178.0.254. It asked for passoword.I gave admin as username and password as admin  then Status page opened.

2. Now I clicked on Quick Setup.Then selected my country and mobile ISP: reliance .

 Then clicked on checkbox "Set the dial number ,APN,Username,Password manually" and entered username and password of reliance datacard. and clicked NEXT

3.Then in next page,I entered the Wireless network name which will be ur wifi name and then i entered password,region:India then clicked next

4. Clicked next, it asked for router restart. I said yes. Router restarted. Then clicked on the internet access button next to battery button in notification area .I could find my WiFi.

 

Note: On android phones or tablets, after switching on wifi, select the wifi name which u just configured and then enter the password which u entered.

If u want the same WiFi connection to be used on ur laptop when ur android phones are using WiFi,then U need to connect LAN cable to router and laptop,only then u can access.

If u just want to use datacard for phones or tabs, u need to connect datacard to router and router to power cord. 

P.S reliance data card supports 2g right now,still this device supports. 

Hope u configured using the steps mentioned below. Any doubt, feel free to comment.

I was unable to find any post regarding the same throughout internet.Hope this helps people like me!!

 

Apply Passport in bangalore

1. NAVIGATE TO http://passportindia.gov.in/AppOnlineProject/welcomeLink 
2. SELECT PASSPORT TYPE AND DOWNLOAD THE FORM .
3. FILL IT OFFLINE.
4. VALIDATE THE FORM BY CLIKCING ON VALIDATE BUTTON IN THE BOTTOM OF THE FORM
5. SAVE THE FORM ,this wiil generate the xml file.
6. UPLOAD THE XML FILE IN THE WEBSITE
7. PAY THE FEES ONLINE.
8. ON THE LEFT SIDE PANEL IN THE WEBSITE,CLICK ON THE LINK,VIEW SAVED FORM.
9. CLICK ON THE LINK SCHEDULE APPOINTMENT AND SELECT THE SLOT.
10. WAIT FOR UR TURN,
11. ON THE SCHEDULED DATE, TAKE THE DOCUMENTS AS REQUIRED.my pasport type was fresh and normal so i produced sslc marks card as age proof and bank statement original as address proof.aadhar card and voters id were also taken. my appointment date was 22nd Nov 2013.
12. At passport seva kendra, we need to go through counters A,B and C.Before going to these counters, pre document verification will be done and a number will be given.
13. In a\A counter, you can see ur submitted form online in the screen facing us,we can make any changes if required to the online submitted form.Photo will be taken and passport form  will be printed ,we need to sign and give our finger prints of both the hands.
14. To get appontment in B, u need to wait for an hour an half .
15. B and C will validate the form again and give us the receipt.
16. I got Status as Hold in the receipt which i got.
17. I waited for the passport form to reach police station in 1 day,but it didnt.So, i went to PSK on 26th Nov.Then they made the status of application form from on hold to Granted.
18. Then it reached my area police station on the same day.26th and all the police verification documents were submitted and the next day i.e on 27th, it reached commissioner office.
19. 
20. I was waiting for status update that my form will reach from commissioner office back to psk.It didnt reach.So, today that i.e 30th Nov,I went to commissioner office and got the form approved.Below is the status.

Hope fully, I will get my passport in 4-5 working days.

Tips for shopping

Below stuffs can be gifted :

for gals

kajal
lipsticks
makeupsets
nail polishes.
rings
bangles
clips
sandals


for boys
tshirts ,pullovers, shirts,jeans, belts,
shoes,socks
sunglasses
watches


for house,

nail cutter,
knife set,
glasses
plates
tissue papers.


Electronic items

projector
Laptop(1tb)
mobile
headset
playstation
camera
hard drive
intuos pen and touch medium tablet(link)
samsung chromebook

Root Cause for the major issues in QA for agile methodologies:

• No rule around Code Freeze
• Late Checkins (Entire stories delivered to RC Branch)(RC: Release Candidate)
• Lack of Client data sets in QA Environment (Disk Space/ Environment issue)
• Lack of involvement of QA in few Dev only issues that are not certified by the QA
• Possible GAP in the Release Management.L
 Pre-staging environment is running with stale build .  The issues uncovered during All Hands Testing (on Prestaging environment) were already known to QA and captured them in the respective tickets.  Few of them were got fixed in later builds .  Hence upgrading the environment to most recent build that is being tested in regression environment will resolve most of the issues reported by the internal customers.

Adding a custom locator type in selenium IDE

LocatorBuilders.add('css:auto', function(e) {
    var value = e.getAttribute('class');   
    if (value.indexOf('auto_') != -1) {
     var s=str.indexOf('auto_');
     alert(value.substr(s))
        return value.substr(s) ; 
    }
return null;
});

Above code needs to be added in a js file.I have named it as "csslocators.js" .The above function will extract the class attribute of the element starting with "auto_"


This js file needs to be added to SIDe as ->options->options->in side extensions.Click on browse and select the file.

if u want ur locator type to be listed first,then u can do it in side->options->options->locator builders-> rearrange the items.