Join the social network of Tech Nerds, increase skill rank, get work, manage projects...

How to Read Multiple Rows in Excel Sheet by Using XLRD in Python

I am currently using xlrd in python to read excel sheet. In column 1 contains test titles and column 37 contains test step. In column 1, there are some cell values like heading/Test case etc. I want to read all the rows in column 37 which are ...

How to highlight duplicate values in Google sheet

Hi Guy, I am doing some analysis on my Google sheet (Google Excel). One of the column i.e 'E' of this contain the URLs. Need to highlight all Duplicate URL in same column certain color like RED. I know this is possible. But don't know step for...

How to remove Blank Rows in Google Spreadsheet?

Hi, While working on Google spreadsheet, I need to delete the blank rows from my sheet, as shown in screenshot below. In the above screenshot in column B, I have Names and after each Name there is an empty row, I want no empty r...

My number value is overwritten by #NUM!

The column which now shows #NUM! had values like 20000, 4000. It earlier had values like mentioned above. I copied a row, pasted it in another row and darn! It got messed up... FYI- This sheet uses Tables.

Blue Line in Excel

Hi Guys, Can anyone tell what is this blue line I am seeing in my excel? This excel has lot of data and formula. Thanks
Sign In

Sign up using

Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: