find values in a column with first value of "0"

**ammartino44** · 09-02-2014, 05:28 PM

Hello. How can I search a column for a first value of "0"? Thanks!!

**shg** · 09-02-2014, 05:32 PM

Ctrl+F, find 0* match entire cell.

**ammartino44** · 09-02-2014, 05:49 PM

Thanks. That works!! Is there a way that I can have excel automatically delete these rows? Would that require vba?

**ammartino44** · 09-02-2014, 05:51 PM

What does the "*" mean? And what does match entire cell do (as opposed to a normal find)

**shg** · 09-02-2014, 05:56 PM

Is there a way that I can have excel automatically delete these rows?

Press the Find All button, press Ctrl+A in the list of found cells to select them all, Delete > Delete Sheet Rows

Originally Posted by ammartino44

What does the "*" mean? And what does match entire cell do (as opposed to a normal find)

See Help for Find or replace text and numbers on a worksheet

**ammartino44** · 09-02-2014, 06:23 PM

Oh nice. Thank you!!

**shg** · 09-02-2014, 06:36 PM

You're welcome.

Re: find values in a column with first value of "0"