Help With formulas to delete entire row if text contains a word

Hey there,

I am trying to clean up some data, and would appreciate help to make it go quicker. The following is an idea of what I am trying to do:

1) if (columnA1:A1000 begins with "Total", delete entire row)

2) if(in Entire workbook rows B:D are empty, (then) delete entire row)

3) if (columnA1:1000 is blank fill with text in previous filled cell)
- This one is slightly more complicated, I am trying to populate any empty cells in column A with the text from any previous cell that contains text.
- E.g. Filling left column to look like right column.
Capture.JPG


Any would help would be greatly appreciated. Thanks you!