View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
dleo dleo is offline
external usenet poster
 
Posts: 30
Default removing specific rows in a worksheet


Select the entire column and sort. Find where all of the "store manager"s
are. Select your rows, right click (or Ctrl+click if on a mac), select Delete.

"Louise" wrote:

Hi all

I have a large worksheet containing thousands of rows beginning with the
words 'store manager'. I need to remove every row in the workbook beginning
with these two words.

Is there an easy way to do this?

Thank you.
Louise