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

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: